I've been having the error consistently for several weeks, doesn't seem to effect anything. I wouldn't worry except that I'm finally about to start automating the dozens of portfolio's I'm running and their reports and am worried that the error message will cause the code execution to break. I might try contacting CME but in my past experience their customer service is not good.
Try running your "c:\SPAN4\RptModule\spanReport.hta C:\SPAN4\Risk.xml" as a separate batch file and have it placed in the "C:\Span4\RptModule" or any other subfolder within "C:\Span4". It appears as though the spanReport.hta is looking to find the Reports folder in a particular location.
One the error it states: "..//reports/rptBatch.log" which looks sort of like the old DOS command when you would type in "CD.." backing you out one folder level. When I did this it ran the reports and did not generate an error. Even tried placing it in the "C:\Span4\Data" and it worked as well.
I'm using your spreadsheet to do some backtesting - I'm looking up prior option premiums for a certain strike in the past at different dates. It works well by typing in the prior date in the past in A1, and then downloading the data, and then copying down the premium and IM. Then I'd repeat with another date.
I was wondering if there is anyway to put in multiple dates, and have it download and calculate the margin and premium at a certain strike for different dates?
Here's a few of the features:
-Added Scanner and Historic tools
-Internalized calculations to eliminate the need of a Temp tab
-Extracted more data from pa2 files, reducing need for data to present in the code and making it easier to add new commodities
-Increased the speed of the code by utilizing arrays to minimize the number of times the pa2 files need to be scanned
-Added the ability to select SPAN or Total IM
-Added futures price, historic volatility and implied volatility to option data extracted
Special thanks to Ron, Kevin and Jay for ideas and troubleshooting to help me make this better.
-Fixed ROI sort on scanner to include column G
-Fixed contract sort on scanner to include column G
-Fixed contract sort on scanner to sort by futures then option then strike
-Fixed issue with SOM compounding on tracker that was calculating incorrect margin
-Added sort ROI / contract on tracker
-Added erase all results on tracker
-Cell A3 is now selected on historic after changing dates / before running calculations
-Fixed blank rows causing error in calculation
-Changed ROI to 365/DTE/12*net premium/(IM*IM Multiplier)
-Changed instructions on hist tracker added a helpful hints form
-pa2 files are now saved with date in name unless Setup A18 is changed, then back to old way
-Added clear tracker results if no option data in columns A-D
-Cabinet settlement price displayed as 0.5
-Fixed grain price adjustment
-Added more date tools for historic
-Fixed error with option at expiration causing error in calculations
The following 20 users say Thank You to Dudetooth for this post:
Just clicking the "Thanks" button wasn't adequate to express just how extraordinarily good your Excel SPAN margin calculator sheet is now!! I'm pretty much out of superlatives - I think "Wow" gets close though!
Thank you very much @Dudetooth!! It is appreciated more than you could know!