MY Excel stock tracker

Discussion in 'Software' started by amitkr, Aug 18, 2005.

Thread Status:
Not open for further replies.
  1. amitkr

    amitkr Member

    Joined:
    Aug 6, 2005
    Messages:
    118
    Likes Received:
    10
    Trophy Points:
    18
    Location:
    Delhi
    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: Sep 17, 2009
  2. vachhanipm

    vachhanipm Member

    Joined:
    May 17, 2005
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6
    Hi Amitkr,

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

    regards,
    vachhanipm
     
  3. amitkr

    amitkr Member

    Joined:
    Aug 6, 2005
    Messages:
    118
    Likes Received:
    10
    Trophy Points:
    18
    Location:
    Delhi

    Thanks :)
     
  4. wastej@cinci.rr.com

    wastej@cinci.rr.com Member

    Joined:
    Jun 21, 2005
    Messages:
    175
    Likes Received:
    3
    Trophy Points:
    18
    Will the tracker will track stocks only or it will track futures and options also?

    Wastej
     
  5. blrboy

    blrboy Member

    Joined:
    Aug 7, 2005
    Messages:
    35
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    bangalore
    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
     
  6. geeaar

    geeaar New Member

    Joined:
    Apr 26, 2005
    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    3
    amitkr, nice job thanks for this will it track F&O also???
    ram
     

  7. joy_mitali

    joy_mitali Member

    Joined:
    Mar 30, 2005
    Messages:
    494
    Likes Received:
    9
    Trophy Points:
    18
    Location:
    Kolkata
    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
     
  8. amitkr

    amitkr Member

    Joined:
    Aug 6, 2005
    Messages:
    118
    Likes Received:
    10
    Trophy Points:
    18
    Location:
    Delhi

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

    blrboy Member

    Joined:
    Aug 7, 2005
    Messages:
    35
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    bangalore
    Thanks! u the man!
     
  10. joy_mitali

    joy_mitali Member

    Joined:
    Mar 30, 2005
    Messages:
    494
    Likes Received:
    9
    Trophy Points:
    18
    Location:
    Kolkata
    Hi Amit---
    Thanks too---from my behalf---
    Wil keep updated in time---
    Regards,
    joy_mitali
     
    kamlendrasinh likes this.
Loading...
Thread Status:
Not open for further replies.

Share This Page