Register      Login   

OCCAM Financial Technology

    
   05 September 2010 Home » News   
News
 

Seminar to Launch POW! version 1.22

May 2010

Copy of the slides

 

 

POW! 1.22 was formally launched with a seminar at the London Tower Bridge Hilton on 14th May 2009, with Malcolm Frodsham, Director of Research at IPD, as guest speaker.

The main programme included:

  • Overview of old and new in the POW! Framework
  • Principal Components, Robust Components and Missing Data
  • What do I do if my forecasts are partly based on history? Correcting the hidden assumptions of Black-Litterman
  • Compound Linear Constraints: protection against the unexpected
  • What if history had been different ? The balanced, block and calendar bootstraps
  • Direct or Indirect - how can an investor decide? EWE, Linear Risk and portfolio contsruction
  • Probability-adjusted cashflow modelling with PAC-M

followed by flash presentations on:

  • Return attribution: Mirabelli or Russell ?
  • Efficient allocation and reporting for multiple portfolios
  • Speeding up with automation: implementation of Ledoit shrinkage
  • Backtesting with dynamic constraints
  • Is my forecast insane ? How to check
  • Coherent risk budgeting

POW! version 1.22
released

March 2010

 

We are proud to announce the release of POW! version 1.22
Its many useful and user-friendly new features include:

POW! Documentation

  • all now available from Help Central on the Excel toolbar
  • context-sensitive help on more than 200 POW! functions
  • revised manuals
  • new set of Tutorial Examples
  • FAQs

POW! Frontier

  • more constraints: drawdown, contriibution, ratio, scenario..
  • change active return and/or risk scenario

POW! Robust

  • additional bootstrap methods (block, periodic..)
  • use nebulae to drill down to individual samples
  • understand how the bootstrap produces its results

POW! Toolbox

  • improved, easier Missing Robust algorithm
  • Principal Components just a special case when no gaps

POW! Backtest

  • full time-varying constraints
  • more rigorous treatment of periodicity

POW! Bayes

  • new Sanity function: does your forecast make sense ?
  • full integration with Frontier
  • orthogonality not required between prior and historic

POW! Risk

  • factor models now fully compatible with POW! Frontier
  • faster calculation

POW! Empirical

  • time-varying return contributions (Mirabelli or Russell)

POW! Mandate

  • all standard Risk/Frontier features supported.including currencies

POW! Property

  • linear risk now fuller available in POW! Risk as well as Frontier
  • enabling smaller portfolios, faster calculations

POW! Automation

  • much enhanced - now a separate module
  • time-series analysis library
  • Vector Auto Regression simulation library
  • >100 additional functions

 

IPD PAC-M model available  

October 2008

 

The new IPD/OCCAM Probability Adjusted Cashflow Model (PAC-M) is powered by the new POW! PAC module developed by OCCAM from the original prototype devised by the research team at IPD. Please visit www.ipd.com/toolkit for more information.

The model allows the portfolio manager to

  • simulate cashflows from individual property assets, and the tenancy units they comprise
  • under four different scenarios (Armageddon, Expected, Expected with Uplifts and Probability Adjusted)
  • period by period into the future, initially using existing lease data, then making user-settable assumptions about breaks, costs, the probability of renewals and so on
  • calculate equivalent yields and NPVs
  • report on the portfolio as a whole, subsets, or individual assets and units, and explore path by path the tree of events that may occur as the property ages.

IPD UK fund model new version

September 2008

 

The 2008Q2 version of the UK model has been released, including not just the latest data, but also new features such as:

  • ability to choose between annual, quarterly and monthly data periodicities
  • auto-correlation adjustments
  • ability to define returns, risks and constraints not just in terms of Total Return, but also another seven standard measures such as Income Return, Rental Value Growth and Yield, or combinations of them
  • IPD rural property investment index added.

POW! Interactive Help 

June 2008

 

