NexusFi: Find Your Edge


Home Menu

 





Formula to get last price from ThinkorSwim to Excel spreadsheet


Discussion in Platforms and Indicators

Updated
    1. trending_up 4,318 views
    2. thumb_up 0 thanks given
    3. group 2 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
Optimax99
Vista, CA, USA
 
Posts: 1 since Jul 2017
Thanks Given: 0
Thanks Received: 0

Does anyone know how to get the ThinkorSwim feature working that gets last price of a stock or fund into Excel automatically whenever TOS is running.

I rebuilt my computer and now the formula no longer works.

The formula syntax I was using was:

= TOS|LAST!TICKER where TICKER is the ticker symbol for the stock or fund you want.


Reply With Quote

Can you help answer these questions
from other members on NexusFi?
[WTS] ATAS Lifetime ULTRA license – EU buyers only – …
Platforms and Indicators
requesting .nrd replay files from 2026 spy and qqq
The Elite Circle
My Rant with AMP Futures
Trading Reviews and Vendors
Building a free browser DOM/SMC simulator - need some ad …
Platforms and Indicators
Bitcoin’s 2022 low, 2025 high and 2026 low so far arou …
Cryptocurrency
 
  #3 (permalink)
 zazelpop 
New York, New York
 
Experience: Advanced
Platform: Ninja, ToS, IB
Trading: ES
Posts: 1 since Jul 2014
Thanks Given: 0
Thanks Received: 0



Optimax99 View Post
Does anyone know how to get the ThinkorSwim feature working that gets last price of a stock or fund into Excel automatically whenever TOS is running.

I rebuilt my computer and now the formula no longer works.

The formula syntax I was using was:

= TOS|LAST!TICKER where TICKER is the ticker symbol for the stock or fund you want.

Try this:

=RTD("tos.rtd", , "MARK", "AAPL")

Change "MARK" to close, last, bid, etc..


Reply With Quote




Last Updated on July 6, 2017


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts