|
| Discuss MY Excel stock tracker at the Software within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Hil, Still a noobie as far as trading is concerned so cant help much on ... |
|
|||||||
| Notices |
| Software Charting, trading & technical analysis software, trading system development and backtesting. |
 |
|
|
Thread Tools |
| Sponsored Links |
|
#1
18th August 2005, 06:00 PM
|
|||
|
|||
MY Excel stock tracker - UPDATED 1.3 :)
Hil,
Still a noobie as far as trading is concerned so cant help much on that ground.. Am a techie so helping in a way I can ... I coded an excel sheet capable of downloading quotes ... So wanted to share it with all you friends.. If you have to closely track a list of scrips this will be of great help... How to use: 1. UNZIP (using winzip... or whatever u like) 2. Double click on My Tracker.xls 3. A prompt(macro warning) will appear click on Enable macros 4. This sheet downloads data from ************* , so u have to use there symbols. The existing file contains the symbols I used to track.. You can delete them and put your own... 5.(If u r connected to the net )Now click on the Get Data button .. data will be refreshed. I keep refreshing the data... and also refresh the data EOD.. everyday. Tip: Login to ***** from your computer with the option Remember me on this computer selected... This way the excel sheet gives you LIVE NSE quotes .. BSE quotes are delayed by 15 mins I hope you will like it... Any issues please shout back  Thanks.. Amit Upadated the program to handle more than one worksheet ... So stocks can be placed on diffrent sheets... to keep things clean... check out Upadated to version 1.2 ... Now displays quotes like 1.21 , 1.26 etc... Initially it was showing only in multiple of 10 Updated to version 1.3 ... Added a sheet for INTRADAY informations Version 1.4 ... Bug fixed .. Code:
Hey Amit, Gr8 utility. Downloaded it last nite and now playing with it. Amazing. a small roadblock though. If I have more than 48 scripts to view at the same time then I encounter the following problem. The 49th script shows the rate of 50th script, the 50th script shows the rate of 51st script and so on. Can u work out a soln. for the same. Regards, Sanjoy Last edited by amitkr; 3rd November 2006 at 12:14 PM. 
|
|
#2
19th August 2005, 12:50 AM
|
|||
|
|||
|
Re: MY Excel stock tracker
Hi Amitkr,
Good contribution to the forum. We all r thankful to you. regards, vachhanipm
|
|
#4
19th August 2005, 09:11 AM
|
|||
|
|||
|
Re: MY Excel stock tracker
Will the tracker will track stocks only or it will track futures and options also?
Wastej
|
|
#5
19th August 2005, 09:17 AM
|
|||
|
|||
|
Re: MY Excel stock tracker
Could you also post the src code of this, so it can be extended for tracking futures as well as options. In fact the forum folks could extend it to do a multitude of tasks...if you dont mind pls share the macro source.
thanks in advance
|
|
#7
19th August 2005, 09:30 AM
|
|||
|
|||
|
Re: MY Excel stock tracker
Hi AmitKr---,
Thanks for ur contribution----I too agree with blrboy----If u can share the source code for benefit of all(At least to those who wont use it for their own professional purposes---of selling the code)----we all can really extend it to numerous other aspects of trading----- mail id:joy_mitali@************* Thanks, Regards, joy_mitali
|
|
#8
19th August 2005, 11:10 AM
|
|||
|
|||
Re: MY Excel stock tracker
Quote:
I believe in open source The macro vba password for this file is goodwork Any suggestion please lemme know... I will be more than happy to contribute in a way I can Thanks.
|
|
#10
19th August 2005, 04:52 PM
|
|||
|
|||
|
Re: MY Excel stock tracker
Hi Amit---
Thanks too---from my behalf--- Wil keep updated in time--- Regards, joy_mitali
|
| Sponsored Links |
|
|
|
| Bookmarks |
| Thread Tools | |
|
|
Similar Threads for: MY Excel stock tracker
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| An anatomy of the Stock Market! - Bull & Bear Market Cycles | Traderji | Trading Psychology | 57 | 6th July 2008 02:32 PM |
| Need BSE Stock Price List in Electronic form (Excel, CSV format) | gharesh | Equities | 5 | 20th June 2008 07:55 PM |
| FREE Stock Charts with Excel | TATrader | Technical Analysis | 4 | 16th June 2008 11:16 AM |
| Indian Stock Markets | hometypist | Equities | 9 | 16th January 2008 05:37 PM |
| The Deadly Art Of Stock Manipulation Pt1 | Joeblack | Trading Psychology | 28 | 29th July 2007 09:13 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.
