Excel & Metastock

Dear Friends,

Queries / Suggestions for Excel to Metastock can be posted here....

reg
ketan

Dear Friends,

I am able to get live data from NSEindia.com in excel using web query.

But How to save / chart such data in excel without overwriting and more, importantly - how to use it for metastock / amibroker. I have tried a utility called DDEChartUpdater which connects excel to metastock, but i did not get a key for it....

anyone has made a utility for excel to metastock like cooltetra has made ?? (he has made excel to amibroker). Hyperserver is now paid so no point installing it.

reg
ketan

hi Mr Pandey,

if u can share ur excel sheet with me. i can help u with DDE Chartupdater.
Mail me the excel sheet at [email protected]. il send u wat u need.


Thanks

Sent, pl check email...

reg
ketan

Dear Friends

i hve prepared an excel file for trading nifty based on 3-13-39 system. File can be downloaded from link below:

http://www.savefile.com/files/739076

I have also put a filter of 5 MA for longs so that u dont have to wait for 3 to go all the way down to 13 for closing ur longs. (However, it may give whipsaws, so it is suggested that one gradually cut longs once 3MA goes below 5MA ...).

3-13-39 can be changed to 5-10-20 or any other, as per one's comfort. Explanation is given on final sheet...

Problem of "delays" is also solved since live data is plotted along with EoD !

Hope the file is useful. IF you are able to make money from this excel file, do contribute Rs 500 per month for charitable purposes like UNICEF or CRY and make this world a better place, at least for kids ...

A query: is it possible to have mixed live and EoD in metastock ? i want to see live candle as an EoD (As in the excel sheet) in Metastock, so that this sheet can be replicated in Metastock (anyone made a metastock expert / indicator for it ??) ...

reg
ketan

hi MR Pandya,

i can ur sheet be modifed to get data from NSE for other stock. Can u also tell me how much is the delay.

Thanks

thanks Ketan for such a nice utility.. can we use other stocks also instead of Nifty..

yes its possible for any stock, if any vba programmer who can write a macro in excel, pl ask him to contact me, i can explain the whole matter to him....

we can jointly do this as a team so that FAQs are not raised again and again !

reg
ketan

hi
i want to plot graph of differences in spot and fut in real time either in excel or in metastock.can anyone tell me how to do this?