Executing Trades Through Excel

Discussion in ThinkOrSwim

Updated June 6, 2020

Top Posters

mainstream with 1 posts (0 thanks)
Rustic with 1 posts (0 thanks)
VanDriver with 1 posts (0 thanks)
petergunz with 1 posts (0 thanks)

2,911 views
0 thanks given
4 followers

Search this Thread

Executing Trades Through Excel

May 30th, 2020, 12:54 AM	#1 (permalink)
mainstream Chicago, IL Elite Member 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.

Can you help answer these questions
from other members on NexusFi?

US Treasury Weighs Direct Oil Futures Market Interventio …

Commodities

Victory Day Delivers: Russia-Ukraine Ceasefire Market Cl …

Prediction Markets & Event Contracts

Irans Answer Due Today: Peace Surges to 33.5%, Invasion …

Prediction Markets & Event Contracts

Al Arabiya: US-Iran Draft Deal Within Hours Contains Hor …

Prediction Markets & Event Contracts

Prop Firms Are Banning Gold Trading as Record Prices Mak …

Funded Trading Evaluation Firms

Best Threads (Most Thanked)
in the last 7 days on NexusFi

Sober Journey With S&P

22 thanks

2026 Jlab journal

10 thanks

Trying to learn Volume and price action correlation

8 thanks

Algo automated / semi-automated trading anyone?

6 thanks

Hello Im new here

5 thanks

May 31st, 2020, 02:53 PM	#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?

May 31st, 2020, 03:42 PM	#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.

June 6th, 2020, 06:11 PM	#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.

Last Updated on June 6, 2020

NexusFi

About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top

no new posts