Connecting ThinkOrSwim to Excel-Part 3 of 4 - Locke In Your Success (2023)

Connecting ThinkOrSwim to Excel-Part 3 of 4 - Locke In Your Success (1)

Written and contributed by Rich Kaczmarek

Part 2 explained Excel’s RTD function and how it interacted with ThinkOrSwim (TOS). Excel’s UPPER function was introduced, we indirectly referenced a symbol and a ThinkOrSwim directive, and you learned a clever way to copy equations to new cells so Excel would modify just the parts you wanted modified (pinning via the $). Oh, yeah, we got live option pricing fed into the spreadsheet, too.

If you thought that was a lot of fun, wait until you see what’s in store for today.

(Before we begin, bring up ThinkOrSwim and the LockeRTD Excel spreadsheet you saved last week.)

In the last article, you found that there were RTD parameters passed from Excel to ThinkOrSwim (TOS), the 3rd parameter was something TOS had to return and the 4th parameter was the symbol for which it was to return that something. (=RTD”TOS.RTD”,, “LAST”,”RUT”), for example, returns the last price of RUT.)

It should be obvious that the 4th parameter can be any symbol you can look up in ThinkOrSwim but there’s much, much more than the LAST price that TOS can return for the 3rd parameter.

The 3rd parameter ThinkOrSwim receives is called a “Data Export Field,” as in “this is the data I wish to export from ThinkOrSwim.” What are the Data Export Fields? This is the only explanation I could find:

  • To use RTD, bring up a watchlist on the Quotes sub-tab under the MarketWatch tab, click on the Printer icon in the top right, and choose “Export to Excel”.
  • Because RTD is a function in Excel, you can take full advantage of the power of Excel with functionality such as cell referencing.
  • To see all of the functions supported in exported data, click on the “Data Export Help” option on the Printer menu.

https://tlc.thinkorswim.com/center/release/rel-04-26-2014.html#RTD

Ah, yes. The Printer icon. Of course. And that would be…where, exactly?

(Video) M3 Trading System; Solve the Puzzle of Income Trading

Connecting ThinkOrSwim to Excel-Part 3 of 4 - Locke In Your Success (2)

A lot changed since those words were written, including the removal of the Printer icon. Unfortunately, that’s pretty much it for TOS documentation. Fortunately, you’re reading this article.

Since we’re already under the Quotes sub-tab under the MarketWatch tab (MarketWatch | Quotes), we’ll start from here. You don’t have to – you could start under Trade | All Products, Analyze | Add Simulated Trades, Analyze | Risk Profile, Analyze | Probability Analysis or many other locations in the software. (It isn’t in every sub-tab, though, so you may have to hunt for it.)

Look near the top right corner and you’ll see the box that’s circled in the picture. Click it with the left mouse button, click Export, then click Help on data export:

Connecting ThinkOrSwim to Excel-Part 3 of 4 - Locke In Your Success (3)

For your dining and dancing pleasure, all the Data Export fields can be found
at the end of this article in the
Bonus (?) section.

Just to keep you on your toes, even though the menu says Help on Data Export,

  1. It doesn’t actually provide any help and
  2. They aren’t all Data Export fields.

You can find a little more about the Data Export Fields in the next section but let’s use a few of them now to get additional options data. Here’s how the last article left the LockeRTD spreadsheet:

Connecting ThinkOrSwim to Excel-Part 3 of 4 - Locke In Your Success (4)

Let’s add in a few new column headers, like this:

(Video) Round Table discussing using Windows Excel RTD links with Thinkorswim data. - March 8, 2017

Connecting ThinkOrSwim to Excel-Part 3 of 4 - Locke In Your Success (5)

Make sure your spelling is correct, everything is CAPITALIZED, and don’t forget the underscore (_) in PERCENT_CHANGE, NET_CHANGE and EXPIRATION_DAY.

For those familiar with Excel, select G2:G3 and paste it into E2:F3, then H2:N3. For those not familiar with Excel, follow these steps:

1.Select cells G2 and G3 by clicking into cell G2 and, keeping the left mouse button pressed down, drag it into G3, then release the mouse button. Connecting ThinkOrSwim to Excel-Part 3 of 4 - Locke In Your Success (6)2.Now we’re going to copy those cells. I press the <Ctrl-c> combination on my keyboard but you can also click the right mouse button and select Copy from the sub-menu. Whichever you do, you’ll see the G2:G3 selection highlighted by dashed lines instead of solid lines.

3. Go to cell E2 and click into it, then drag into E3. (The same way you did in step 1.)Connecting ThinkOrSwim to Excel-Part 3 of 4 - Locke In Your Success (7)

4. I paste what I copied by pressing the <Ctrl-v> combination on my keyboard but you can also click the right mouse button, then select either Paste Options, Paste (circled in red) or Paste Options, Formula (circled in blue) from the sub-menu:

Connecting ThinkOrSwim to Excel-Part 3 of 4 - Locke In Your Success (8)

5. Go to cell H2 and click into it, then drag into N3. (The same way you did in step 1 and step 3.)

6. Paste by using <Ctrl-v> on the keyboard or the Paste Options, Formula (circled in red, above) from the sub-menu, and you’ll end up with something like this:

Connecting ThinkOrSwim to Excel-Part 3 of 4 - Locke In Your Success (9)

(Video) Understanding the Trading Environment

Option-specific information (such as EXPIRATION) isn’t really relevant for RUT, hence the reason you see some inapplicable information in row 2 (which we’ll clean up in the next article), but everything in row 3 is usable and streaming live from ThinkOrSwim.

If you want to experiment with other symbols, select the entire row by clicking the 2 or 3 row number (circled in green), which will highlight it. Copy it (using your favorite method), click on an empty row number to select it (4 is good), and paste (using your favorite method).* Change the symbol in column B and away you go!

There are 6 reference tables (with examples) to be found as you scroll down:

  1. Data Export Fields returning any result for options or non-options (quantity 86)
  2. Data Export Fields returning any result for options (quantity 85)
  3. Data Export Fields returning any result for any underlying other than options (quantity 86)
  4. Data Export Fields which don’t return any result when used with RTD (quantity 327)
  5. All Data Export Fields (quantity 432 but 19 are CUSTOM fields, which won’t be addressed in this series of articles)
  6. Data Export Fields of April 1, 2014 (quantity 69)

One question you may have is, “Why are there 327 Data Export Fields that don’t return anything?” That’s a great question. They mostly look like Studies and Strategies for charting which, for some reason, was dumped into Help on Data Export. If it doesn’t actually export data via RTD, then why is it there? I don’t know but I’m sure the helpful ThinkOrSwim support staff would be more than happy to answer your question.

One observation you may have is that a Data Export Field may return a result for an option but not return a result (or return a bogus result) for something not an option (or vice versa). Why does DIV return N/A for an option and DIV_FREQ return ? Shouldn’t they both return nothing or at least return the same thing? Don’t worry – we’ll do some exception handling for spreadsheet modeling in the next article.

Warning 1: Make sure you know the format of result you’re expecting! If you expect a delta to be 55.32 and the result is .5532, panic may ensue.

Before panicking or fixing problems, determine if it’s real. Did it ever work and, if so, how?

Warning 2: Sometimes you’ll get a different result during Regular Trading Hours (RTH) and After Market Close (AMC). As an example, TOS recently returned an option BID_SIZE of 127300.00% After Market Close and a more understandable 889 during Regular Trading Hours.

Warning 3: It is possible Data Export Fields which don’t appear to work actually do work but they’re not being used the right way (or they’ll work in future revisions). If you find any documentation, let us know!

Final Thoughts:

(Video) Raleigh Durham Meetup Mike Schwartz Credit Spread Growth - March 12, 2020

  1. These lists were verified using ThinkOrSwim version 1880.75 during Regular Trading Hours and the results presented were captured live. Any other version of ThinkOrSwim may have a different list of Data Export Fields and/or different results (including nothing when you expect something) may present at any time.
  2. CUSTOM fields were eliminated in all but table 5, the list of all Data Export Fields. (CUSTOM connects thinkscript® results to Excel and that’s a topic for another article.)
  3. In all tables below, the equation for the first cell returning a result is =RTD(“TOS.RTD”,,$A2,B$1). All other cells use the same formula, adjusted for their respective row and column.

ADDED May 2017! TOS Custom Scripts and Excel Instructions have been added to the Resources page in the Locke Options Community.

Data Export Fields returning any result for options or non-options (quantity 86)

TOS Data Export FieldT.T160318C36
52HIGH37.12N/A
52LOW30.97N/A
ASK36.361.09
ASK_SIZE50162
ASKX36.36 N1.09 I
AV_TRADE_PRICE
AXNI
BA_SIZE36 x 50101 x 162
BACK_EX_MOVE±1.003N/A
BACK_VOL20.97%N/A
BETA0.3085N/A
Beta0.3085N/A
BID36.351.07
BID_SIZE36101
BIDX36.35 N1.07 N
BXNN
CALL_VOLUME_INDEX0.402N/A
CLOSE36.651.31
COVERED_RETURNN/A19.03%
DELTA10.5529
DESCRIPTIONAT&T INC COMT 100 MAR 16 36 CALL
DIV0.48N/A
DIV_FREQQ
EPS0.9485N/A
EX_DIV_DATE1/6/16N/A
EX_MOVE_DIFF±0.782N/A
EXCHANGECOMPOSITECOMPOSITE
EXPIRATIONN/AMAR 16
EXPIRATION_DAYN/A2016-03-19
EXTRINSICN/A0.72
FRONT_EX_MOVE±0.627N/A
FRONT_VOL24.22%N/A
FX_PAIRT.T160318C36
GAMMA00.1882
HIGH36.741.13
HTB_ETBETB
IMPL_VOL21.41%18.80%
INTRINSICN/A0.36
LAST36.361.08
LAST_SIZE9001
LASTX36.36 D1.08 N
LOW36.261.08
LXDN
MARK36.361.08
MARK_CHANGE-0.29-0.235
MARK_PERCENT_CHANGE-0.79%-17.87%
MARK_PERCENT_UNDERLYING100.00%2.97%
MARKET_CAP223,687 MN/A
MAX_COVERED_RETURNN/A19.03%
MRKT_MKR_MOVE±0.373N/A
MT_NEWS**
NET_CHANGE-0.29-0.23
OPEN36.651.13
OPEN_INT024666
OPTION_VOLUME_INDEX0.614N/A
P_L_DAY
P_L_OPEN
P_L_PERCENT
P_L_YTD
PE38.34N/A
PERCENT_CHANGE-0.79%-17.56%
PERCENT_IN_THE_COLUMNN/A1.00%
PERCENT_OUT_THE_MONEYN/A0.00%
POSITION_N_L
POSITION_QTY
PROB_OF_EXPIRINGN/A52.06%
PROB_OF_TOUCHINGN/A88.52%
PROB_OTMN/A47.94%
PUT_CALL_RATIO2.095N/A
PUT_VOLUME_INDEX0.821N/A
QUOTE_TRENDinstrument=Tinstrument=.T160318C36
RHO00.0171
ROCN/AN/A
RORN/AN/A
SHARES6152000000N/A
STOCK_BETA0.3085N/A
STRENGTH_METERRange BoundN/A
STRIKEN/A36
SYMBOLT.T160318C36
THETA0-0.0091
VEGA00.0459
VOL_DIFF3.25%N/A
VOL_INDEX21.41%N/A
VOLUME1163690788
WEIGHTED_BACK_VOL19.46%N/A
YIELD5.28%N/A

Data Export Fields returning any result for options (quantity 85 but less than 50 are useful)

TOS Data Export Field.T160318C36
52HIGHN/A
52LOWN/A
ASK1.11
ASK_SIZE379
ASKX1.11 X
AV_TRADE_PRICE
AXX
BA_SIZE442 x 379
BACK_EX_MOVEN/A
BACK_VOLN/A
BETAN/A
BetaN/A
BID1.08
BID_SIZE442
BIDX1.08 M
BXM
CALL_VOLUME_INDEXN/A
CLOSE1.31
COVERED_RETURN18.89%
DELTA0.5568
DESCRIPTIONT 100 MAR 16 36 CALL
DIVN/A
DIV_FREQ
EPSN/A
EX_DIV_DATEN/A
EX_MOVE_DIFFN/A
EXCHANGECOMPOSITE
EXPIRATIONMAR 16
EXPIRATION_DAY2016-03-19
EXTRINSIC0.715
FRONT_EX_MOVEN/A
FRONT_VOLN/A
FX_PAIR.T160318C36
GAMMA0.1889
HIGH1.13
IMPL_VOL18.72%
INTRINSIC0.38
LAST1.11
LAST_SIZE8
LASTX1.11 C
LOW1.09
LXC
MARK1.095
MARK_CHANGE-0.22
MARK_PERCENT_CHANGE-16.73%
MARK_PERCENT_UNDERLYING3.01%
MARKET_CAPN/A
MAX_COVERED_RETURN18.89%
MRKT_MKR_MOVEN/A
MT_NEWS*
NET_CHANGE-0.2
OPEN1.13
OPEN_INT24666
OPTION_VOLUME_INDEXN/A
P_L_DAY
P_L_OPEN
P_L_PERCENT
P_L_YTD
PEN/A
PERCENT_CHANGE-15.27%
PERCENT_IN_THE_COLUMN1.06%
PERCENT_OUT_THE_MONEY0.00%
POSITION_N_L
POSITION_QTY
PROB_OF_EXPIRING52.45%
PROB_OF_TOUCHING87.83%
PROB_OTM47.55%
PUT_CALL_RATION/A
PUT_VOLUME_INDEXN/A
QUOTE_TRENDinstrument=.T160318C36
RHO0.0172
ROCN/A
RORN/A
SHARESN/A
STOCK_BETAN/A
STRENGTH_METERN/A
STRIKE36
SYMBOL.T160318C36
THETA-0.009
VEGA0.0458
VOL_DIFFN/A
VOL_INDEXN/A
VOLUME84
WEIGHTED_BACK_VOLN/A
YIELDN/A

Data Export Fields returning any result for any underlying other than options (quantity 86)

