Register File Sharing Journals Chat Room FAQ Calendar Mark Forums Read

Advertisement







Search Forums
 
» Advanced Search

Reply
 
Thread Tools Display Modes
Old 07-02-2003, 13:39   #1
Andy
level 1
 
Join Date: Dec 2002
Posts: 61
Downloads: 0
Uploads: 0
Rep Power: 0Andy is an unknown quantity at this point
excel spreadsheet analysis

Does anyone use excel spreadsheets with a data feed to develope a trading system? I would like to find out how to get a data feed into the spreadsheet and update itself? I now have to imput the data by hand.
Andy
Andy is offline   Reply With Quote
Old 07-02-2003, 15:18   #2
jpygbp
level 3
 
Join Date: May 2002
Posts: 211
Downloads: 0
Uploads: 0
Rep Power: 0jpygbp is an unknown quantity at this point
DDE

You can use the DDE functionality of Excel to update cells as prices chage. For this to work, your data feed has to have DDE export functionality as well.

Hope this helps...

For back testing, all you would need is the OHLC prices and your own formulas.
jpygbp is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump