RTD - Using the 17 customs studies to send data to Excel

curiousjeff

Active Member
The "help on data export" (export menu in the trade tab) will display 17 custom studies available.

1589558205867.png

1589558310708.png

To use these studies in RTD:

For some strange reason, the 17 custom studies are NOT available in the study menu under the charts tab.

You will find them here:

Go to your watchlist, right click on the header of any column, and then select "customize"

1589558536470.png

Here you will see the 17 custom studies:

1589558620340.png

Click once on the study you want to modify, then click again on the paper scroll symbol:

1589558748612.png

1589558820654.png

You must create a script that will generate only one item/number.
Some Thinkscript commands will not work.

Example using the forceindex script from TOS:

declare lower;

input length = 13;

plot FI = ExpAverage(data = (close - close[1]) * volume, length);


In Excel, use this command:

=RTD("tos.rtd",,"CUSTOM1","SPY")

You can check that all is working correctly by adding the study as a column in your watchlist:

1589559660217.png

In Excel, you will first get a "loading" message and it can take some time to display, but if you have a number in your watchlist, it must give the same in Excel.

Credit: I found this procedure in a PDF from R. Kaczmarek / John Locke's site.
 
Last edited:

Ron Bertino

Administrator
Staff member
Word of warning: if you change the name of one of these, say from CUSTOM1 to MyMagicIndicator, then Excel RTD will still refer to it as CUSTOM1, yet you will have easily forgotten which one of your many indicators was the one that used to be called CUSTOM1.
Therefore, my suggestion is to rename it to something like C1_MyMagicIndicator or MyMagicIndicator_C1
You want to have something in the name of the indicator that lets you know the underlying name that Excel RTD will be referencing (CUSTOM1).
 
Top