Exporting Pivot Point Related Data to Excel

 
Please can someone help with a guide on how to import the previous day Open, Close, High and Low into excel, i tried using DDE but while it opened i noticed it only show the High, low, Close and Ask but dosen't show the open . Better still Can i get an indicator that shows on the chat this 4 list above and most likely the pivot point result for the day when divided by 4. thanks, i anticipate a prompt response
Reason: