FTSE 100 data feed for excel and setup

This is a discussion on FTSE 100 data feed for excel and setup within the Data Feeds forums, part of the Methods category; Hi, Just want the cheapest way to feed live prices, tick by tick, into a spreadsheet on excel. I need ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Dec 16, 2008, 11:24am   #1
jsc
Joined Feb 2006
FTSE 100 data feed for excel and setup

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
jsc is offline   Reply With Quote
Old Dec 17, 2008, 1:08pm   #2
Joined Oct 2007
Not cheap, but that is the sort of functionality that you get with B'Berg & Reuters...
msrxlbp2 is offline   Reply With Quote
Old Dec 18, 2008, 12:44pm   #3
 
A Dashing Blade's Avatar
Joined Jul 2004
Quote:
Originally Posted by jsc View Post
. . .
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.

Quote:
Originally Posted by jsc View Post
. . .
How can i set it up to update automatically when i boot up in the morning
. . .
Google for "Auto_Open"
A Dashing Blade is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
FTSE data feed nscap Data Feeds 1 Oct 31, 2008 3:40am
Multi Monitor Setup and Data backup smbtnt Techies Corner 6 Feb 24, 2008 6:40am
FTSE 100 + Dow RT Data Feed Advice Please Greed Is Good Data Feeds 0 Jun 9, 2005 3:47pm
IB data proposed setup awoodj Data Feeds 2 Mar 25, 2004 3:14pm
QuoteTracker FTSE index setup Robin Technical Analysis 4 Jun 17, 2001 12:32pm

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)