NexusFi: Find Your Edge


Home Menu

 





Executing Trades Through Excel


Discussion in ThinkOrSwim

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




 
Search this Thread

Executing Trades Through Excel

  #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: 88

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?
New Micros: Ultra 10-Year & Ultra T-Bond -- Live Now
Treasury Notes and Bonds
Exit Strategy
NinjaTrader
Better Renko Gaps
The Elite Circle
Futures True Range Report
The Elite Circle
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
The Program
18 thanks
GFIs1 1 DAX trade per day journal
18 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


© 2024 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 - Privacy Policy - Downloads - Top
no new posts