TOS Data Export FieldT
52HIGH37.12
52LOW30.97
ASK36.4
ASK_SIZE86
ASKX36.40 N
AV_TRADE_PRICE
AXN
BA_SIZE26 x 86
BACK_EX_MOVE±1.007
BACK_VOL21.03%
BETA0.3085
Beta0.3085
BID36.39
BID_SIZE26
BIDX36.39 N
BXN
CALL_VOLUME_INDEX0.394
CLOSE36.65
COVERED_RETURNN/A
DELTA1
DESCRIPTIONAT&T INC COM
DIV0.48
DIV_FREQQ
EPS0.9485
EX_DIV_DATE1/6/16
EX_MOVE_DIFF±0.781
EXCHANGECOMPOSITE
EXPIRATIONN/A
EXPIRATION_DAYN/A
EXTRINSICN/A
FRONT_EX_MOVE±0.635
FRONT_VOL24.48%
FX_PAIRT
GAMMA0
HIGH36.74
HTB_ETBETB
IMPL_VOL21.48%
INTRINSICN/A
LAST36.39
LAST_SIZE100
LASTX36.39 Y
LOW36.26
LXY
MARK36.39
MARK_CHANGE-0.26
MARK_PERCENT_CHANGE-0.71%
MARK_PERCENT_UNDERLYING100.00%
MARKET_CAP223,871 M
MAX_COVERED_RETURNN/A
MRKT_MKR_MOVE±0.387
MT_NEWS*
NET_CHANGE-0.26
OPEN36.65
OPEN_INT0
OPTION_VOLUME_INDEX0.613
P_L_DAY
P_L_OPEN
P_L_PERCENT
P_L_YTD
PE38.37
PERCENT_CHANGE-0.71%
PERCENT_IN_THE_COLUMNN/A
PERCENT_OUT_THE_MONEYN/A
POSITION_N_L
POSITION_QTY
PROB_OF_EXPIRINGN/A
PROB_OF_TOUCHINGN/A
PROB_OTMN/A
PUT_CALL_RATIO2.15
PUT_VOLUME_INDEX0.827
QUOTE_TRENDinstrument=T
RHO0
ROCN/A
RORN/A
SHARES6152000000
STOCK_BETA0.3085
STRENGTH_METERRange Bound
STRIKEN/A
SYMBOLT
THETA0
VEGA0
VOL_DIFF3.45%
VOL_INDEX21.48%
VOLUME11344564
WEIGHTED_BACK_VOL19.42%
YIELD5.28%

Data Export Fields which don’t return any result when used with RTD (quantity 327)

ACT_WARNINGIntradayMomentumIndexRelativeVolatilityIndex
ADXInvertedHammerRelativeVolumeStDev
ADXCrossoverKeltnerChannelsReverseEngineeringMACD
ADXRKickingReverseEngineeringRSI
ATRKlingerHistogramRibbonStudy
ATRTrailingStopKlingerOscillatorRisingThreeMethods
AbandonedBabyLBR_PaintBarsSTARCBands
AccDistLBR_SmartADXSVEPivots
AccelerationBandsLBR_ThreeTenOscillatorSVEZLRBPercB
AccelerationDecelerationOscLegacyEMASectorRotationModel
AccumDistBuyPrLinearRegCh100SemiCupFormation
AccumDistPrVolLinearRegCh50SentimentZoneOscillator
AccumulationSwingIndexLinearRegChVarSeparatingLines
AdvanceBlockLinearRegCurveSeriesCount
AdvanceDeclineLinearRegTrendlineShootingStar
AdvanceDeclineCumulativeAvgLinearRegrReversalSideBySideWhiteLines
Alpha2LinearRegressionSlopeSimpleMovingAvg
AlphaJensenLongHaulFilterSpearman
AroonIndicatorLongLeggedDojiSpectrumBars
AroonOscillatorLookUpHighestSpreads
AwesomeOscillatorLookUpLowestStandardDevChannel
BalanceOfMarketPowerLowPriceGappingPlayStandardDeviation
BeltHoldMACDStandardError
Beta2MACDHistogramStandardErrorBands
BollingerBandsMACDHistogramCrossoverStandardErrorChannel
BollingerBandsCrossoverMACDTwoLinesStickSandwich
BollingerBandwidthMACDWithPricesStochRSI
BollingerPercentBMESASineWaveStochasticCrossover
BreakawayMajorGannLevelsStochasticFast
CCIMarkerIndicatorStochasticFull
CCIAverageMarketForecastStochasticMomentumIndex
CSIMarubozuStochasticSlow
CamarillaPointsMassIndexStressIndicator
ChaikinMoneyFlowMatHoldSwamiAccDist
ChaikinOscMatchingLowSwamiConvolution
ChaikinOscillatorMcClellanOscillatorSwamiIntradayFisher
ChaikinVolatilityMcClellanSummationIndexSwamiIntradayImpulse
ChandeMomentumOscillatorMedianAverageSwamiIntradayVolume
CloseLocationValueMedianPriceSwamiLaguerreTrend
ConcealingBabySwallowMeetingLinesSwamiMarketMode
CorrelationMktFacilitationIdxSwamiPredict
CumulativeVolumeIndexMomentumSwamiRelativePerformance
CyberCyclesOscillatorMomentumCrossoverSwamiSwingWave
DEMAMomentumPercentSwamiVolatility
DIMinusMomentumSMASwamiVolume
DIPlusMoneyFlowSwingIndex
DMAMoneyFlowIndexSymbolRelation
DMIMoneyFlowIndexCrossoverTAC_ADX
DMI_OscillatorMonkeyBarsTAC_DIMinus
DMI_ReversalAlertsMorningDojiStarTAC_DIPlus
DMI_StochasticExtremeMorningStarTEMA
DailyHighLowMovAvgAdaptiveTMV
DailyOpenMovAvgEnvelopeTPOProfile
DailySMAMovAvgExpRibbonTRIX
DarkCloudCoverMovAvgExponentialTTM_LRC
DarvasBoxMovAvgTriangularTTM_Squeeze
DeliberationMovAvgTwoLinesTTM_Trend
DemandIndexMovAvgWeightedTTM_Wave
DetrendedPriceOscMovingAvgCrossoverTheoreticalOptionPrice
DisparityIndexMultiCurrencyCorrelationOscThreeBlackCrows
DisplacedEMANegativeVolumeIndexThreeInsideDown
DisplacerNext3rdFridayThreeInsideUp
DojiOnBalanceVolumeThreeLineStrike
DoubleSmoothedStochasticsOnNeckThreeOutsideDown
DownsideGapThreeMethodsOnsetTrendDetectorThreeOutsideUp
DownsideTasukiGapOpenInterestThreeStarsInTheSouth
DynamicMomentumIndexOptionDeltaThreeWhiteSoldiers
EaseOfMovementOptionGammaThrusting
EhlersDistantCoefficientFilterOptionRhoTimeSeriesForecast
EhlersRoofingFilterOptionThetaTradeVolumeIndex
EhlersStochasticOptionVegaTrendNoiseBalance
EhlersSuperSmootherFilterPPSTrendPeriods
ElliotOscillatorPairCorrelationTrendQuality
EngulfingPairRatioTriStar
ErgodicOscParabolicSARTrueRangeIndicator
ErmanometryParabolicSARCrossoverTrueRangeSpecifiedVolume
EveningDojiStarPercentChgTrueStrengthIndex
EveningStarPercentRTwoCrows
FAKE_THINKSCRIPT_COLUMNPersonsPivotsTypicalPrice
FW_CCI_AdvancedPiercingLineUlcerIndex
FW_CCI_BasicPolarizedFractalEfficiencyUltimateOscillator
FW_DPO_MOBOPolychromMtmUniqueThreeRiverBottom
FW_MMGPositiveVolumeIndexUniversalOscillator
FW_MOBO_BasicPriceActionIndicatorUpsideGapThreeMethods
FW_SOAPPriceAndVolumeTrendUpsideGapTwoCrows
FallingThreeMethodsPriceAverageCrossoverUpsideTasukiGap
FastBetaPriceChannelVWAP
FisherTransformPriceOscVariableMA
ForceIndexPriceRatioVerticalHorizontalFilter
ForecastOscillatorPriceVolumeRankVolatilityStdDev
FreedomOfMovementPriceZoneOscillatorVolatilitySwitch
GatorOscillatorProjectionBandsVolumeAccumulation
HACOLTProjectionOscillatorVolumeAvg
HammerQStickVolumeFlowIndicator
HangingManRSIVolumeOsc
HaramiRSICrossoverVolumeProfile
HaramiCrossRSquaredVolumeRateOfChange
HeikinAshiDiffRainbowAverageVolumeWeightedMACD
HighPriceGappingPlayRandomWalkIndexVolumeZoneOscillator
HistoricalVolatilityRangeBandsVortexIndicator
HomingPigeonRangeIndicatorWeaknessInAStrongTrend
HullMovingAvgRateOfChangeWeightedClose
IFT_StochOscRateOfChangeCrossoverWildersSmoothing
IchimokuRayWilliamsAD
IdenticalThreeCrowsRayBearPowerWilliamsAlligator
ImpVolatilityRayBullPowerWilliamsPercentR
ImpulseRelativeMomentumIndexWoodiesPivots
InNeckRelativeRangeIndexZigZagTrendPercent
InertiaRelativeStrengthZigZagTrendSign

