Traders Laboratory - View Single Post - Realtime Price into XLS Cell
View Single Post
  #1 (permalink)  
Old 09-23-2007, 06:35 PM
aidaweb01's Avatar
aidaweb01 aidaweb01 is offline
aidaweb01 has no status.

Trader Specs
 
Join Date: Nov 2006
Location: London
Posts: 27
Thanks: 0
Thanked 1 Time in 1 Post
Realtime Price into XLS Cell

Hi guys,
Quick question on linking to excel (please accept apologies if this is not the right place for this one!). I store all my trades in an excel spreadsheet. I trade per row. At regular intervals I update the spreadsheet to give me my 'near realtime' P&L. I'de like to be able to automate this so that the Tradestation price for each open position is updated in realtime. I've scoured the TS website and most XLS/TS code seems a little over complicated for my requirement. In essence what I need is - a list of symbols in one column with a list of current prices in another (being updated in realtime from a RADAR Screen)
Can any of you programming guru's help me?

Kind regards
Daniel

Reply With Quote