close

Hi

I am successfully using the following formula to get real-time data from a
3rd party software into Excel:

=SAT|Realtime!'ESX6O5375.lio LastPrice'

I was hoping to manually put in part of the formula in various cells and
then cross reference those instead of hardcoding these figures into the
formula as shown above:

By way of example, ESX6O might be in cell A1 and 5375 in cell A2

I was hoping that in the above scenario

=SAT|Realtime!amp;quot;'quot;amp;A1amp;A2amp;quot;.lio LastPrice'quot; would correctly return my value
but this doesn't work.

Any ideas?

Thanks in advance

Regards,

Reto

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