Symbol Helper

Symbol Helper

Symbol Helper allows extracting stock and option symbols from RTD formulas and web pages.

You may paste symbols into symbol tables using the RTD.DB Database Configuration Editor.

For example, to copy formulas from the Thinkorswim platform, select the Trade tab, open the top right menu and click Export, To Microsoft Excel:

Example of exporting Thinkorswim formulas to Microsoft Excel

Then click the Paste Formulas button in the Symbol Helper:

Example of extracting option symbols in the Thinkorswim format

You may change the output symbol format, Thinkorswim or OCC:

Example of extracting option symbols in the OCC format

You may copy all symbols, stock symbols, or option symbols:

Example of copying stock and option symbols

To paste symbols into the target table, open the RTD.DB Database Configuration Editor, select the desired table and click the Paste button:

Example of pasting option symbols using Configuration Editor

The editor pastes unique symbols only.

You may paste option symbols from websites like Yahoo Finance or MSN Money. Just select and copy the page content and paste it into the Symbol Helper.

Also, you may copy and paste formulas from Microsoft Excel.

Here is a typical sheet created using Thinkorswim export:

Example of real-time Thinkorswim data in Microsoft Excel

Click Formulas, Show Formulas before copying. Otherwise, you will copy values but not formulas.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.OK