Computing Markowitz efficient frontiers using a spreadsheet optimiser

Markowitz showed that assets can be combined to produce an 'Efficient' portfolio that will give the highest level of portfolio return for any level of portfolio risk, as measured by the variance or standard deviation. These portfolios can then be connected to generate what is termed an 'Efficient Frontier' (EF). In this paper we discuss the calculation of the Efficient Frontier for combinations of assets, again using the spreadsheet Optimiser. To illustrate the derivation of the Efficient Frontier, we use the data from the Investment Property Databank Long Term Index of Investment Returns for the period 1971 to 1993. Many investors might require a certain specific level of holding or a restriction on holdings in at least some of the assets. Such additional constraints may be readily incorporated into the model to generate a constrained EF with upper and/or lower bounds. This can then be compared with the unconstrained EF to see whether the reduction in return is acceptable. To see the effect that these additional constraints may have, we adopt a fairly typical pension fund profile, with no more than 20% of the total held in Property. The paper shows that it is now relatively easy to use the Optimiser available in at least one spreadsheet (EXCEL) to calculate efficient portfolios for various levels of risk and return, both constrained and unconstrained, so as to be able to generate any number of Efficient Frontiers.

Keeping Hertfordshire green: the implementation of strategic environmental policy 1983-1993

This paper evaluates the implementation of environmental policy in the County of Hertfordshire during the 1980's and early 1990's. It emphasises that the recent growth of interest in environmental policy and sustainable planning initiatives should not cause researchers and practitioners to ignore the long history and experience of environmental policy implementation in local government. By looking at the experience of strategic environmental policy in Hertfordshire, the paper identifies the successes and failures of a range of implementation tools utilised by the County and district planning authorities to progress policies concerned with the conservation and improvement of urban and rural environments. It concludes that the planning authorities of Hertfordshire have stabilised the deterioration in the County's environment and have established some programmes which provide good examples of coordinated action in environmental policy implementation. These types of mechanism will need to be built upon in the new policy epoch where environmental sustainability and capacity planning take centre stage.

The impact of the catechol-O-methyltransferase genotype on vascular function and blood pressure after acute green tea ingestion

SCOPE: Evidence for the benefits of green tea catechins on vascular function is inconsistent, with genotype potentially contributing to the heterogeneity in response. Here, the impact of the catechol-O-methyltransferase (COMT) genotype on vascular function and blood pressure (BP) after green tea extract ingestion are reported. METHODS AND RESULTS: Fifty subjects (n = 25 of the proposed low-activity [AA] and of the high-activity [GG] COMT rs4680 genotype), completed a randomized, double-blind, crossover study. Peripheral arterial tonometry, digital volume pulse (DVP), and BP were assessed at baseline and 90 min after 1.06 g of green tea extract or placebo. A 5.5 h and subsequent 18.5 h urine collection was performed to assess green tea catechin excretion. A genotype × treatment interaction was observed for DVP reflection index (p = 0.014), with green tea extract in the AA COMT group attenuating the increase observed with placebo. A tendency for a greater increase in diastolic BP was evident at 90 min after the green tea extract compared to placebo (p = 0.07). A genotypic effect was observed for urinary methylated epigallocatechin during the first 5.5 h, with the GG COMT group demonstrating a greater concentration (p = 0.049). CONCLUSION: Differences in small vessel tone according to COMT genotype were evident after acute green tea extract.

Evaluation and comparison of SYBR Green I Real-Time PCR and TaqMan Real-Time PCR methods for quantitative assay of Listeria monocytogenes in nutrient broth and milk

