Hi
Yes it is certainly possible. Using Marketfeeder’s DDE link to Excel, you would need some VBA code to basically do the following:
Read the value of the selection’s back and lay prices from their respective cells on the market sheet at specific time intervals
Using a For / Next loop record the value into the next blank cell in your range
For example,
For I = 1 to 30
your VBA code to read the values, detect next blank cell, and copy value here
Next
will record the last 30 values of back and lay prices in the columns you specify in your code. Once you have the range of values, you can then plot charts and do analysis etc.
I’m afraid I can’t help you with the VBA code, however there is plenty free help on this online.
Also, have a look at the Trigger Action: Write to Excel. It might save you having to do too much in VBA.