get last close into excel

[suremanp1]

I was wondering if you could get ONLY the close of the last bar into excel.
This quote would be for futures contract and might intel spaces and dashes.
Obvious last is =winros|last!'ym z5' ....But how do you get the function not to update until the end of the 1 min or 5 min bar?

Thanks

[eSignal_JasonK]

Hello suremanp1,

What you need to do is create an EFS DDE link that sends the last value to excel from bar -1 of the chart interval you want to watch. In the code example at the link provided you would replace study = ema(10); with study = close();. Also replace retVal = study.getValue(0); with retVal = study.getValue(-1);. You might also want to change the name for the DDE link in the DDEOutput parameters at the top of the code example.

Once you've made these changes, run the EFS on a 1 minute chart and add the new dde link to your spreadsheet. You should only see the value change when the current 1-minute bar has closed.