Traderji.com - Discussion forum for Stocks Commodities & Forex


MY Excel stock tracker

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 ...


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

Software Charting, trading & technical analysis software, trading system development and backtesting.


Reply
 
Thread Tools
  #1  
Old 18th August 2005, 06:00 PM
Member
 
Join Date: Aug 2005
Location: Delhi
Posts: 118
Thanks: 0
Thanked 9 Times in 1 Post
amitkr is on a distinguished road
Default 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 Yahoo.co.in , 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 Yahoo 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; 17th September 2009 at 12:23 AM.
Reply With Quote
The Following 9 Users Say Thank You to amitkr For This Useful Post:
absolute.zero (9th December 2010), anayash (21st October 2010), anshuman.chaudhuri (4th November 2008), Daas (8th October 2009), justmusafir (17th October 2009), mako1mako (30th October 2008), pcmdfin (31st December 2009), raakesh (5th July 2010), ratnesh61 (18th April 2010)
Sponsored Links
  #2  
Old 19th August 2005, 12:50 AM
Member
 
Join Date: May 2005
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
vachhanipm is on a distinguished road
Default Re: MY Excel stock tracker

Hi Amitkr,

Good contribution to the forum. We all r thankful to you.

regards,
vachhanipm
Reply With Quote
  #3  
Old 19th August 2005, 02:22 AM
Member
 
Join Date: Aug 2005
Location: Delhi
Posts: 118
Thanks: 0
Thanked 9 Times in 1 Post
amitkr is on a distinguished road
Default Re: MY Excel stock tracker

Quote:
Originally Posted by vachhanipm
Hi Amitkr,

Good contribution to the forum. We all r thankful to you.

regards,
vachhanipm

Thanks
Reply With Quote
  #4  
Old 19th August 2005, 09:11 AM
Member
 
Join Date: Jun 2005
Posts: 175
Thanks: 0
Thanked 3 Times in 2 Posts
wastej@cinci.rr.com is on a distinguished road
Default Re: MY Excel stock tracker

Will the tracker will track stocks only or it will track futures and options also?

Wastej
Reply With Quote
  #5  
Old 19th August 2005, 09:17 AM
Member
 
Join Date: Aug 2005
Location: bangalore
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
blrboy is on a distinguished road
Default 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
Reply With Quote
  #6  
Old 19th August 2005, 09:26 AM
Member
 
Join Date: Apr 2005
Posts: 22
Thanks: 0
Thanked 1 Time in 1 Post
geeaar is on a distinguished road
Default Re: MY Excel stock tracker

amitkr, nice job thanks for this will it track F&O also???
ram
Reply With Quote
  #7  
Old 19th August 2005, 09:30 AM
Member
 
Join Date: Mar 2005
Location: Kolkata
Posts: 494
Thanks: 1
Thanked 6 Times in 5 Posts
joy_mitali is on a distinguished road
Default 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@yahoo.co.in

Thanks,
Regards,
joy_mitali
Reply With Quote
  #8  
Old 19th August 2005, 11:10 AM
Member
 
Join Date: Aug 2005
Location: Delhi
Posts: 118
Thanks: 0
Thanked 9 Times in 1 Post
amitkr is on a distinguished road
Thumbs up Re: MY Excel stock tracker

Quote:
Originally Posted by joy_mitali
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@yahoo.co.in

Thanks,
Regards,
joy_mitali

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.
Reply With Quote
  #9  
Old 19th August 2005, 11:55 AM
Member
 
Join Date: Aug 2005
Location: bangalore
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
blrboy is on a distinguished road
Default Re: MY Excel stock tracker

Thanks! u the man!
Reply With Quote
  #10  
Old 19th August 2005, 04:52 PM
Member
 
Join Date: Mar 2005
Location: Kolkata
Posts: 494
Thanks: 1
Thanked 6 Times in 5 Posts
joy_mitali is on a distinguished road
Default Re: MY Excel stock tracker

Hi Amit---
Thanks too---from my behalf---
Wil keep updated in time---
Regards,
joy_mitali


Reply With Quote
The Following User Says Thank You to joy_mitali For This Useful Post:
kamlendrasinh (21st October 2008)
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: MY Excel stock tracker
Thread Thread Starter Forum Replies Last Post
An anatomy of the Stock Market! - Bull & Bear Market Cycles Traderji Trading Psychology 70 9th December 2013 10:00 AM
FREE Stock Charts with Excel TATrader Technical Analysis 7 12th February 2011 04:44 PM
Need BSE Stock Price List in Electronic form (Excel, CSV format) gharesh End of Day 8 1st November 2008 07:55 AM
Indian Stock Markets hometypist Equities 9 16th January 2008 04:37 PM


All times are GMT +5.5. The time now is 04:53 PM.

Indemnity, Disclaimer & Disclosure Notice:
By visiting Traderji.com you automatically indicate that you agree to our Forum Rules, Indemnity, Disclaimer & Disclosure Notice and General Content Disclaimer Notice and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum/site.
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. You are recommended to make appropriate enquiries and seek appropriate advise before sending money, incurring any expenses, acting on recommendations or entering into any commitment in relation to any advertisement published here. Traderji.com does not vouch for any claims made by the advertisers of products and services. Traderji.com will not be held liable for any consequences in the event such claims are not honoured by the advertisers. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of any information by anybody mentioned anywhere on this site.
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 or legality of any 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. Although we constantly delete all irrelevant content and/or SPAM, if you should 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 © www.Traderji.com 2001 - , All rights reserved.

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246