All Data Export Fields (quantity 432)

TOS Data Export FieldT.T160318C36
52HIGH37.12N/A
52LOW30.97N/A
ACT_WARNING
ADX
ADXCrossover
ADXR
ASK36.431.16
ASKX36.43 N1.16 C
ASK_SIZE422427
ATR
ATRTrailingStop
AV_TRADE_PRICE
AXNC
AbandonedBaby
AccDist
AccelerationBands
AccelerationDecelerationOsc
AccumDistBuyPr
AccumDistPrVol
AccumulationSwingIndex
AdvanceBlock
AdvanceDecline
AdvanceDeclineCumulativeAvg
Alpha2
AlphaJensen
AroonIndicator
AroonOscillator
AwesomeOscillator
BACK_EX_MOVE±1.02N/A
BACK_VOL21.27%N/A
BA_SIZE59 x 42467 x 2,427
BETA0.3085N/A
BID36.421.11
BIDX36.42 N1.11 C
BID_SIZE59467
BXNC
BalanceOfMarketPower
BeltHold
Beta0.3085N/A
Beta2
BollingerBands
BollingerBandsCrossover
BollingerBandwidth
BollingerPercentB
Breakaway
CALL_VOLUME_INDEX0.451N/A
CCI
CCIAverage
CLOSE36.651.31
COVERED_RETURNN/A18.74%
CSI
CUSTOM1
CUSTOM10
CUSTOM11
CUSTOM12
CUSTOM13
CUSTOM14
CUSTOM15
CUSTOM16
CUSTOM17
CUSTOM18
CUSTOM19
CUSTOM2
CUSTOM3
CUSTOM4
CUSTOM5
CUSTOM6
CUSTOM7
CUSTOM8
CUSTOM9
CamarillaPoints
ChaikinMoneyFlow
ChaikinOsc
ChaikinOscillator
ChaikinVolatility
ChandeMomentumOscillator
CloseLocationValue
ConcealingBabySwallow
Correlation
CumulativeVolumeIndex
CyberCyclesOscillator
DELTA10.5649
DEMA
DESCRIPTIONAT&T INC COMT 100 MAR 16 36 CALL
DIMinus
DIPlus
DIV0.48N/A
DIV_FREQQ
DMA
DMI
DMI_Oscillator
DMI_ReversalAlerts
DMI_StochasticExtreme
DailyHighLow
DailyOpen
DailySMA
DarkCloudCover
DarvasBox
Deliberation
DemandIndex
DetrendedPriceOsc
DisparityIndex
DisplacedEMA
Displacer
Doji
DoubleSmoothedStochastics
DownsideGapThreeMethods
DownsideTasukiGap
DynamicMomentumIndex
EPS0.9485N/A
EXCHANGECOMPOSITECOMPOSITE
EXPIRATIONN/AMAR 16
EXPIRATION_DAYN/A2016-03-19
EXTRINSICN/A0.71
EX_DIV_DATE1/6/16N/A
EX_MOVE_DIFF±0.794N/A
EaseOfMovement
EhlersDistantCoefficientFilter
EhlersRoofingFilter
EhlersStochastic
EhlersSuperSmootherFilter
ElliotOscillator
Engulfing
ErgodicOsc
Ermanometry
EveningDojiStar
EveningStar
FAKE_THINKSCRIPT_COLUMN
FRONT_EX_MOVE±0.64N/A
FRONT_VOL24.59%N/A
FW_CCI_Advanced
FW_CCI_Basic
FW_DPO_MOBO
FW_MMG
FW_MOBO_Basic
FW_SOAP
FX_PAIRT.T160318C36
FallingThreeMethods
FastBeta
FisherTransform
ForceIndex
ForecastOscillator
FreedomOfMovement
GAMMA00.187
GatorOscillator
HACOLT
HIGH36.741.13
HTB_ETBETB
Hammer
HangingMan
Harami
HaramiCross
HeikinAshiDiff
HighPriceGappingPlay
HistoricalVolatility
HomingPigeon
HullMovingAvg
IFT_StochOsc
IMPL_VOL21.56%18.87%
INTRINSICN/A0.425
Ichimoku
IdenticalThreeCrows
ImpVolatility
Impulse
InNeck
Inertia
IntradayMomentumIndex
InvertedHammer
KeltnerChannels
Kicking
KlingerHistogram
KlingerOscillator
LAST36.4251.13
LASTX36.425 D1.13 M
LAST_SIZE1003
LBR_PaintBars
LBR_SmartADX
LBR_ThreeTenOscillator
LOW36.261.09
LXDM
LegacyEMA
LinearRegCh100
LinearRegCh50
LinearRegChVar
LinearRegCurve
LinearRegTrendline
LinearRegrReversal
LinearRegressionSlope
LongHaulFilter
LongLeggedDoji
LookUpHighest
LookUpLowest
LowPriceGappingPlay
MACD
MACDHistogram
MACDHistogramCrossover
MACDTwoLines
MACDWithPrices
MARK36.4251.135
MARKET_CAP224,087 MN/A
MARK_CHANGE-0.225-0.18
MARK_PERCENT_CHANGE-0.61%-13.69%
MARK_PERCENT_UNDERLYING100.00%3.12%
MAX_COVERED_RETURNN/A18.74%
MESASineWave
MRKT_MKR_MOVE±0.382N/A
MT_NEWS**
MajorGannLevels
MarkerIndicator
MarketForecast
Marubozu
MassIndex
MatHold
MatchingLow
McClellanOscillator
McClellanSummationIndex
MedianAverage
MedianPrice
MeetingLines
MktFacilitationIdx
Momentum
MomentumCrossover
MomentumPercent
MomentumSMA
MoneyFlow
MoneyFlowIndex
MoneyFlowIndexCrossover
MonkeyBars
MorningDojiStar
MorningStar
MovAvgAdaptive
MovAvgEnvelope
MovAvgExpRibbon
MovAvgExponential
MovAvgTriangular
MovAvgTwoLines
MovAvgWeighted
MovingAvgCrossover
MultiCurrencyCorrelationOsc
NET_CHANGE-0.225-0.18
NegativeVolumeIndex
Next3rdFriday
OPEN36.651.13
OPEN_INT024666
OPTION_VOLUME_INDEX0.473N/A
OnBalanceVolume
OnNeck
OnsetTrendDetector
OpenInterest
OptionDelta
OptionGamma
OptionRho
OptionTheta
OptionVega
PE38.4N/A
PERCENT_CHANGE-0.61%-13.74%
PERCENT_IN_THE_COLUMNN/A1.18%
PERCENT_OUT_THE_MONEYN/A0.00%
POSITION_N_L
POSITION_QTY
PPS
PROB_OF_EXPIRINGN/A53.22%
PROB_OF_TOUCHINGN/A86.48%
PROB_OTMN/A46.78%
PUT_CALL_RATIO1.124N/A
PUT_VOLUME_INDEX0.495N/A
P_L_DAY
P_L_OPEN
P_L_PERCENT
P_L_YTD
PairCorrelation
PairRatio
ParabolicSAR
ParabolicSARCrossover
PercentChg
PercentR
PersonsPivots
PiercingLine
PolarizedFractalEfficiency
PolychromMtm
PositiveVolumeIndex
PriceActionIndicator
PriceAndVolumeTrend
PriceAverageCrossover
PriceChannel
PriceOsc
PriceRatio
PriceVolumeRank
PriceZoneOscillator
ProjectionBands
ProjectionOscillator
QStick
QUOTE_TRENDinstrument=Tinstrument=.T160318C36
RHO00.0173
ROCN/AN/A
RORN/AN/A
RSI
RSICrossover
RSquared
RainbowAverage
RandomWalkIndex
RangeBands
RangeIndicator
RateOfChange
RateOfChangeCrossover
Ray
RayBearPower
RayBullPower
RelativeMomentumIndex
RelativeRangeIndex
RelativeStrength
RelativeVolatilityIndex
RelativeVolumeStDev
ReverseEngineeringMACD
ReverseEngineeringRSI
RibbonStudy
RisingThreeMethods
SHARES6152000000N/A
STARCBands
STOCK_BETA0.3085N/A
STRENGTH_METERRange BoundN/A
STRIKEN/A36
SVEPivots
SVEZLRBPercB
SYMBOLT.T160318C36
SectorRotationModel
SemiCupFormation
SentimentZoneOscillator
SeparatingLines
SeriesCount
ShootingStar
SideBySideWhiteLines
SimpleMovingAvg
Spearman
SpectrumBars
Spreads
StandardDevChannel
StandardDeviation
StandardError
StandardErrorBands
StandardErrorChannel
StickSandwich
StochRSI
StochasticCrossover
StochasticFast
StochasticFull
StochasticMomentumIndex
StochasticSlow
StressIndicator
SwamiAccDist
SwamiConvolution
SwamiIntradayFisher
SwamiIntradayImpulse
SwamiIntradayVolume
SwamiLaguerreTrend
SwamiMarketMode
SwamiPredict
SwamiRelativePerformance
SwamiSwingWave
SwamiVolatility
SwamiVolume
SwingIndex
SymbolRelation
TAC_ADX
TAC_DIMinus
TAC_DIPlus
TEMA
THETA0-0.009
TMV
TPOProfile
TRIX
TTM_LRC
TTM_Squeeze
TTM_Trend
TTM_Wave
TheoreticalOptionPrice
ThreeBlackCrows
ThreeInsideDown
ThreeInsideUp
ThreeLineStrike
ThreeOutsideDown
ThreeOutsideUp
ThreeStarsInTheSouth
ThreeWhiteSoldiers
Thrusting
TimeSeriesForecast
TradeVolumeIndex
TrendNoiseBalance
TrendPeriods
TrendQuality
TriStar
TrueRangeIndicator
TrueRangeSpecifiedVolume
TrueStrengthIndex
TwoCrows
TypicalPrice
UlcerIndex
UltimateOscillator
UniqueThreeRiverBottom
UniversalOscillator
UpsideGapThreeMethods
UpsideGapTwoCrows
UpsideTasukiGap
VEGA00.0458
VOLUME1017153076
VOL_DIFF3.32%N/A
VOL_INDEX21.56%N/A
VWAP
VariableMA
VerticalHorizontalFilter
VolatilityStdDev
VolatilitySwitch
VolumeAccumulation
VolumeAvg
VolumeFlowIndicator
VolumeOsc
VolumeProfile
VolumeRateOfChange
VolumeWeightedMACD
VolumeZoneOscillator
VortexIndicator
WEIGHTED_BACK_VOL19.72%N/A
WeaknessInAStrongTrend
WeightedClose
WildersSmoothing
WilliamsAD
WilliamsAlligator
WilliamsPercentR
WoodiesPivots
YIELD5.27%N/A
ZigZagTrendPercent
ZigZagTrendSign

