Hi,
Let's begin with a few examples for a DDE formulas from a trading system to my excel sheet:
=tradeone|cds!TA.TASE.01137256_DailyLowestRate
=tradeone|cds!TA.TASE.01080688_DailyLowestRate
=tradeone|cds!TA.TASE.00383018_DailyLowestRate
=tradeone|cds!TA.TASE.01097054_DailyLowestRate
"=tradeone|cds!TA.TASE." is the same for all formulas while the differences between each formula are the instrument ID (01137256, 01080688, etc,..). and the required Parameter values (DailyLowestRate, DailyHighestRate, etc,..)
I've got dozens of Instrument IDs and dozens of Parameter values, and I would like the formula to be more generic rather than specific, so if I would like to get the values of Parameters for the 01137256 instrument ID, now it's specific:
A2=tradeone|cds!TA.TASE.01137256_DailyLowestRate
A3=tradeone|cds!TA.TASE.01137256_DailyHighestRate
A4=tradeone|cds!TA.TASE.01137256_DailyTurnover
I would need it to be generic so if Cell A1 = 01137256 I would need the formula in each cell to be somehow generic like
"tradeone|cds!TA.&A1&_DailyLowestRate"
How can I do that please?
Let's begin with a few examples for a DDE formulas from a trading system to my excel sheet:
=tradeone|cds!TA.TASE.01137256_DailyLowestRate
=tradeone|cds!TA.TASE.01080688_DailyLowestRate
=tradeone|cds!TA.TASE.00383018_DailyLowestRate
=tradeone|cds!TA.TASE.01097054_DailyLowestRate
"=tradeone|cds!TA.TASE." is the same for all formulas while the differences between each formula are the instrument ID (01137256, 01080688, etc,..). and the required Parameter values (DailyLowestRate, DailyHighestRate, etc,..)
I've got dozens of Instrument IDs and dozens of Parameter values, and I would like the formula to be more generic rather than specific, so if I would like to get the values of Parameters for the 01137256 instrument ID, now it's specific:
A2=tradeone|cds!TA.TASE.01137256_DailyLowestRate
A3=tradeone|cds!TA.TASE.01137256_DailyHighestRate
A4=tradeone|cds!TA.TASE.01137256_DailyTurnover
I would need it to be generic so if Cell A1 = 01137256 I would need the formula in each cell to be somehow generic like
"tradeone|cds!TA.&A1&_DailyLowestRate"
How can I do that please?