Can i use cell references in DDE links? example: =REDILink|'L1'!'SPY;Lp'. is there a way to refer

dwilson3
dwilson3
in REDI API
Can i use cell references in DDE links? example: =REDILink|'L1'!'SPY;Lp'. is there a way to reference a cell for the symbol instead of needing SPY hard coded in the formula?
Tagged:

Best Answer

  • zoya faberov
    zoya faberov
    Answer ✓

    Hello @dwilson3,

    Yes, it can be done. To be clear, the tweak is not REDI-specific, and is not elegant, but can be used to insert a cell value into any DDE link, review this Tip On Evaluate via Module to create Module with Eval() code.

    Now you can modify DDE example:

    1. Create the module with Eval, as shown.

    2. Cell B5 contains IBM

    3.

    C17 contains '=RediLink|'L1'!'

    C18 cintains ;LP'

    D17 contains =CONCAT(C17,B5,C18)

    D18 contains =Eval(D17)

    And D18 will ultimately contain your last price, such as:

    image

    Let us know if this was of help.


Categories