Data Export Fields on April 1, 2014 (qty 69)

TOS Export FieldT.T160318C36
52HIGH36.82N/A
52LOW30.97N/A
ASK36.871.43
ASKX36.87 N1.43 X
ASK_SIZE308247
AXNX
BACK_EX_MOVE±0.863N/A
BACK_VOL20.16%N/A
BA_SIZE177 x 308139 x 247
BETA0.3085N/A
BID36.861.39
BIDX36.86 N1.39 I
BID_SIZE177139
BXNI
CALL_VOLUME_INDEX0.959N/A
CLOSE36.531.12
COVERED_RETURNN/A12.56%
DELTA10.6404
DESCRIPTIONAT&T INC COMT 100 MAR 16 36 CALL
DIV0.48N/A
DIV_DATE
DIV_FREQQ
DT
EPS0.9485N/A
EXCHANGECOMPOSITECOMPOSITE
EXPIRATIONN/AMAR 16
EXTRINSICN/A0.545
EX_MOVE_DIFF±0.45N/A
FRONT_EX_MOVE±0.737N/A
FRONT_VOL55.97%N/A
GAMMA00.1768
HIGH37.041.5
HTB_ETBETB
IMPL_VOL19.74%18.30%
INTRINSICN/A0.865
LAST36.8651.38
LASTX36.865 N1.38 Q
LAST_SIZE1004
LOW36.531.25
LXNQ
MARK36.8651.41
MARKET_CAP226,793 MN/A
MAX_COVERED_RETURNN/A12.56%
MRKT_MKR_MOVE±0.722N/A
MT_NEWS**
NET_CHANGE0.3350.26
OPEN36.591.25
OPEN_INT024606
OPTION_VOLUME_INDEX1.119N/A
PE38.87N/A
PERCENT_CHANGE+0.92%+23.21%
PROB_OF_EXPIRINGN/A60.20%
PROB_OF_TOUCHINGN/A73.66%
PUT_CALL_RATIO1.276N/A
PUT_VOLUME_INDEX1.288N/A
RHO00.0207
ROCN/AN/A
RORN/AN/A
SHARES6152000000N/A
STRENGTH_METERRange BoundN/A
STRIKEN/A36
SYMBOLT.T160318C36
THETA0-0.0075
VEGA00.0465
VOLUME32228662209
VOL_DIFF35.81%N/A
VOL_INDEX19.74%N/A
YIELD5.21%N/A

