NexusFi: Find Your Edge


Home Menu

 





Executing Trades Through Excel


Discussion in ThinkOrSwim

Updated
      Top Posters
    1. looks_one VanDriver with 1 posts (0 thanks)
    2. looks_two petergunz with 1 posts (0 thanks)
    3. looks_3 mainstream with 1 posts (0 thanks)
    4. looks_4 Rustic with 1 posts (0 thanks)
    1. trending_up 2,987 views
    2. thumb_up 0 thanks given
    3. group 4 followers
    1. forum 3 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
 mainstream 
Chicago, IL
 
Experience: Master
Platform: Kinetick Ninja Trader <7>
Broker: Ninja & IB
Trading: YM & Equities & Options & Mutual Funds
Posts: 174 since Jun 2010
Thanks Given: 57
Thanks Received: 89

So you may or may not know that it is fairly easy to have real time equity, option and futures data populate into an excel spreadsheet, by using the export to Excel from TOS and Pasting into a blank Excel spread sheet.

The way it was explained to me is that the processing power of Excel is greater than most trading software and since indicators are simply math equations, using excel to generate numeric versions of a chart indicator is simply a matter of writing the equation...

So the question, if any of you'all have any experience with this, how do you:

1.) Execute a trade with order specifics
2.) Set targets and stops
3.) Manage a position

Thanks in advance. Good trading to you all.


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Czechia Live at 52.5% as England Rides 4-2 Wave to Co-Fa …
Prediction Markets & Event Contracts
Kalshi Sets $4.13B All-Time Weekly Record as Polymarket …
Prediction Markets & Event Contracts
S&P 500 Holds the Line: No Fast Track for SpaceX, Op …
Stocks and ETFs
April Jobs Beat Flips Fed Hike Odds Past 52% for First T …
Traders Hideout
Warsh Opens Today, Hormuz June 19 -- WTI Below $80, Fran …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
8 thanks
Darmok and Jalad at Tanagra
1 thanks
  #2 (permalink)
Rustic
Bucharest
 
Posts: 26 since Mar 2020
Thanks Given: 9
Thanks Received: 15

Trade using excel? I can't see how this could make taking trades any easier.
I am probably missing something here.
Can you send me an example file?


Reply With Quote
  #3 (permalink)
VanDriver
Jackson, MS
 
Posts: 34 since Dec 2015
Thanks Given: 1
Thanks Received: 5


RTD (real time data) is a one way Communication method from thinkorswim into excel. It has many uses some of which you listed, others you may not have considered such as storing data or running calculations that would be difficult in thinkscript. You cannot submit orders using real time data. You must execute orders in the thinkorswim platform Itself. TD Ameritrade does offer other execution methods through it’s API service, but that is not Real time data with excel.


Reply With Quote
  #4 (permalink)
petergunz
Detroit, MI
 
Posts: 22 since May 2020
Thanks Given: 9
Thanks Received: 20

I have been wanting to export some data to excel from TOS for backtesting purposes. Specifically, I'd like to know the probability of hitting my profit target. Even so, I don't think you can apply previous years to the new post COVID-19 markets, but it would still be good data to have whenever this volatility drops. I actually developed callouses from typing so much collecting data. Well that and watching the interest rate all the damn time, lol. I've decided to get a second screen, which should decrease my clicking back and forth.


Reply With Quote




Last Updated on June 6, 2020


© 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