Real time prices printed automatically in googlesheets

Discussion in 'App Development' started by emulimu, Nov 19, 2021.

  1. emulimu

    emulimu

    I am looking to have something coded which can print data in googlesheets when TOS is running. Is this possible?

    Also, is it possible to have a custom column in TOS option chain where the calculations are coded in TOS scripting language?
     
  2. Sharing real time data from your broker feed needs an api — not sure if tos has it but if it does it should work in theory.
     
    emulimu likes this.
  3. TOS supports RTD which you can use to get realtime data into Excel using the RTD() function. I don't think this function is available in Google sheets since it's cloud based.

    It is possible to get a custom value via RTD. When you copy and paste the data from TOS is will assign a custom name to the calculated column which you can use as a reference.
     
    emulimu likes this.
  4. emulimu

    emulimu

    Excel is fine with me. This is very helpful. Thank you!