To make sure you get the best out of POW!, we are now beginning to compile interactive help files. POW! is so extensive these days, that it will take a little while before the process is complete, so we are starting by documenting some of our best-kept secrets, our library of add-in functions.

Did you know you can do Black-Litterman or Principal Components Analysis in a single cell ? And now that you do, would you like to find out how to use them, and other functions like them ?

If so, let us know and if the help files you want are ready, we'll be happy to send them over; if not, we'll move them up our priority list and let you know when they are. Until 1.22 is released later this year, they won't be wired up to the functions, but the text and examples will be there.

 

 

We've moved to London!

May 2008

 

Ticehurst was  great while it lasted, but in the end we realised we needed not just a bigger office, but one nearer the City  and so many of our clients.

Our new main office is on the First Floor, 220 Tower Bridge Road, London SE1 2UP, just four buildings south of Tower Bridge itself, with splendid river views, and a ringside seat of the mayoral offices. Why don't you come up and see us some time ?

Our original Wadhurst office we will continue to use for administration. The address is The Old Vicarage, Wadhurst, East Sussex TN5 6AA.

 

 

IPD UK fund model released 

July 2007

 

We are pleased to announce the release of the POW! IPD UK Property Model, designed to assist property managers wishing to achieve an optimal allocation of their assets within the UK across Balanced and Specialist Funds as well as Direct investments.

The model will allow users:

  • to allocate optimally in absolute space, in real terms, relative to a single index, or a composite such as the AREF universe
  • to determine whether their portfolio is large enough to invest in the chosen sectors directly, or whether the greater diversification (and sometimes gearing) offered by managed funds would improve their return to risk ratio
  • to analyse the sources of risk in an existing portfolio, both prudentially and to see whether they are adequately rewarded

The data set includes:

  • the annual IPD PAS sector time-series going back to 1981
  • the individual property data assembled by Callender et al (2007) to estimate the intra-sector risk arising from imperfect diversification within sector
  • the PAS sector weightings, gearing and related data from the IPD AREF database.

ERES Conference 2007

28th June 2007

 

Robert Rice delivered his paper on Realistic Portfolio Analysis and Construction in the Absence of Detailed Stock-level Data.

Investors wishing to analyse and rebalance their portfolios often do not have detailed stock-level data, so they may assume that each sector index as it stands is a good representation of the corresponding sub-portfolio, ignoring the sector information. This assumption is unsafe if the portfolio

  • is genuinely actively managed, and/or 
  • is too small in relation to asset lot size to warrant holding an adequate number of stocks to diversify away residual and other risk.


The paper suggests a general methodology by which the investor can use the sector-level information to improve on the conventional approach, and

  • obtain a better estimate of total portfolio risk, whether in absolute terms or relative to a benchmark 
  • more accurately estimate the risk contributions of the different parts of the portfolio 
  • allocate assets more realistically
  • more specifically, decide whether commingled funds are a better choice than direct holdings for all or part of the portfolio.

Please contact us for a copy of the paper.

 

POW! Property Module released 

May 2007

 

To handle the special features of property investments, we have developed POW! Property, a new module specifically designed for property investment managers, and others for whom real estate forms a significant part of their portfolio.

Features include:

  • Equal Weighted Equivalent: the key statistic for calculating the effect of value skewness on property portfolio risk
  • Linear risk: a breakthrough in optimisation technology, introducing the risk effect of portfolio and lot size into the asset allocation decision
  • POW! Pivot: a series of add-in functions analogous to Excel's pivot tables but allowing a more powerful yet concise analysis of a given data set
  • Secure access to IPD data sets

Strategic Partnership
with IPD

April 2007

 

We are pleased to announced that we have reached agreement with the Investment Property Databank (IPD) for the development of a series of models designed for property investment practitioners.

IPD has for many years been the UK's leading provider of commercial property data, and is now rapidly expanding its services in Europe and throughout the world. For more information, see www.ipd.com

