RTD function in Excel

Question

I use the RTD function in Excel and the cell that is being imported from the Stock Broker website (Think or Swim; TD Ameritrade) is bringing in a cell that shows an expected move of a stock. The Execl spreadsheet cell is importing a "+/-" signs in front of a number which is imported using the RTD function. I am told it is being imported as a text not an actual number as recognized by Excel. Is there a way to have the cell remove the "+/-" in front of the number so that I can perform calculations with the cell? I have attached a screenshot of the Excel spreadsheet with the RTD command in the cell G5 (=RTD("tos.rtd", , "FRONT_EX_MOVE", E4)). essentially the cell is bringing in the Expected Move of the stock symbol entered in cell E4, in this example it is GS = Goldman Sachs). What I would like to do is remove the "+/-" in front of the numbers of cell G5 (+/-3.801) & H5 (+/-7.071), which has a similar RTD function (=RTD("tos.rtd", , "BACK_EX_MOVE", E4) ). 

Answer 1

Hi.  ABS( ) won't work on a string.

Perhaps try something like this:

For your situation, try placing your RTD function where the A1 is.

Answer 2

Hi SamDroulias,

Thanks for sharing your experience in our forum.

You can try to use ABS function to get a positive value to do the calculations.

For how to use ABS function you can refer to: ABS function.

Regards,

Clark

Answer 3

Hi SamDroulias,

Have you browsed my post? Please let us know whether you can do the calculation. If you need further assistance, don't hesitate to ask questions.

.

Regards,

Clark

Answer 4

Dana_D THANK YOU!! Yes, this does solve my problem!  You can't imagine how many calls and time I have spent with Microsoft Office tech reps who have not been able to supply any solutions, as well as the online broker, TD Ameritrade. The Microsoft Excel tech reps told me that there was no solution within Excel.  You area life saver! Thanks again!