Specific traditional plate count method and real-time PCR systems based on SYBR Green I and TaqMan technologies using a specific primer pair and probe for amplification of iap-gene were used for quantitative assay of Listeria monocytogenes in seven decimal serial dilution series of nutrient broth and milk samples containing 1.58 to 1.58×107 cfu /ml and the real-time PCR methods were compared with the plate count method with respect to accuracy and sensitivity. In this study, the plate count method was performed using surface-plating of 0.1 ml of each sample on Palcam Agar. The lowest detectable level for this method was 1.58×10 cfu/ml for both nutrient broth and milk samples. Using purified DNA as a template for generation of standard curves, as few as four copies of the iap-gene could be detected per reaction with both real-time PCR assays, indicating that they were highly sensitive. When these real-time PCR assays were applied to quantification of L. monocytogenes in decimal serial dilution series of nutrient broth and milk samples, 3.16×10 to 3.16×105 copies per reaction (equals to 1.58×103 to 1.58×107 cfu/ml L. monocytogenes) were detectable. As logarithmic cycles, for Plate Count and both molecular assays, the quantitative results of the detectable steps were similar to the inoculation levels.

A green profession? A global survey of RICS members and their engagement with the sustainability agenda

Purpose – This study seeks to provide a review of the background and context to the engagement of RICS members with the sustainability agenda, and to examine the extent to which the surveying profession uses relevant information, tools and techniques to achieve the key objectives of sustainable development (or sustainability). Design/methodology/approach – The paper analyses results from a major international online survey of 4,600 RICS respondent members, supported by 31 structured telephone interviews. Findings – The results suggest that, although sustainability is highly relevant to RICS members’ work, a lack of knowledge and expertise is making it more difficult for sustainability tools and other information to be used effectively. Research limitations/implications – The survey is based on a substantial number of responses which are broadly representative of the global RICS population. A key implication is that “laggard” faculties include the disciplines of commercial property and valuation. Practical implications – The research suggests that key stakeholders must work together to provide better information, guidance and education and training to “hardwire” the sustainability agenda across RICS faculties. Originality/value – This is the first truly global survey of its kind and focuses particularly on those faculties that play a major role in property investment and finance (i.e. valuation and commercial property), comparing their position with that of other faculties in an international context.

Alternatives to Sedum on green roofs: Can broad leaf perennial plants offer better ‘cooling service’?

Green roof plants alter the microclimate of building roofs and may improve roof insulation. They act by providing cooling by shading, but also through transpiration of water through their stomata. However, leaf surfaces can become warmer when plants close the stomata and decrease water loss in response to drying substrate (typically associated with green roofs during summers), also reducing transpirational cooling. By using a range of contrasting plant types (Sedum mix – an industry green roof ‘standard’, Stachys byzantina, Bergenia cordifolia and Hedera hibernica) we tested the hypothesis that plants differ in their ‘cooling potential’. We firstly examined how leaf morphology influenced leaf temperature and how drying substrate altered that response. Secondly, we investigated the relationship between leaf surface temperatures and the air temperatures immediately above the canopies (i.e. potential to provide aerial cooling). Finally we measured how the plant type influenced the substrate temperature below the canopy (i.e. potential for building cooling). In our experiments Stachys outperformed the other species in terms of leaf surface cooling (even in drying substrate, e.g. 5 oC cooler compared with Sedum), substrate cooling beneath its canopy (up to 12 oC) and even - during short intervals over hottest still periods - the air above the canopy (up to 1 oC, when soil moisture was not limited). We suggest that the choice of plant species on green roofs should not be entirely dictated by what survives on the shallow substrates of extensive systems, but consideration should be given to supporting those species providing the greatest eco-system service potential.

Toward a new generation of world climate research and computing facilities

