Jim Dean Elite   Posts: 1059 Joined: 10/11/2012 Location: L'ville, GA  User Profile | Hi, Mark This is great ... thanks. I'm willing to help you enhance it, so that it deals not just with weekends and holidays, but also knows about all the special market shutdowns related to the year end accounting days, national disasters, presidential funerals, etc etc, since 1990 on through about 2040 or so (of course does not know about emergency stuff for the future ;~) I created an OLang routine to do this a long time ago, and Nirvana (Cose) used it as the basis to "check" all the US Stocks EOD data in their database to find "holes" ... and filled them (hooray) ... in fact, OmniData is now BETTER in that regard than any other datasource Cose and I investigated (Esig, Yahoo, etc). The conversion from OLang will be somewhat messy ... probably a macro. I'll need to restructure the routine a little bit so that the output matches what you are doing for the SS. I'll send you the adapted OLang indicator (used for FL column output and debugmsg output) ... you'll need to convert it to Excel-eze as you see fit. So, let me know if you're interested in incorporating this, just to dot all the i's and cross all the t's. [Edited by Jim Dean on 4/18/2014 12:41 PM] | |
