Go Back   Traders Laboratory > Trading Laboratory > Technical Analysis

Technical Analysis The technical discussion forum for traders. Moderated by mister ed.

Reply
Bookmarks
del.icio.us StumbleUpon Google Digg Facebook Furl Reddit Netscape

 
LinkBack (1) Thread Tools Search this Thread Display Modes Language
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 09-23-2007, 06:35 PM
aidaweb01's Avatar
aidaweb01 aidaweb01 is offline
Registered Trader

Trader Specs
 
Join Date: Nov 2006
Location: London
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
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
  #2 (permalink)  
Old 09-24-2007, 11:31 AM
Z_trade Z_trade is offline
Registered Trader

 
Join Date: Feb 2007
Location: New York
Posts: 41
Thanks: 6
Thanked 0 Times in 0 Posts
Re: Realtime Price into XLS Cell

Here is a link for Dll module for data exchange between TradeStation and MS Excel.
http://www.tsresearch.com/download/f...wnload/tslink/

Reply With Quote
  #3 (permalink)  
Old 09-24-2007, 12:45 PM
aidaweb01's Avatar
aidaweb01 aidaweb01 is offline
Registered Trader

Trader Specs
 
Join Date: Nov 2006
Location: London
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Realtime Price into XLS Cell

Excellent thanks very much.

Reply With Quote
Reply

LinkBacks (?)
LinkBack to this Thread: http://www.traderslaboratory.com/forums/f34/realtime-price-into-xls-cell-2543.html
Posted By For Type Date
Traders Laboratory - forumdisplay This thread Refback 09-23-2007 09:34 PM


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

Advanced Search
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 Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Smoothing out price feb2865 Technical Analysis 30 02-22-2008 11:26 PM
Free realtime chart for YM sudha78 Technical Analysis 22 11-29-2007 01:11 PM
Distinguishing Price From Value Dogpile Market ProfileŽ 5 09-09-2007 12:43 PM
Volume and Price Setups Soultrader Technical Analysis 6 04-04-2007 10:39 AM
Where does energy price go? tddrice General Discussion 0 10-08-2006 01:18 PM


All times are GMT -4. The time now is 10:39 AM.

 


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58