Joined: Jan 3, 2015
Posted: Jan 3, 2015 03:48 PM
Msg. 1 of 1
I'm looking for a way to export 1800 symbols with 20 data fields into a CSV file on disk. The file would be similar to this:
Symb,Open,High,Low,Last,Bid,Ask,Tot. Vol.,Net,Net Chg. %,High 52,Low 52,Time,Bid Size,Ask Size,VWAP,Money Flow
The file would be exported every 15 to 60 seconds and done automatically during trading hours so ideally there would be an easy file export menu that can be controlled by sendkeys commands from another program. I used AutoIt3 to send mouse clicks and the file name to IQ but it frequently crashed and after a short time I got an "out of memory" error message that locked up the program. IQ is useless to me unless I find a better way to export the data.
It seems that if would be easy to at least have shortcut keys (Alt Ctrl) on the menu to replace the mouse clicking. A simple solution would be to have Alt S dump to a standard default file. The ideal solution would be to be able to select and save the file name and location and also select the times for export (example: 1st, 15th, 30th, and 60th second of each minute). I have written Visual Basic code to do this for my programs and would gladly give it to the developers but I'm sure they are much more talented at programming than I am.
Thank you very much.