The impending threat of global climate change and its regional manifestations is among the most important and urgent problems facing humanity. Society needs accurate and reliable estimates of changes in the probability of regional weather variations to develop science-based adaptation and mitigation strategies. Recent advances in weather prediction and in our understanding and ability to model the climate system suggest that it is both necessary and possible to revolutionize climate prediction to meet these societal needs. However, the scientific workforce and the computational capability required to bring about such a revolution is not available in any single nation. Motivated by the success of internationally funded infrastructure in other areas of science, this paper argues that, because of the complexity of the climate system, and because the regional manifestations of climate change are mainly through changes in the statistics of regional weather variations, the scientific and computational requirements to predict its behavior reliably are so enormous that the nations of the world should create a small number of multinational high-performance computing facilities dedicated to the grand challenges of developing the capabilities to predict climate variability and change on both global and regional scales over the coming decades. Such facilities will play a key role in the development of next-generation climate models, build global capacity in climate research, nurture a highly trained workforce, and engage the global user community, policy-makers, and stakeholders. We recommend the creation of a small number of multinational facilities with computer capability at each facility of about 20 peta-flops in the near term, about 200 petaflops within five years, and 1 exaflop by the end of the next decade. Each facility should have sufficient scientific workforce to develop and maintain the software and data analysis infrastructure. Such facilities will enable questions of what resolution, both horizontal and vertical, in atmospheric and ocean models, is necessary for more confident predictions at the regional and local level. Current limitations in computing power have placed severe limitations on such an investigation, which is now badly needed. These facilities will also provide the world's scientists with the computational laboratories for fundamental research on weather–climate interactions using 1-km resolution models and on atmospheric, terrestrial, cryospheric, and oceanic processes at even finer scales. Each facility should have enabling infrastructure including hardware, software, and data analysis support, and scientific capacity to interact with the national centers and other visitors. This will accelerate our understanding of how the climate system works and how to model it. It will ultimately enable the climate community to provide society with climate predictions, which are based on our best knowledge of science and the most advanced technology.

Pocket data mining: towards collaborative data mining in mobile computing environments

Pocket Data Mining (PDM) is our new term describing collaborative mining of streaming data in mobile and distributed computing environments. With sheer amounts of data streams are now available for subscription on our smart mobile phones, the potential of using this data for decision making using data stream mining techniques has now been achievable owing to the increasing power of these handheld devices. Wireless communication among these devices using Bluetooth and WiFi technologies has opened the door wide for collaborative mining among the mobile devices within the same range that are running data mining techniques targeting the same application. This paper proposes a new architecture that we have prototyped for realizing the significant applications in this area. We have proposed using mobile software agents in this application for several reasons. Most importantly the autonomic intelligent behaviour of the agent technology has been the driving force for using it in this application. Other efficiency reasons are discussed in details in this paper. Experimental results showing the feasibility of the proposed architecture are presented and discussed.

Grid computing solutions for distributed repositories of protein folding and unfolding simulations

The P-found protein folding and unfolding simulation repository is designed to allow scientists to perform analyses across large, distributed simulation data sets. There are two storage components in P-found: a primary repository of simulation data and a data warehouse. Here we demonstrate how grid technologies can support multiple, distributed P-found installations. In particular we look at two aspects, first how grid data management technologies can be used to access the distributed data warehouses; and secondly, how the grid can be used to transfer analysis programs to the primary repositories --- this is an important and challenging aspect of P-found because the data volumes involved are too large to be centralised. The grid technologies we are developing with the P-found system will allow new large data sets of protein folding simulations to be accessed and analysed in novel ways, with significant potential for enabling new scientific discoveries.

Who adopts Green Revolution (GR) technology in Ghana?

Sub-Saharan Africa in general and Ghana in particular, missed out on the Green revolution. Efforts are being made to re-introduce the revolution, and this calls for more socio-economic research into the factors influencing the adoption of new technologies, hence, this study. The study sought to find out how socio-economic factors contribute to adoption of Green revolution technology in Ghana. The method of analysis involved a maximum likelihood estimation of a probit model. The proportion of Green revolution inputs was found to be greater for the following: households whose heads had formal education, households with higher levels of non-farm income, credit and labor supply as well as those living in urban centers. It is recommended that levels of complementary inputs such as credit, extension services and infrastructure are increased. Also, households must be encouraged to form farmer-groups as an important source of farm labor. Furthermore, the fundamental problems of illiteracy must be addressed through increasing the levels of formal and non-formal education; and the gap between the rural and urban centers must be bridged through infrastructural and rural development. However, care must be taken to ensure that small-scale farmers are not marginalized, in terms of access to these complementary inputs that go with effective adoption of new technology. With these policies well implemented, Ghana can catch up with her Asian counterparts in this re-introduction of the revolution.