+ Reply to Thread
Results 1 to 5 of 5

RTD functions between Thinkorswim and Excel shows text instead of numbers

  1. #1
    Forum Contributor
    Join Date
    07-21-2014
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    230

    RTD functions between Thinkorswim and Excel shows text instead of numbers

    Hi

    I'm usign the RTD function in excel to retrieve data from Thinkorswim. The data comes in as text (I presume, since its on the left side of the cell), I need the data to be number, so I can use it in calculations.

    See attached spreadsheet for example (you need thinkorswim to get the function to work).
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,381

    Re: RTD functions between Thinkorswim and Excel shows text instead of numbers

    Are you expecting members to get this in order to be able to help you? If so, I think it unlikely they will. I suspect the number of members who could help because they already have it will be tiny.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    07-21-2014
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    230

    Re: RTD functions between Thinkorswim and Excel shows text instead of numbers

    Here is a video of it, he seems to be able to make it. So I think there is something wrong with my excel
    https://www.youtube.com/watch?time_c...ature=emb_logo

    No, I'm not expecting they get it, it's just if someone had it, maybe they have encounter the problem before.

  4. #4
    Forum Contributor
    Join Date
    07-21-2014
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    230

    Re: RTD functions between Thinkorswim and Excel shows text instead of numbers

    okay, so I found out what the problem was. It worked on my laptop, the difference was that my Regional format for windows for dates and times was based on my native language (Norwegian). When I changed it to English it worked

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,381

    Re: RTD functions between Thinkorswim and Excel shows text instead of numbers

    Thanks for letting us know.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Replace functions calculates scientific numbers in text field
    By atdemeo in forum Excel General
    Replies: 3
    Last Post: 07-01-2018, 04:29 PM
  2. [SOLVED] Text+numbers nested IF functions
    By Vetyver in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2016, 03:00 PM
  3. RTD losing sync with ThinkOrSwim
    By ExcelBrain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2016, 06:08 PM
  4. [SOLVED] Formula shows as text in cell entered and result shows in another cell
    By r.coon in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-16-2015, 11:57 PM
  5. Split complicated text/numbers string with functions
    By babyboomexports in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-27-2013, 12:42 AM
  6. Removing Ranking Numbers with Text Functions
    By mrvp in forum Excel General
    Replies: 3
    Last Post: 12-06-2011, 04:33 PM
  7. Replies: 2
    Last Post: 05-20-2011, 12:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1