Quote Originally Posted by MarvinP View Post
Hi calvk

I have no desire to download and install metatrader 4. Sorry. Perhaps some other forum member will want to help with this.
Ok marvinp.
thanks for your help. Just only one last question. If i put the pivot table on sheet4. Could i do a macro to refresh the sheet4 on every 30 seconds? Cause when i press the refresh button under the pivot tools - options - refresh. And the values will refresh. If i could automate this process, then i think everything is settle. Thanks for your help till now.