FTSE 100 data feed for excel and setup

jsc

Member
84 13
Hi,
Just want the cheapest way to feed live prices, tick by tick, into a spreadsheet on excel.
I need to be able to stream at least 100 stocks simultaneously with minute by minute data for the past 20 days.
The data needs to update into the spreadsheet automatically for all the stocks in the ftse 100 constantly while the markets are open.
A simple DDE feed would probably do it.

Also, how do i set up my other spreadsheet to update automatically at the end of the day with historical price data that is free, without downloading it from yahoo and manually entering it into the spreadsheet for every stock individually. How can i set it up to update automatically when i boot up in the morning :?:

Thanks (y)
 

A Dashing Blade

Experienced member
1,373 170
. . .
A simple DDE feed would probably do it.
More likely your machine would proabably lock up. Fundamentally, DDE "pushes" data onto your spreaddy regardless of what else is happening on the spreaddy. This is the sort of thing that I wouldn't even try on a trader box.

. . .
How can i set it up to update automatically when i boot up in the morning :?:
. . .
Google for "Auto_Open"
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock