MY Excel stock tracker
- Thread starter amitkr
- Start date
- Status
- Not open for further replies.
hi buddy i urtracker is a good one. Can u pls check the link http://www.traderji.com/equities/6655-new-trading-method-have-look-its-goldmine.html
this is a method posted by me which has shown mw significant results over a few weeks. But it needs Socks opening HIgher than previous close price n stocks opening lower than previous close price and the respective %. Can u pls include that in the EXcel Stocktracker to CAn u pls tel me how can i make that modification. PLS do reply or PM me.
this is a method posted by me which has shown mw significant results over a few weeks. But it needs Socks opening HIgher than previous close price n stocks opening lower than previous close price and the respective %. Can u pls include that in the EXcel Stocktracker to CAn u pls tel me how can i make that modification. PLS do reply or PM me.
ronald_peterson said:
hi buddy i urtracker is a good one. Can u pls check the link http://www.traderji.com/equities/6655-new-trading-method-have-look-its-goldmine.html
this is a method posted by me which has shown mw significant results over a few weeks. But it needs Socks opening HIgher than previous close price n stocks opening lower than previous close price and the respective %. Can u pls include that in the EXcel Stocktracker to CAn u pls tel me how can i make that modification. PLS do reply or PM me.
this is a method posted by me which has shown mw significant results over a few weeks. But it needs Socks opening HIgher than previous close price n stocks opening lower than previous close price and the respective %. Can u pls include that in the EXcel Stocktracker to CAn u pls tel me how can i make that modification. PLS do reply or PM me.
Hi Ronald,
I read the thread mentioned by you a couple of days back... Its nice but I never got the chance to try it out....
I will try to implement it.... but no promise as my workload nowadays hardly allows me any time...
Regards
Amit
Amit - You saved a weeks and weeks of effort for me giving this wonderful tool and utility and also giving the source code. Infact I was sheepish enough to try breaking your password using other means but I failed..I came back and thought Amit cannot be so bad...and lo and behold you have elevated yourself to the next altar..kudos to you man..I was almost breaking my head apart to get/code a similar utility but never understood the intricasies of yahoo or nse bhav copy...Your file works like a charm and I now am happily tracking EOD stocks with much more ease...
Some of my suggestions maybe if you have time could give a next version?
1. When I change the system date to a previous date and hit get data, the program is getting the current data. Is it possible to retrieve previous data? Just a thought..
2. Also if you could generalise this program to not lock the first four rows but make them relative it will help people to add rows above the first three rows for example tracking 52 week high/low, purchase price, target price to buy, target price to sell and then color code themselves to give visual indicators. I will try to see if I can alter your source code to do this, but as you are the author maybe you can do it in a jiffy rather than me nosing around with your stuff??
Once again...you deserve the applauses...
Regards
Satish
Some of my suggestions maybe if you have time could give a next version?
1. When I change the system date to a previous date and hit get data, the program is getting the current data. Is it possible to retrieve previous data? Just a thought..
2. Also if you could generalise this program to not lock the first four rows but make them relative it will help people to add rows above the first three rows for example tracking 52 week high/low, purchase price, target price to buy, target price to sell and then color code themselves to give visual indicators. I will try to see if I can alter your source code to do this, but as you are the author maybe you can do it in a jiffy rather than me nosing around with your stuff??
Once again...you deserve the applauses...
Regards
Satish
hi amit,
great tool, i've been trying to make something like this for way too long but since i'm not a techie i was struggling to find data i could use web query with. i'm so glad to have found this. if you could advise on how to transpose the rows and columns to have the company names vertically and the open, current etc columns (intra-day sheet, ver 1.4) horizontally, and have the data work, i'd really appreciate it.
great tool, i've been trying to make something like this for way too long but since i'm not a techie i was struggling to find data i could use web query with. i'm so glad to have found this. if you could advise on how to transpose the rows and columns to have the company names vertically and the open, current etc columns (intra-day sheet, ver 1.4) horizontally, and have the data work, i'd really appreciate it.
Guys,
I have tried to implement as many changes requested here as possible. Here is the link with the 1.5 version of the tracker. Please have a look and comment if you find some bugs.
Amit's Stock Tracker improved version 1.5
Amit - I am not sure if you were working on this, so I took the liberty to do the changes requested. Apologies if I treaded on a wrong space. I wanted others also to benefit from the changes I made to your software according to my needs.
As always feedback welcome.
Regards
Satish
I have tried to implement as many changes requested here as possible. Here is the link with the 1.5 version of the tracker. Please have a look and comment if you find some bugs.
Amit's Stock Tracker improved version 1.5
Amit - I am not sure if you were working on this, so I took the liberty to do the changes requested. Apologies if I treaded on a wrong space. I wanted others also to benefit from the changes I made to your software according to my needs.
As always feedback welcome.
Regards
Satish
satish_goteti said:
Amit - You saved a weeks and weeks of effort for me giving this wonderful tool and utility and also giving the source code. Infact I was sheepish enough to try breaking your password using other means but I failed..I came back and thought Amit cannot be so bad...and lo and behold you have elevated yourself to the next altar..kudos to you man..I was almost breaking my head apart to get/code a similar utility but never understood the intricasies of yahoo or nse bhav copy...Your file works like a charm and I now am happily tracking EOD stocks with much more ease...
Some of my suggestions maybe if you have time could give a next version?
1. When I change the system date to a previous date and hit get data, the program is getting the current data. Is it possible to retrieve previous data? Just a thought..
2. Also if you could generalise this program to not lock the first four rows but make them relative it will help people to add rows above the first three rows for example tracking 52 week high/low, purchase price, target price to buy, target price to sell and then color code themselves to give visual indicators. I will try to see if I can alter your source code to do this, but as you are the author maybe you can do it in a jiffy rather than me nosing around with your stuff??
Once again...you deserve the applauses...
Regards
Satish
Some of my suggestions maybe if you have time could give a next version?
1. When I change the system date to a previous date and hit get data, the program is getting the current data. Is it possible to retrieve previous data? Just a thought..
2. Also if you could generalise this program to not lock the first four rows but make them relative it will help people to add rows above the first three rows for example tracking 52 week high/low, purchase price, target price to buy, target price to sell and then color code themselves to give visual indicators. I will try to see if I can alter your source code to do this, but as you are the author maybe you can do it in a jiffy rather than me nosing around with your stuff??
Once again...you deserve the applauses...
Regards
Satish
Hi..
Breaking excel macro password is no big task (very simple). But I will advise you to password protect the code to stop any unintended code changes.
You can always share the password .
Regards
Amit
Last edited:
satish_goteti said:
Guys,
I have tried to implement as many changes requested here as possible. Here is the link with the 1.5 version of the tracker. Please have a look and comment if you find some bugs.
Amit's Stock Tracker improved version 1.5
Amit - I am not sure if you were working on this, so I took the liberty to do the changes requested. Apologies if I treaded on a wrong space. I wanted others also to benefit from the changes I made to your software according to my needs.
As always feedback welcome.
Regards
Satish
I have tried to implement as many changes requested here as possible. Here is the link with the 1.5 version of the tracker. Please have a look and comment if you find some bugs.
Amit's Stock Tracker improved version 1.5
Amit - I am not sure if you were working on this, so I took the liberty to do the changes requested. Apologies if I treaded on a wrong space. I wanted others also to benefit from the changes I made to your software according to my needs.
As always feedback welcome.
Regards
Satish
No worries ...
- Status
- Not open for further replies.
| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| P | stocks data stream to generate history in excel | Algo & Automated Trading | 0 | |
|
F&O STOCKS SECTOR WISE(MY EXCEL SHEET)-A PART OF TOP DOWN APPROACH | Advanced Trading Strategies | 2 | |
| A | How to make excel sheet with stock financials | Welcome | 0 | |
|
New Excel for stocks valuation | Software | 3 | |
| R | My Stocks Excel Tracker | Software | 1 |
Similar threads
-
stocks data stream to generate history in excel
- Started by pareshbhangale
- Replies: 0
-
F&O STOCKS SECTOR WISE(MY EXCEL SHEET)-A PART OF TOP DOWN APPROACH
- Started by Diptojyoti Mitra
- Replies: 2
-
-
-