* For those that have read this far, thank you. Did you notice how clever it was to modify the RTD equation the way we did in Part 2 so we could simply copy & paste it all over the place in Part 3?

/insert pat on the back/

Written and contributed by Rich Kaczmarek

(Video) Options Trading for Income with John Locke for October 20, 2014

FAQs

Can you download data from thinkorswim to Excel spreadsheet? ›

Realtime Data From ThinkorSwim into Excel - YouTube

How use RTD in Excel? ›

The RTD function retrieves data from an RTD server for use in the workbook. The function result is updated whenever new data becomes available from the server and the workbook can accept it. The server waits until Excel is idle before updating.

How do I export data from TD Ameritrade to excel? ›

From the Account Tools menu, select File Downloads, Download Files. On the File Downloads page, enter the date range for the files you wish to download. If this is the first time you are downloading files from TD Ameritrade, make sure you enter a date range wide enough to capture all available files.

How do you track prices on Excel? ›

Getting Live Stock and Options Prices In Excel With Thinkorswim RTD

How do I import data into Excel? ›

Import Data
  1. Click the Data tab on the Ribbon..
  2. Click the Get Data button. Some data sources may require special security access, and the connection process can often be very complex. ...
  3. Select From File.
  4. Select From Text/CSV. ...
  5. Select the file you want to import.
  6. Click Import. ...
  7. Verify the preview looks correct. ...
  8. Click Load.

