I am using e-signal DDE link on excel, and am wondering how I can compute live VWAP on excel without VBA or java. any suggestion?
thanks, but that is not what I am asking for in here. I am seeking help to solve the technical issue of computing live VWAP on EXCEL using DDE.
I dont know if this is the solution for you, but you can use Alexis VWAP formula http://forum.esignalcentral.com/showthread.php?s=&threadid=12856&highlight=vwap and export the study value into DDE, simply modifying this code http://forum.esignalcentral.com/showthread.php?s=&threadid=11243&highlight=export+excel
I think you have to use VBA, but you need some skill to do things like exception handling. The other option is to use quotein.com.