|
|
| Discuss MY Excel stock tracker at the Software within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Hi, Thanks for the contribution, however I want to make my own file for my ... |
|
|||||||
| Notices |
| Software Charting, trading & technical analysis software, trading system development and backtesting. |
 |
|
|
Thread Tools |
| Sponsored Links |
|
#81
2nd April 2006, 01:08 AM
|
|||
|
|||
Re: MY Excel stock tracker
Hi,
Thanks for the contribution, however I want to make my own file for my own use. So, can u help me to provide me the code to retrieve stocks prices. U can also mail me the code at my ID 'rajpalmanish123@gmail.com'. 
|
| Sponsored Links |
|
#82
8th April 2006, 10:42 PM
|
|||
|
|||
|
Re: MY Excel stock tracker
thanks for good traker
|
|
#84
27th April 2006, 03:36 AM
|
|||
|
|||
Re: MY Excel stock tracker
Hi Amit
The excel spread sheet you have created is really a good one. Thanks a ton for it. My suggestions, may be it's my personal preference, is to display data row wise (O L C H V) in place of column wise as is the current case. By using this method, you can have more scrip viewable than what the current settings allows and will take care of demand of a lot of people to include volume. Also, it is again a suggestion, is to use the NSE data to update the sheets. All this will require downloading the data for all the scrip and then filtering out the users requested data. May be you can try this link for an example. strurl="http://www.nseindia.com/content/historical/EQUITIES/2006/APR/cm26APR2006bhav.csv" The last three parts will be variables in the URL. Year 2006 (format YYYY) Month MMM & CM+day+MMM+YYYY+bhav.csv Ofcourse, downloading the complete scrip means a download of some 50KB. But is more reliable, as its from NSE. There was one more request I could see back in the thread where some one has requested for some kind of alerts when a pre-specified condition is met. You may include a timer in the sheet, I know that is directly not possible in excel, but may be you can use some third party ActiveX for this, or something similar. This will prove to be very useful for people who cannot keep track of their favorite scrip as are busy with the office. There is no end to the wish list. But these were the one currently on top of my mind. These were my humble suggestions. Please let me know if I can be of any help. Keep up the good work. Best Regards, Coool.
|
|
#86
16th May 2006, 08:33 PM
|
|||
|
|||
|
Re: MY Excel stock tracker
Hi Amitkr
I have been using your excel spreadsheet(ver 1.3) for quite sometime .Quite a useful spreadsheet.Thanks for the same.I believe you have now ver 1.4.Pls advice from where can I download it. Thanks rpc
|
|
#87
17th May 2006, 01:11 PM
|
|||
|
|||
|
Re: MY Excel stock tracker
Hi Amit
I am also using this file for last few days exclusily to get daily data. Thanks for developing such a nice file/software. Is it possible to insert few rows at the top to maintain purchase data etc for quick glance. The stocks are from left to right after GET DATA. Can you please please mail the excel sheet with same function but from top to bottom.. my email id is almirfa06@yahoo.com thanks ger
|
|
#88
17th May 2006, 02:27 PM
|
|||
|
|||
|
Re: MY Excel stock tracker
Amit
I am newbie in this arena, downloaded you excelsheet. Do you have any kind of documentation of each sheet functionality and purpose of the sheet? Can you not set timer on intraday, so using defined interval, data will get refresh automatically? On Index sheet, how can see the data of old dates, I added old dates but nothing will be generated, is there any othere way to update this? Current Holding - How can I use this worksheet? Watching - What is the purpose of this sheet and how it works? I tried various script code, nothing works? Penny - What is the purpose of this? and how it can be use? Intraday - Can we not set timer or interval so it will refresh automatically? All gurus, forgive me, I am asking very beginner question as I told I am newbie in this arena. I will appreciate any reply. Ashish
|
|
#90
17th May 2006, 06:02 PM
|
|||
|
|||
|
Re: MY Excel stock tracker
Quote:
Hi Ashish, Various sheets watching, penny,index are just to categorise the stocks... I used them for my convenience.... Using this tool you can get only todays data.... No past dates(Yahoo doesn't provide Historical data for indian stocks) Sorry never got the time to document this... but its very simple ... just play with it and you will know... Regards Amit
|
| 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 | 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 |
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.
