Hi there
I need help with a formula in excel
I am getting a price feed with the following formula =RTD("pipes.rtd",,"QUOTES","Mark",".AMZN230120P3000",) in to excel
and I'd like to change this section ".AMZN230120P3000"
Instead of ".AMZN230120P3000" I'd like to have AMZN in cell A2, 230120 in B2, P in C2 and 3000 in D2
By changing this ".AMZN230120P3000" to something like A2, B2, C2, D2 My goal is to get the formula to read this section ".AMZN230120P3000" off of the cells
That way, if I need to change one of the inputs I can just change one of the cells
As you can see on the screen shot below cell E2 has the following formula =RTD("pipes.rtd",,"QUOTES","Mark",".AMZN230120P3000",)
I need to remove ".AMZN230120P3000" and instead have that part be fed by Cells A2, B2, C2 and D2
How do I do this?
I tried comma's and didn't work
Would very much appreciate your support
=RTD("pipes.rtd",,"QUOTES","Mark",A2,B2,C2,D2,)