Excel & Metastock

Discuss Excel & Metastock at the Intraday within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Dear Friends, Queries / Suggestions for Excel to Metastock can be posted here.... reg ketan...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > TOOLS & RESOURCES > Data Feeds > Intraday

Notices


Reply
 
Thread Tools
Sponsored Links
  #1  
Old 19th May 2007, 01:26 PM
Member
 
Join Date: Dec 2005
Posts: 15
Reputation: 20
pandyaketan is on a distinguished road
Default Excel & Metastock

Dear Friends,

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

reg
ketan
Reply With Quote
  #2  
Old 19th May 2007, 01:27 PM
Member
 
Join Date: Dec 2005
Posts: 15
Reputation: 20
pandyaketan is on a distinguished road
Default Re: Excel & Metastock

Quote:
Originally Posted by pandyaketan View Post
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
Reply With Quote
  #3  
Old 19th May 2007, 01:59 PM
Member
 
Join Date: May 2006
Location: Kolkata
Posts: 1,102
Reputation: 24
swagat86 is on a distinguished road
Default Re: Excel & Metastock

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 sowgat@*****.com. il send u wat u need.


Thanks
Reply With Quote
  #4  
Old 19th May 2007, 04:51 PM
Member
 
Join Date: Dec 2005
Posts: 15
Reputation: 20
pandyaketan is on a distinguished road
Default Re: Excel & Metastock

Quote:
Originally Posted by swagat86 View Post
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 sowgat@*****.com. il send u wat u need.


Thanks
Sent, pl check email...

reg
ketan
Reply With Quote
  #5  
Old 21st May 2007, 01:43 PM
Member
 
Join Date: Dec 2005
Posts: 15
Reputation: 20
pandyaketan is on a distinguished road
Default Re: Excel & Metastock

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
Reply With Quote
  #6  
Old 28th July 2007, 09:49 PM
Member
 
Join Date: May 2006
Location: Kolkata
Posts: 1,102
Reputation: 24
swagat86 is on a distinguished road
Default Re: Excel & Metastock

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
Reply With Quote
  #7  
Old 28th July 2007, 11:43 PM
Member
 
Join Date: Apr 2007
Posts: 512
Reputation: 29
chintan786 is on a distinguished road
Default Re: Excel & Metastock

thanks Ketan for such a nice utility.. can we use other stocks also instead of Nifty..
Reply With Quote
  #8  
Old 30th July 2007, 11:08 AM
Member
 
Join Date: Dec 2005
Posts: 15
Reputation: 20
pandyaketan is on a distinguished road
Default Re: Excel & Metastock

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
Reply With Quote
  #9  
Old 11th August 2007, 03:44 PM
Member
 
Join Date: Aug 2007
Posts: 9
Reputation: 20
manojp07 is on a distinguished road
Default Re: Excel & Metastock

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?
Reply With Quote
Sponsored Links


Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads for: Excel & Metastock
Thread Thread Starter Forum Replies Last Post
My MetaStock COmpatable Excel EOD Convertor joy_mitali Software 20 27th March 2008 01:32 PM
excel to metastock veneet Software 3 21st February 2008 02:29 PM
Pulling Metastock data into excel netguru MetaStock 0 18th September 2006 01:41 AM
excel help vvn Introductions 4 8th August 2005 08:06 PM


All times are GMT +5.5. The time now is 02:38 AM.

Indemnity, Disclaimer & Disclosure Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum Rules Disclaimer & Disclosure and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © 2001 - 2008, Traderji.com All Rights Reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com