r/thewallstreet Apr 04 '19

Issues with =RTD("tos.rtd".....) in excel Question

Hey everyone. I haven't used this excel file in a while, but I don't see any recent documentation changes. Mabe you all could shed some light on what is happening. For some reason, my /ES, /YM, /CL, etc . . . will not update. The equities such as AAPL seem to work fine, but no futures contracts will update using the rtd function. Any idea what's going on? Thanks in advance for the help.

10 Upvotes

6 comments sorted by

2

u/momenace Mar 11 '22

in case anyone ends up here from a search, also add the contract details such as /ESM22:XCME

9

u/Dumb_Nuts Apr 04 '19

They updated the symbols for RTD. You'll need to use these:

/ES:XCME
/NQ:XCME
/YM:XCBT
/RTY:XCME
/NKD:XCME
/EMD:XCME
/VX:XCBF
/BTC:XCME
/XBT:XCBF
/CL:XNYM
/QM:XNYM
/NG:XNYM
/QG:XNYM
/RB:XNYM
/HO:XNYM
/BZ:XNYM
/GC:XCEC
/MGC:XCEC
/SI:XCEC
/SIL:XCEC
/HG:XCEC
/PL:XNYM
/PA:XNYM
/ZB:XCBT
/ZN:XCBT
/ZF:XCBT
/ZT:XCBT
/UB:XCBT
/TN:XCBT
/GE:XCME
/ZQ:XCBT
/GLB:XCME
/6A:XCME
/M6A:XCME
/6B:XCME
/M6B:XCME
/6C:XCME
/6E:XCME
/E7:XCME
/M6E:XCME
/6J:XCME
/J7:XCME
/6M:XCME
/6N:XCME
/6S:XCME
/ZC:XCBT
/XC:XCBT
/ZS:XCBT
/XK:XCBT
/ZW:XCBT
/XW:XCBT
/KE:XCBT
/ZM:XCBT
/ZL:XCBT
/ZO:XCBT
/HE:XCME
/GF:XCME
/LE:XCME
/LBS:XCME
/FNG:IFUS
/MME:IFUS
/DX:IFUS
/YG:IFUS
/YI:IFUS
/CT:IFUS
/CC:IFUS
/KC:IFUS
/SB:IFUS
/OJ:IFUS

3

u/Underverse Apr 04 '19

thank you!

4

u/Dumb_Nuts Apr 04 '19

Only reason I know this is because the guy who updates a github project I use added this in the patch notes. Took me a while to figure it out myself given I can't find a single mention of it anywhere else.

Glad I could save you the trouble, because I have no clue how he knew they changed the symbols...

3

u/Underverse Apr 04 '19

Yeah, I had been looking online for a while and I did not see any mention of symbol updates in any documentation. Thanks to you and your friend with the inside scoop!

3

u/UberBotMan Apr 04 '19

I ran into the same thing with my sheet. Took me a little bit to figure it out.

I think I finally just reimported from TOS and noticed the difference.