Thanks for the details. I think the salesman was just trying to sell you on his regular product. Just because Hoadley can use real-time data doesn't mean he needs it. End of day snapshots off the CME web site would be fine. As he says, the best way is if data is all taken at the same point in time. A lot of people turn off real-time updates when using OptionVue and other options products because the bid-ask quotes are too wide and noisy intraday to have any meaning. But I personally would not want to pay the on going fee to esignal either in any case. It would not be that hard to write a program to download the end of day settlements off the CME web site. I have written software to get it off my broker but I cannot share it.
i'm going to use the worksheet that comes with interactive brokers connect it to hoadly and stream quotes into it if i can get away with it.. .. i agree with you about bid ask spread.. you might have to script in something to take midpoints for the thing to really make any sense..
I think it should work with effort. If you can get it into Excel one way or another, then worst case you can dump it out in his format and then reimport it onto his pages...or hopefully just copy it over within Excel......
yeah but the first hurdle you run into is that the visual basic macros are password protected on the sheets.. that i think i can crack.. i'm not going to redistro his stuff so no guilt about it
I am looking at the Hoadley info page for the Implied Volatility calculator and it seems to take the mid-point between bid/ask for the IV. Presumably just feed it in and the software does the rest. Not sure what happens if you only input settlement prices though, perhaps you could test and advise?
BTW on books forgot to mention Options Trading: The Hidden Reality by Cottle. Available new and used on Amazon marketplace. There is also a pdf floating around if you can stand to read a book on your computer.
I'm tempted to get an iPad for this sort of stuff but the absence of the office suite deters me. No kindle either, I prefer real books.
i got a galaxy samsung 10 inch tablet a while ago.. my brother got me one of those bluetooth keyboards.. i use it when i'm chillin at starbucks to read and of course respond to forum posts