Execute Excel Formula with Powershell

I can execute the following formula in Excel and it gets the last price of IBM
=RTD(“tos.rtd”, , “LAST”, “IBM”)

How can execute something similar using PowerShell ?

(The above formula was taken from Quotes from Thinkorswim via TOS.RTD - RealTimeToDB )


well, I can suggest you that you should follow these things:
Most of the time in excel to find how many “string” is used in a row we use

I would like to call this function (=NB.SI(range," string") ) with a PowerShell script.

I tried to use$objExcel.worksheetFunction.Match(“string”,range) but it wasn’t useful.