Previous day data in excel

[bobvirk]

Hi,
If i want to get the previous 5 day data in excel, is it possible? As so far i am getting current day OHLC so far. If there any special code for that as for current day it is winros!high....

Thanks in advance

[GenSpoo]

To get historical data into Excel, you will need to use Visual Basic and the Desktop API (ActiveX control). It is not possible to get historical data via the DDE link.

Cheers... George

[bobvirk]

So if i have VB and Desktop API then with the scripts in file sharing section can i get the desired daily data?

I am ZERO in programming myself.

thanks in advance

Bob

[bobvirk]

So if i have VB and Desktop API then with the scripts in file sharing section can i get the desired daily data?

I am ZERO in programming myself.

thanks in advance

Bob

[Guest]

Yes, actually this program: Multiple History Requests in VB.zip already has most of what you need there already. DDE functions are being phased out, as Microsoft intends to do that as well.

[bobvirk]

I subscribed the desktop API. So i need Visual Basic now for the info? Asi need the data in EXCEL.

The link posted for the signalchart.xls does not have mucg info to work on. The macros are also not working or updating.

Thanks for the help

Bob

[Guest]

It is very difficult to instantiate the eSignal API in VBA, whereas there is plenty of sample code on how to accomplish your goal, especially the Get Multiple History example. You will need to write the code to export the data Excel, however.

[bobvirk]

So from the example spreadsheet(signalbook), i would have some lee way or no?

thx

[Guest]

I don't understand your question.

You can only get real-time prices via DDE (or a spreadsheet).

I know of some consultants that are ActiveX experts, if you would like to contact them.

[bobvirk]

Robi,
I just want the historical daily data in EXCEL. I tried to download the signalbook.xls. Everything look sgreat in that, the info i need, like the daily data for last 2 months. But still could now know how to activate the macro or fill the data.

thx in advance

bob

[bobvirk]

Also i am more interested in historical data then real time data. If i can get ot for last 45-50 days, that's it
thanks

[Guest]

There is a sample application that downloads historical data for around 100 symbols. You can retrieve the data with that application, but you would still need to export it to Excel or even a CSV file.

[bobvirk]

Can you please post the link please.

Thanks

[Guest]

It is in our File Share