Markets are closed today
Sun Jul 5, 2020
JUL<12> AUG<47> SEP<75> OCT<103>

Windows Excel RTD links with Thinkorswim data

Windows Excel RTD links with Thinkorswim data.

Panelists

Neil Gillis shared his spreadsheet that monitors multiple butterflies. Neil had a good overview of the formatting required to get RTD working.
Norm Spaulding shared his spreadsheet he uses to monitor his open positions using pivot tables.
Jim Riggio showed how to copy the OPRA code from Thinkorswim so you can paste it into your Excel spreadsheets.
Rick Rose showed his spreadsheet he uses to monitor his crude oil futures options.

Webinar Links

Webinar Notes

Mac Excel cannot do RTD.
Set display settings in TOS to 5 decimals places to minimize rounding errors.
F9 refreshes a spreadsheet RTD.
ThrottleInterval defaults to two seconds. If it is changed to -1 (manual), RTD will not update automatically.

Useful Excel Functions

Example RTD format: =RTD("tos.rtd","tos.rtd","LAST", ".SPX170421P2400" )
=TEXT(Al,"00") will format an integer to two digits
=CONCATENATE("."&$C$41,TEXT($C$42,"yymmdd"),"P",C43) will convert any date to the correct OPRA format

An excellent alternative to RTD is using QMatix's XLQ to connect market data to Excel.

295 page views

Copyright 2018-2020 Aeromir Corporation. All rights reserved. Phone 409-209-0998
Blog | Privacy Policy | Billing Policy | Disclaimer | Contact Us

IP address 3.236.108.61
Page Processing Time: 0.015 sec

Aeromir Corporation is NOT a Broker Dealer. Aeromir Corporation engages in trader education and training. Aeromir Corporation offers a number of products and services via the internet at aeromir.com. Aeromir Corporation offers web-based, interactive training courses on demand.

The webinars and seminars given by Aeromir Corporation are for educational purposes only. This information neither is, nor should be construed, as an offer, or a solicitation of an offer, to buy or sell securities. You shall be fully responsible for any investment decision you make, and such decisions will be based solely on your evaluation of your financial circumstances, investment objectives, risk tolerance, and liquidity needs.

Options and futures involve risks and are not suitable for all investors. Prior to buying or selling an option, you must receive a copy of Characteristics and Risks of Standardized Options. Copies are available from your broker, by calling 1-888-OPTIONS, or at www.theocc.com. The information on this web site is provided solely for general education and information purposes. No statement should be construed as a recommendation to buy or sell a security or to provide investment advice. You are fully responsible for any investment decisions you make. Such decisions should be based solely on your evaluation of your financial circumstances. Such decisions should be based solely on your evaluation of your financial circumstances, investment objectives, risk tolerance and liquidity needs. Supporting documentation for any claims, comparisons, statistics or other technical data in this presentation is available at Aeromir Corporation (support@aeromir.com).

Past performance is not indicative of future results. Parameters relating to past performance of strategies discussed are not capable of being duplicated. In order to simplify the computations, slippage, commissions, fees, margin interest and taxes are not included in the examples used on this web site. These costs will impact the outcome of all stock and options transactions and must be considered prior to entering into any transactions. Multiple leg strategies involve multiple commission charges. Brokerage firms may require customers to post higher margins than the minimum margins specified on this web site. Investors should consult their tax advisor about any potential tax consequences. Simulated trading programs are designed with the benefit of hindsight. No representation is being made that any portfolio or trade will, or is likely to, achieve profits or losses similar to those shown. All investments and trades carry risks.

Aeromir Corporation is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for Aeromir Corporation to earn fees by linking to Amazon.com and affiliated sites

For personal use only. All information on this web site is for your personal, non-commercial use only. Commercial use requires the written permission of Aeromir Corporation and may involve licensing fees.

THE RISK OF LOSS IN TRADING FUTURES, OPTIONS AND COMMODITIES CAN BE SUBSTANTIAL. YOU SHOULD THEREFORE CAREFULLY CONSIDER WHETHER SUCH TRADING IS SUITABLE FOR YOU IN LIGHT OF YOUR FINANCIAL CONDITION. IN CONSIDERING WHETHER TO TRADE OR TO AUTHORIZE SOMEONE ELSE TO TRADE FOR YOU, YOU SHOULD BE AWARE OF THE FOLLOWING:

IF YOU PURCHASE A COMMODITY OR EQUITY INDEX EXCHANGE OPTION, YOU MAY SUSTAIN A TOTAL LOSS OF THE PREMIUM AND OF ALL TRANSACTION COSTS.

