Thank you for responding my question wasn't well worded.
I about to purchase a backtesting software, and was wondering if there was a way to export daily data so that I can compile history on a specific stock.
I am familiar with a DDE link and currently use one, however I thought there may be a way of writing a macro to export data from a specific stock into a text or csv file.
Hi Mike.....U probably have seen this but u can use yahoo downlaod quote or yahoo portfolio to download stock data directly to a CSV file read by Excel for free....here is an example link
Originally posted by mickson
I about to purchase a backtesting software, and was wondering if there was a way to export daily data so that I can compile history on a specific stock.
I am familiar with a DDE link and currently use one, however I thought there may be a way of writing a macro to export data from a specific stock into a text or csv file.
If you want to export data on an ad hoc basis. The simplest and cheapest way is to just open an advanced chart. Make sure you have sufficient data on the chart (I use a time template for this purpose which has nr. of bars / days set to 10000). Right click on the chart, choose tools, choose, Data Export, select the columns you want to export, filename, voila).
If you want to export data on a very regular basis, you can choose the option mentioned by Marginman (don't know this). May I also highly recommend Qcollector for eSignal (http://www.mechtrading.com/qcollector/esignal/ ).
I'm using this to build my own database of data, for external programs. You can set automatic downloads for symbols, if you want.
Comment