Each model will marry a particular geographical or instrument subset from IPD's extensive database to OCCAM's existing POW! range of generic optimisation and risk analysis modules. In due course, new POW! modules are planned to handle the special features of property investments.

 

We've moved !

January 2007

 

We have now completed our move to our brand-new purpose-built offices in Ticehurst, and look forward to receiving you here.

With our team continuing to grow, our beautiful office at the Old Vicarage, Wadhurst had become just too small. We have now moved to a business park at Ticehurst, 4 miles down the road, where we have four times the space - but we are working on filling it up, as you'll see from the vacancies

If you don't make it to the office-warming on 1st February, feel free to drop in any time. The best station is still Wadhurst. Please note our new address and phone number.

We will still be using the Wadhurst office for various purposes such as off-site backup. Its phone number ( 44 (0) 1892 783862) will remain as before, but will normally be switched through to Ticehurst.

 

Extended Allocation option
now available  
November 2005

 

New strength to handle intermediate allocation and analysis exercises

Since it was first released, POW! has been offered in 2 strengths:

  • AA designed for Asset Allocation, fund of funds and smaller stock allocation problems, allowing up to 240 assets in a universe, and 100 in any one portfolio
  • SA designed for Stock Allocation, offering universes and portfolios of unlimited size (subject to the memory of your computer).

Inevitably such a powerful tool as SA is more expensive than standard AA version, but may be overkill for some purposes. So now, in response to client requests, we are pleased to announce an intermediate strength at a cost-effective price:

  • EA designed for Extended Allocation and analyses requiring universes of up to 480 and portfolios of up to 200 assets

 

Risk/return attribution
implemented  
March 2005

 

Use POW! Mandate and other modules to check the performance of your allocation at levels that match your process

  • One period at a time, many periods or cumulative
  • Drill down to the detail you need
  • Graph the results - try our new Battenberg chart to compare value added/reduced with risk added/reduced

 

POW! Backtest  released  
January 2005

 

Check your methodology out-of-sample, compare ex ante with ex post

Test Bayesian, regular or bootstrap optimisation-based strategies with time-varying constraints and transaction costs

 

POW! Complete New Version (1.20)  released  
September 2004

 

Many new features added in new release. Highlights include:

  • All modules: improved security with Verisign ®, simpler installation, regular release of new builds
  • Frontier: new Linear Risk term added to handle varying lot-size - useful for property funds and private clients with "grainy" portfolios
  • Toolbox: Handle outsize matrices
  • Robust: Jackknife and regular methods added, plus new "Nebula" class to check each bootstrap instance
  • Empirical: View worst case drawdown and EVaR as well as regular and individual
  • Mandate: powerful new Action button to automate processing of multiple portfolios - up to 1200 can now be analysed and optimised at once !

     

POW! Toolbox version 1.3 released  
June 2003

 

No more worries about short and gappy data:

Standard and constrained EM plus our new robust component analysis missing data algorithms added. Also handles mixed periodicities

 

POW! Capture version 1.0beta released  
June 2003

 

Download holdings and other data from Pulse:

Private Client and Institutional Software, in addition to existing sources

 

POW! Risk version 1.1 released 
June 2003

 

New! Standard reports and graphs:

Tear sheet graphs, enhanced formatting, additional statistics

 

POW! Empirical version 1.1 released  
 May 2003

 

Bootstrap performance:

Simulation added; additional hedge funds statistics

 

19 Notes for the nervous available 
July 2002

 

What every private client fund manager always wanted to know:

about risk models, but was afraid to ask

 

POW! Empirical version 1.0 released  
February 2002

 

For all those worried about risk in hedge funds and alternative investments:

by-pass the covariance matrix and distributional assumptions and access empirical data directly for robust and downside statistics

 

POW! Robust version 1.0 released  
January 2001

 

Bootstrap optimiser:

for portfolio managers and other allocators wishing to reduce the impact of estimation risk on their decisions.Funds of funds and portfolios within portfolios

 

POW! Mandate version 1.0 released  
December 2001

 

Real-time batch and summary facilties for the busy manager with demanding clients:

  • Optimise and analyse 100 portfolios at once
  • Summarise key features in special overview reports and graphs
  • Across-portfolio comparisons and policy deviations can also be reported, statistic by statistic

POW! Bayes version 1.0 released  
December  2001

 

Combine your views with those of the market:

in a rigorous Bayesian framework, allowing for the degree of cofidence you have in thsoe views. For those who know they don't know everything and want to make the most out of what they do. Includes a generalised version of Black-Litterman

 

London Workshop at Barclays  
27th September 2001

 

Robust Alternatives to Traditional Optimisation and Risk Analysis:

  • Pitfalls in traditional optimisation
  • The reasmpled efficient frontier in action
  • Optimising risk allocation
  • Bayesian techniques in risk modelling, facor analysis and beyond
  • New products and forthcoming enhancements

 

Edinburgh workshop at Scottish Widows  
26th September 2001

 

Robust Alternatives to Traditional Optimisation and Risk Analysis:

  • Pitfalls in traditional optimisation
  • The reasmpled efficient frontier in action
  • Optimising risk allocation
  • Bayesian techniques in risk modelling, facor analysis and beyond
  • New products and forthcoming enhancements

 

POW! Risk version 1.0 released  
September 2001

 

Tailor-made risk/return analyses and charts:

based on the POW! Frontier engine, for risk managers and others 

 

Workshop and User Meeting 
Wadhurst 13th July 2001

 

Bring your own laptop and learn hands-on about:

  • Simpifying hedging with long-short assets
  • Funds of funds and portfolios within portfolios
  • BL, Bayesian estimation and reverse optimisation
  • Do resampling and bootstrapping enhance return ?
  • New products and forthcoming enhancements:
    • Easy stock selection with re-usable rules
    • Custom risk reporting
    • Flexible modelling with relocatable functions
    • Optimising on the web
     

Forthcoming conferences and seminars 
June 2001

 

Hear us speak on:

  • Integrated approaches to multi-currency bond analysis 
  • Style managment:
    • Using bayesian techniques to control exposure

and get a discount from IIR !

     

POW! Frontier version 1.40 pre-release
May 2001

 

New Optimiser Features Introduced

  • Express portfolios as numbers of shares
  • And in local currency terms
  • Handle futures and hedged assets
  • Compatible with Microsoft Excel2000
     

POW! Frontier version 1.35 released
August 2000

 

Faster handling of large problems for power users

     

Backtest Machine implemented 
June 2000

 
Backtest BARRA European and QUANTEC IRAS-XC cross-country models, or let us implement the model of your choice
     

POW! Frontier version 1.32 released
Nov 1999

 
Still wedded to risk aversion? 
Now you can select your frontier portfolio by psi or lambda
     

POW! Frontier version 1.30 released
April 1999

 
See the Efficient Frontier with new eyes using our enhanced graphics.  Define risk as probability of loss or underperformance, apply shortfall constraints and maximise target confidence - and more !
     

POW! Toolbox version 1.02 released
April 1999

 
Create risk and return models from time-series data paste the results directly into POW! Frontier or your own application
     

Use POW! Automation for Backtesting 
Feb 1999

 
How would my portfolio have performed if.....?
Backtest your models, strategies and scenarios with POW! Frontier Automation.  POW! Users can download a sample application
     

Free, fully functional Reverse Optimiser
Nov 1998

 
Download our introductory paper on reverse optimisation and free spreadsheet, together with a handy add-in for calculating portfolio risks, betas etc
 
  Print    
     
Home  |  Software  |  Advice  |  Resources
 Privacy Statement | Terms Of Use Copyright 2008 by OCCAM Financial Technology