Automatically Exporting Data Into Excel

[mickson]

Hi

Is there a way to programme ESignal to export price/info data to an excel file automatically.

Regards

Mike

[EdKoF]

I'm not quite sure what you mean, but there is a way to link an Excel sheet to the eSignal Datafeedmanager via a DDE link.

For more info:

http://www.esignal.com/support/eSignal/Tips/tipsDDE.asp

and

http://www.esignal.com/exchange/v18_..._spotlight.asp

Cheers,


Edo.

[mickson]

Hi

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.

Thanks

Mike

[marginman]

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

INTC quote Yahoo finance site

but if u already own a DDE link, that would likely be a faster way to read in the data....

What do u plan on using to backtest, I would like to test a few things out myself..........

[mickson1]

I am looking to use the TradeSim simulation platform.

Regards

Mike

[EdKoF]

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.

Cheers,

Edo.