re: Russell Leslie's spreadsheet ... Arthur
Hi Arthur, firstly, let me be the first to acknowledge your efforts to add quality and interest to HC posts and would encourage others accordingly ...
Russell Leslie's mathematical (spreadsheet) approach is interesting and invariably the 'path' that materialises from the 'mist' for the seriously mathematically inclined.
GP has his XGP index which enable statistical projections according to his Sectors/Indices which provide interesting insights.
Madcow recently gave us a 'peak' at his magic chicken which is impressive and no doubt succeeds in it's design concept of providing a spreadsheet (global view) enabling long entries to stocks with high probability near term upside.
The Peter Hoadley Excel add-ins for BSOPM modeling and sensitivity analysis for derivatives traders ( I have my own) are an interesting parallel dimension for those interested in these.
Recently, I posted a couple of Excel formulae I use along with a macro written as part of I/Volatility profiling for my own spreadsheets for 'Rem Buffalo Cruncher' ... as Russell Leslie and others macro's do aid processing ability.
I differ slightly to Madcow's 'magic chicken' in that I use Metastock (madcow no doubt uses charting also...) which I have pushed to it's design limits (with templates/layouts/custom indicators) for early entries for derivatives as I prefer the 'graphical' format for this.
Data is Paritech (EOD-data director) which I have used exclusively for the last 5 years and 'live' intraday from others along with market depth to time entries/exits as required.
My spreadsheet 'buffalo cruncher' goes beyond Hoadley to that of 'live trading tool' by processing movements to inputs of underlying and auto-crunching BSOPM sensitivity analysis of available derivatives offerings (L&S) enabling a print out of forward time-based projections ( is that Yogi I hear entering the room ..?) and yield analysis. I use a combination of volatility/fibonnacci projections and whilst unable to test Gann mathematically; anecdotally, interesting confluences often occur ... it is outside my theoretical interest to pursue these further.
Design concept was the ability to accurately (statistically) quote the current and future fair value of any derivative at any point in time (currently 100 iterations) enabling BSOPM yield projections and entry/exit points. Will do spreads (manually) and expanding these (auto) to buy/writes etc including profit projections and analysis ...
The spreadsheet also completes (with manual inputs) all the necessary financial 'back office' functions automating the admin chores. (mrs rem likes this ...)
IMHO this is the future direction and no doubt there are other HC's quietly developing their own models according to individual preferences and would encourage like-minded spirits to collaberate on topics of interest ... of course a balance of give and take a prerequisite ... midnight oil is very expensive ...
