Changing DDE formula to be more generic rather than specific

dikken20

Board Regular
Joined
Feb 25, 2009
Messages
103
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?
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,127,751
Messages
5,626,657
Members
416,199
Latest member
Gautamsunil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top