Hi Josh,
This is for Metastock code, which you helped. It works for one script but when I add more, it gives generate following csv. I think we need to add some code to write next symbol on next line. Something is missing. Can you please help?
Here is output.
------------
TICKER,PER,DATE,TIME,OPEN,HIGH,LOW,CLOSE,VOLUME,OPEN INTEREST
SILVERM12AUGFUT,I,20120714,14:00:00,52819,52819,52819,52819,0,287345,
SILVERM12AUGFUT,I,20120714,14:00:00,52819,52819,52819,52819,0,287345,GOLD12AUGFUT,I,20120714,13:59:59,29272,29272,29272,29272,0,15218,
SILVERM12AUGFUT,I,20120714,14:00:00,52819,52819,52819,52819,0,287345,GOLD12AUGFUT,I,20120714,13:59:59,29272,29272,29272,29272,0,15218,SILVERMIC12AUGFUT,I,20120714,14:00:00,52831,52831,52831,52831,0,150826,
SILVERM12AUGFUT,I,20120714,14:00:00,52819,52819,52819,52819,0,287345,GOLD12AUGFUT,I,20120714,13:59:59,29272,29272,29272,29272,0,15218,SILVERMIC12AUGFUT,I,20120714,14:00:00,52831,52831,52831,52831,0,150826,COPPER12AUGFUT,I,20120714,14:00:00,426.15,426.15,426.15,426.15,0,29564,
SILVERM12AUGFUT,I,20120714,14:00:00,52819,52819,52819,52819,0,287345,GOLD12AUGFUT,I,20120714,13:59:59,29272,29272,29272,29272,0,15218,SILVERMIC12AUGFUT,I,20120714,14:00:00,52831,52831,52831,52831,0,150826,COPPER12AUGFUT,I,20120714,14:00:00,426.15,426.15,426.15,426.15,0,29564,CRUDEOIL12AUGFUT,I,20120714,13:59:57,4833,4833,4833,4833,0,609500,
SILVERM12AUGFUT,I,20120714,14:00:00,52819,52819,52819,52819,0,287345,GOLD12AUGFUT,I,20120714,13:59:59,29272,29272,29272,29272,0,15218,SILVERMIC12AUGFUT,I,20120714,14:00:00,52831,52831,52831,52831,0,150826,COPPER12AUGFUT,I,20120714,14:00:00,426.15,426.15,426.15,426.15,0,29564,CRUDEOIL12AUGFUT,I,20120714,13:59:57,4833,4833,4833,4833,0,609500,CRUDEOIL12JULFUT,I,20120714,13:59:58,4790,4790,4790,4790,0,2157200,
SILVERM12AUGFUT,I,20120714,14:00:00,52819,52819,52819,52819,0,287345,GOLD12AUGFUT,I,20120714,13:59:59,29272,29272,29272,29272,0,15218,SILVERMIC12AUGFUT,I,20120714,14:00:00,52831,52831,52831,52831,0,150826,COPPER12AUGFUT,I,20120714,14:00:00,426.15,426.15,426.15,426.15,0,29564,CRUDEOIL12AUGFUT,I,20120714,13:59:57,4833,4833,4833,4833,0,609500,CRUDEOIL12JULFUT,I,20120714,13:59:58,4790,4790,4790,4790,0,2157200,ZINCMINI12JULFUT,I,20120714,13:59:48,103.5,103.5,103.5,103.5,0,7299,
SILVERM12AUGFUT,I,20120714,14:00:00,52819,52819,52819,52819,0,287345,GOLD12AUGFUT,I,20120714,13:59:59,29272,29272,29272,29272,0,15218,SILVERMIC12AUGFUT,I,20120714,14:00:00,52831,52831,52831,52831,0,150826,COPPER12AUGFUT,I,20120714,14:00:00,426.15,426.15,426.15,426.15,0,29564,CRUDEOIL12AUGFUT,I,20120714,13:59:57,4833,4833,4833,4833,0,609500,CRUDEOIL12JULFUT,I,20120714,13:59:58,4790,4790,4790,4790,0,2157200,ZINCMINI12JULFUT,I,20120714,13:59:48,103.5,103.5,103.5,103.5,0,7299,ZINC12JULFUT,I,20120714,13:59:57,103.45,103.45,103.45,103.45,0,18340,
SILVERM12AUGFUT,I,20120714,14:00:00,52819,52819,52819,52819,0,287345,GOLD12AUGFUT,I,20120714,13:59:59,29272,29272,29272,29272,0,15218,SILVERMIC12AUGFUT,I,20120714,14:00:00,52831,52831,52831,52831,0,150826,COPPER12AUGFUT,I,20120714,14:00:00,426.15,426.15,426.15,426.15,0,29564,CRUDEOIL12AUGFUT,I,20120714,13:59:57,4833,4833,4833,4833,0,609500,CRUDEOIL12JULFUT,I,20120714,13:59:58,4790,4790,4790,4790,0,2157200,ZINCMINI12JULFUT,I,20120714,13:59:48,103.5,103.5,103.5,103.5,0,7299,ZINC12JULFUT,I,20120714,13:59:57,103.45,103.45,103.45,103.45,0,18340,NATURALGAS12JULFUT,I,20120714,13:59:58,158.7,158.7,158.7,158.7,0,11212500,
SILVERM12AUGFUT,I,20120714,14:00:00,52819,52819,52819,52819,0,287345,GOLD12AUGFUT,I,20120714,13:59:59,29272,29272,29272,29272,0,15218,SILVERMIC12AUGFUT,I,20120714,14:00:00,52831,52831,52831,52831,0,150826,
--------
1. Next symbol quotes are written on same line
2. I think data is getting appended in csv instead start with blank, not sure as markets are close now.
Thanks in advance.