How do I export chart data from thinkorswim? ›

Exporting Data With thinkorswim by Kory Gill, @korygill - YouTube

How do I download a chain in Excel? ›

One is the simple and straightforward method of downloading the CSV file for options data from the NSE website. The link to download the CSV file is given at the top of the option chain chart. Once you select the Options Contracts type or Symbol, Expiry Date, or Strike Price, download the CSV file.

What is RTD formula? ›

RTD temperature calculation formula. Let's assume you have a Pt100 RTD sensor. With a 35°C temperature, 0.00392 temp coefficient value, 0°C reference temp. Your RTD calculation formula will go like this: RT = 100 x Ω x [ 1 + (0.00392) × (35 − 0) ] = 113.72 ohms.

How do I do a live update in Excel? ›

Update only the selected data Press ALT+F5, or on the Data tab, in the Connections group, click the arrow under Refresh All, and then click Refresh. Update all data in the workbook Press CTRL+ALT+F5, or on the Data tab, in the Connections group, click Refresh All.

What is the working principle of RTD? ›

Principle of Operation

Resistance Temperature Detectors (RTD) operates on the principle that the electrical resistance of a metal changes predictably in an essentially linear and repeatable manner with changes in temperature. RTD have a positive temperature coefficient (resistance increases with temperature).

How do I export from thinkorswim? ›

How to export your trades from thinkorswim's trading platform.

How do you delete a saved order on thinkorswim? ›

You have to swipe left on the order, then select "delete".

Videos

1. John Locke, founder of LockeInYourSuccess com interviewed by TRDR.tv
(John Locke)
2. Trader of the Month Interview
(KL Options)
3. Round Table with John Locke and Dave Thomas - January 20, 2015
(CapitalDiscussions)
4. #127 – Dr. Locke Karriker: The balancing act: animal welfare and antibiotic usage
(Swine Campus | Swine it)
5. Sow Seeds for Your Future Self
(HealthyGamerGG)
6. Round Table with Ed Tulauskas from Random Walk Trading - July 27, 2016
(CapitalDiscussions)
Top Articles
Latest Posts
Article information

Author: Rev. Leonie Wyman

Last Updated: 01/04/2023

Views: 6299

Rating: 4.9 / 5 (79 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Rev. Leonie Wyman

Birthday: 1993-07-01

Address: Suite 763 6272 Lang Bypass, New Xochitlport, VT 72704-3308

Phone: +22014484519944

Job: Banking Officer

Hobby: Sailing, Gaming, Basketball, Calligraphy, Mycology, Astronomy, Juggling

Introduction: My name is Rev. Leonie Wyman, I am a colorful, tasty, splendid, fair, witty, gorgeous, splendid person who loves writing and wants to share my knowledge and understanding with you.