F YOU PURCHASE OR SELL A COMMODITY FUTURE OR SELL A COMMODITY OPTION, OR IF YOU PURCHASE OR SELL AN EQUITY INDEX EXCHANGE FUTURE OR SELL AN EQUITY INDEX EXCHANGE OPTION YOU MAY SUSTAIN A TOTAL LOSS OF THE INITIAL MARGIN FUNDS AND ANY ADDITIONAL FUNDS THAT YOU DEPOSIT WITH YOUR BROKER TO ESTABLISH OR MAINTAIN YOUR POSITION. IF THE MARKET MOVES AGAINST YOUR POSITION, YOU MAY BE CALLED UPON BY YOUR BROKER TO DEPOSIT A SUBSTANTIAL AMOUNT OF ADDITIONAL MARGIN FUNDS, ON SHORT NOTICE, IN ORDER TO MAINTAIN YOUR POSITION. IF YOU DO NOT PROVIDE THE REQUESTED FUNDS WITHIN THE PRESCRIBED TIME, YOUR POSITION MAY BE LIQUIDATED AT A LOSS, AND YOU WILL BE LIABLE FOR ANY RESULTING DEFICIT IN YOUR ACCOUNT.

UNDER CERTAIN MARKET CONDITIONS, YOU MAY FIND IT DIFFICULT OR IMPOSSIBLE TO LIQUIDATE A POSITION. THIS CAN OCCUR, FOR EXAMPLE, WHEN THE MARKET MAKES A "LIMIT MOVE".

THE PLACEMENT OF CONTINGENT ORDERS BY YOU OR YOUR TRADING ADVISOR, SUCH AS A ‘STOP-LOSS OR "STOP-LIMIT" ORDER, WILL NOT NECESSARILY LIMIT YOUR LOSSES TO THE INTENDED AMOUNTS, SINCE MARKET CONDITIONS MAY MAKE IT IMPOSSIBLE TO EXECUTE SUCH ORDERS.

A "SPREAD" POSITION MAY NOT BE LESS RISKY THAN A SIMPLE "LONG" OR "SHORT" POSITION.

THE HIGH DEGREE OF LEVERAGE THAT IS OFTEN OBTAINABLE IN COMMODITY OR EQUITY INDEX EXCHANGE TRADING CAN WORK AGAINST YOU AS WELL AS FOR YOU. THE USE OF LEVERAGE CAN LEAD TO LARGE LOSSES AS WELL AS GAINS.

IN SOME CASES, MANAGED COMMODITY ACCOUNTS ARE SUBJECT TO SUBSTANTIAL CHARGES FOR MANAGEMENT AND ADVISORY FEES. IT MAY BE NECESSARY FOR THOSE ACCOUNTS THAT ARE SUBJECT TO THESE CHARGES TO MAKE SUBSTANTIAL TRADING PROFITS TO AVOID DEPLETION OR EXHAUSTION OF THEIR ASSETS. THIS DISCLOSURE DOCUMENT CONTAINS ON PAGES 13 - 14. A COMPLETE DESCRIPTION OF EACH FEE TO BE CHARGED TO YOUR ACCOUNT BY THE COMMODITY TRADING ADVISOR.

THIS BRIEF STATEMENT CANNOT DISCLOSE ALL THE RISKS AND OTHER SIGNIFICANT ASPECTS OF THE COMMODITY MARKETS. YOU SHOULD THEREFORE CAREFULLY STUDY THE DISCLOSURE DOCUMENT AND COMMODITY AND EQUITY INDEX EXCHANGE TRADING BEFORE YOU TRADE, INCLUDING THE DESCRIPTION OF THE PRINCIPAL RISK FACTORS OF THIS INVESTMENT, AT PAGES 16 - 18.

THIS COMMODITY TRADING ADVISOR IS PROHIBITED BY LAW FROM ACCEPTING FUNDS IN THE TRADING ADVISORS NAME FROM A CUSTOMER FOR TRADING COMMODITY INTERESTS. YOU MUST PLACE ALL FUNDS FOR TRADING IN THIS TRADING PROGRAM DIRECTLY WITH A FUTURES COMMISSION MERCHANT OR INTRODUCING BROKER. THE COMMODITIES TRADING FUTURES COMMISSION HAS NOT PASSED UPON THE MERITS OF PARTICIPATING IN A PARTICULAR INVESTMENT OR ON THE ADEQUACY OR ACCURACY OF THE DISCLOSURE STATEMENT.

The content of this website is provided for informational purposes only and may not be construed as an offer, for sale or purchase, of any investment product or advisory service. Such an offer may only be made to qualified individuals/entities via the appropriate offering/advisory documents.

Prior to buying or selling an option, investors must read a copy of the Characteristics & Risks of Standardized Options, also known as the options disclosure document (ODD). It explains the characteristics and risks of exchange traded options. Download the Characteristics & Risks of Standardized Options PDF.