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,062 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?
Fabrication or Framework? Irans Denied MOU Explains the …
Prediction Markets & Event Contracts
BofA Projects $1.1 Trillion in Sports Event Contracts -- …
Prediction Markets & Event Contracts
Prediction Markets Expiry Day: Trump Eyes War Exit, $230 …
Prediction Markets & Event Contracts
US Treasury Weighs Direct Oil Futures Market Interventio …
Commodities
Zytrade: Devin Brady, CEO - Ask Me Anything (AMA)
Brokers
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Sober Journey With S&P
24 thanks
2026 Jlab journal
10 thanks
Lady Vols Primer: Trading Volatility Journal
7 thanks
Algo automated / semi-automated trading anyone?
6 thanks
Trying to learn Volume and price action correlation
5 thanks
  #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