I am trying to get my print values on output to export to excel. I tried using exportdata strategy, but im getting a file path / variable error.
is there an easier way to do it? I would like to overwrite each new time the bar calculates, i dont need to keep the old values when the new one overwrites.
Im looking for something that is realtime in excel. thanks.
Can you help answer these questions from other members on futures io?
If you want it to update, then import is not a good option.
Excel RTD (Real Time Data) is the replacement for DDE. It allows you to push values to a cell whenever updates are available. If the process providing the updates is an external application, setting up a WCF channel between the RTD server and the external app should allow you to feed real-time updates into Excel.
Thanks for that, this is beyond my scope of programming.
Does anyone have an indicator/strategy already working realtime with excel, would like a template.
I posted this file here because I really didn't know where else to post it.
The attached file is a Excel (2007) template for an export Indicator (NT7) I just posted. It's only use is to define the .csv headers more clearly as they are mostly non-descriptive in the file. There are two worksheets in the file, one id for the Detail file and the other is for the directory file.
This spreadsheet does not do any data analysis of the exported data.