Hi Friends, In quest to learn MS Excel VBA/VSTO Programming, I've made a useful utility for all of excel users and stock investors. This utility helps individuals to track their markets for analysis and information purposes. I've covered around 12 major stock indexes as mentioned below.
1. Dow Jones 2. NASDAQ 3. BSE 30 4. DAX 30 5. CAC 40 6. FTSE 100 7. Nikkei 225 8. ASX 200 9. NSE 50 10. Hangseng 11. Shanghai Composite Index 12. STRAIT Index and then there are sectorial indices, midcap and all other major and relevant indexes are contained in respective Microsoft Excel files (Compatible to Excel 2000/2003 and 2007 version). I've uploaded them on www.excelitems.com. Here is the Download Link :--> http://www.excelitems.com/2008/09/downloads.html Please do reply, if this was helpful to you. Regards Ashish Jain On Mar 5, 7:12 pm, ccraiff <ccra...@gmail.com> wrote: > I found this example online. It actually refreshed every 15 seconds > continuously, but if you press the F12 key, it will stop the refresh > (that way you do not have to ^Break the code) > > http://forums.pcworld.co.nz/showthread.php?t=54801 > > On Feb 28, 2:17 am, himu <himadri....@gmail.com> wrote: > > > Hi All, > > > I am trying to create a spreadheet of indian equity market. In the > > spreadsheet I have Nifty 50 stocks. I have linked the data fromnse > > india site. I have also created the drop down box of all the 50 > > scrips. Now my problem starts... 1))All i want to do is to keep a > > timer of less than 1 min (this is the lowest interval by default in ms > > excel for refresh). I know this can be done through writing macro..plz > > if anybody can help me in that. > > 2)) Suppose i select a particular scrip. i want another macro to > > record the change in price in another work sheet so that we can keep a > > tab on the % change of each and every tick data. > > > I would be helpful if any one can help me in writing the macro. I > > guess it would help all of us (who have interest in Indian stock > > market) --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
