Data from MFP to excel

Hello
I'd like to know how can I connect the MFP to excel, to achieve  ​​back values price over time,I like to get back and lay prices over time to build a chart  for later analysis in excel.
Someone can tell me if it is possible?
Thank's for helping

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.

Hi

Thank´s for your help, i thought that was more easy to get this kinds of charts.
I doesn´t know how can i use VBA code...I will collect results in manual way
Best regards
Diogo

Hi
...of course MFP has basic inbuilt charting - not sure if this is suitable for your purpose.