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; Originally Posted by amitkr Hil, Still a noobie as far as trading is concerned so ...


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

Notices

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


Advertise Here

Reply
 
Thread Tools
Sponsored Links
  #31  
Old 31st August 2005, 08:30 AM
Member
 
Join Date: Aug 2005
Posts: 274
Thanks: 0
Thanked 1 Time in 1 Post
ragh_ash is on a distinguished road
Reputation: 21
Default Re: MY Excel stock tracker - UPDATED 1.3 :)

Quote:
Originally Posted by amitkr
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
thx amit,
i mean i am really greatful for such a wonderful thing.
of course i am no Software technie so the VB source code is nouse to me.
i just want to know how many symbols i can add. because when i cut and paste the program does not retieve data for last codes.
regards
ragh_ash
Reply With Quote
Sponsored Links
  #32  
Old 31st August 2005, 08:57 AM
Member
 
Join Date: Aug 2005
Location: Delhi
Posts: 117
Thanks: 0
Thanked 2 Times in 1 Post
amitkr is on a distinguished road
Reputation: 25
Default Re: MY Excel stock tracker

Quote:
Originally Posted by wastej@cinci.rr.com
I would like to request, to upload the stock tracker, after it has been improved upon so that we can download the latest version.

Thank you.

Wastej
Everytime I updated it I placed the latest version for download on the very 1st post of this thread... Get it from there ... Thanks
Reply With Quote
  #33  
Old 31st August 2005, 09:00 AM
Member
 
Join Date: Aug 2005
Location: Delhi
Posts: 117
Thanks: 0
Thanked 2 Times in 1 Post
amitkr is on a distinguished road
Reputation: 25
Default Re: MY Excel stock tracker - UPDATED 1.3 :)

Quote:
Originally Posted by ragh_ash
thx amit,
i mean i am really greatful for such a wonderful thing.
of course i am no Software technie so the VB source code is nouse to me.
i just want to know how many symbols i can add. because when i cut and paste the program does not retieve data for last codes.
regards
ragh_ash

I think at present this works for 200 symbols....(I coded it using my requirements) .. but can be easily upgraded for any no....

How many symbols you are trying to use?
Reply With Quote
  #34  
Old 31st August 2005, 10:24 AM
Member
 
Join Date: Aug 2005
Location: bangalore
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
blrboy is on a distinguished road
Reputation: 20
Default Re: MY Excel stock tracker

Yahoo Limits Symbols To 200 For Each Query. If You Want More, The Code Will Have To Be Tweaked To Issue Multiple Calls By Packaging 200 At A Time.
Reply With Quote
  #35  
Old 31st August 2005, 11:20 AM
Member
 
Join Date: Aug 2004
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
ksvelusamy is on a distinguished road
Reputation: 20
Default Re: MY Excel stock tracker

Now my excel stock tracker is not updating any problem on my computer. or anything else
Reply With Quote
  #36  
Old 31st August 2005, 11:26 AM
Member
 
Join Date: Aug 2005
Location: Delhi
Posts: 117
Thanks: 0
Thanked 2 Times in 1 Post
amitkr is on a distinguished road
Reputation: 25
Default Re: MY Excel stock tracker

Quote:
Originally Posted by blrboy
Yahoo Limits Symbols To 200 For Each Query. If You Want More, The Code Will Have To Be Tweaked To Issue Multiple Calls By Packaging 200 At A Time.

Correct ...
Reply With Quote
  #37  
Old 31st August 2005, 12:57 PM
Member
 
Join Date: Aug 2004
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
ksvelusamy is on a distinguished road
Reputation: 20
Default Re: MY Excel stock tracker

After restarting my computer it is properly working
thanx
Reply With Quote
  #38  
Old 2nd September 2005, 11:25 PM
Member
 
Join Date: Apr 2005
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts
sramrutia is on a distinguished road
Reputation: 19
Default Re: MY Excel stock tracker - UPDATED 1.3 :)

Quote:
Originally Posted by amitkr
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

why not u give in live bhav copy metastock format?it is most useful. at the end it beomes bhav copy and in intra day it can be exported to other software
Reply With Quote
  #39  
Old 3rd September 2005, 01:37 AM
Member
 
Join Date: May 2005
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
vachhanipm is on a distinguished road
Reputation: 20
Default Re: MY Excel stock tracker - UPDATED 1.3 :)

Hi Amitkr,

I used yr spreadsheet. Its great but i m unable to refresh the old data. I can refresh only last day data. Can u help me ..???

regards

vachhanipm
Reply With Quote
  #40  
Old 4th September 2005, 12:26 AM
Member
 
Join Date: Aug 2005
Location: Delhi
Posts: 117
Thanks: 0
Thanked 2 Times in 1 Post
amitkr is on a distinguished road
Reputation: 25
Default Re: MY Excel stock tracker - UPDATED 1.3 :)

Quote:
Originally Posted by vachhanipm
Hi Amitkr,

I used yr spreadsheet. Its great but i m unable to refresh the old data. I can refresh only last day data. Can u help me ..???

regards

vachhanipm
Hi vachhanipm,

This sheet gets data for today only....

U cant refresh old data

Amit
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: MY Excel stock tracker
Thread Thread Starter Forum Replies Last Post
An anatomy of the Stock Market! - Bull & Bear Market Cycles Traderji Trading Psychology 59 30th November 2008 12:42 AM
Need BSE Stock Price List in Electronic form (Excel, CSV format) gharesh End of Day 8 1st November 2008 07:55 AM
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


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

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