I am building a spreadsheet. In Col A I have stock symbols. In Cols B, C, D etc..I want the Last, Change, Prv Cls etc...This is a DDE link with RediPlus. Now here's the question. Is there a way to write the formula (see below) so that where "SYM" appears It will automatically populate with the corresponding symbol? I want to be able to drag and copy the formula instead of having to write the formula for each symbol on each cell. So when I drag the formula the symbol in A1 gets copied into the B1 and symbol in A2 gets copied into formual in B2 and so on. Here's is an example of the formula. This one is for last price. =RediLINK|'L1'!'SYM;LP' This example is for last price in Col B.
I do it with esignal's dde quite a bit. Here's what you do. In cells on the same row put = in one, then RediLINK|'L1'!', then =A1 (the symbol in the original location), then ;LP'. Say you've put those in E, F, G & H. Then in I you type =concatenate(E1,F1,G1,H1) Drag that formula all the way down your sheet. Highlight the column, copy, go to where you want to put it and paste special>values. Activate each cell (F2) and hit enter to make the formula go live. Seems convoluted, but it's pretty quick and easy to do. I have a macro that hits F2+enter to activate large lists.
Redi also has a link builder. make sure the redi add-in is installed. Go to tools> add ins and check redi. Then you'll get RediPlus added to the top menu with a selection for link builder. This can build the links for a list at once.