How I am just starting to think about how I am going to record and monitor the performance of a mechanical short term eod system. One metric that I want to monitor is the equity curve.
For a live system - how are people recording the equity curve? My thoughts started with developing something in Excel. However, the problem with this is that I will need to record the prices daily for all open positions - this will allow me to work out MaxSysDD.
To record the daily prices for all open positions is going to require a little thought in developing the spreadsheet if I want it to be automated. i.e. do I write some automated code to pull prices from Yahoo, or do I just use my data provider, PremiumData and their Data Converter utility....
Anyway - whatever way I go about getting the pricing data it seems like it will be a little bit of work in Excel. The other option is using something like Stator-AFM which does it all for me and has integration to pull prices from PremiumData; but I feel this may be buying a Ferrari when all I need is a Toyota.
What methods / systems are people using to track the live equity curve of a system?