Dear friends,
Herewith you may find an excel utility for viewing Stock Charts From Yahoo site.
Hope it will be of some help to you guys. Any comments about the file may please be posted here for the improvement.
The features about the utility file may be found in the Help Sheet of the file.
regards
Chachi
____________________________________________________________________________________
Version 1.1 dated 27-08-2006
File link is provided at the end....
About File StkChartsFromVariousSitesInXL_V1.1
List of Stocks, both for NSE and BSE are placed in the sheet by name "ListOfStocks". Any additions/deletions can be made to this sheet & can be sorted by clicking Sort button. The updated stocks will appear in StockChart sheet, cells J2, K2 & L2.
Yahoo NSE Indices are added in the First coloumn (A:A) of Sheet "ListOfStocks". Any new indices may be added in this coloumn for viewing corresponding charts.
StockChart sheet gives you drop down cells, J2 & K2, for selecting the scrip you need. Drop down arrow appears when you select these cells.
For BSE stock - name to be selected from the list in K2 cell and the code automatically loads in L2. Click on this code in L2 cell and select the type of chart you need to view.
NSE & BSE-site charts gets loaded from NSE & BSE sites respectively and are real time charts.
NSE-site Chart, a real time chart but a basic type chart.
BSE-site Chart is real time and a Technical Analysis chart.
Both BSE and NSE-Charts are Interactive charts. i.e. you can interact with them by selecting various parameters from within the chart window and get the results.
Yahoo Real Time Basic chart is also provided, enhancing the features.
In case of NSE & BSE-site charts the Back & Forward button loads from the site and not from the memory and hence the loading takes a while.
Charts from BSE and NSE require java applets and may not load if it is absent in your PC.
If you need to view any other scrip chart by putting its name, you can do it by inputting directly in B2 cell. For NSE stocks, input its name without ".NS" & for BSE stocks input its code including ".BO". This input will not disturb any settings.
For viewing any NSE scrip, now you need to input the NSE scrip name as available in NSE BhavCopy (up to 10 chars), without any ".NS" attached to it. For the same scrip Yahoo charts takes only 9 characters automatically.
You may use ctrl + mouse scroll to zoom in and zoom out the window.
This Workbook is prepared and tested successfully under Windows XP and Office 2003 environment.
Allowing Customization of charts from yahoo site is yet to be worked out & will be produced later.
Any comments/suggestions may please be posted here in this thread
Regards
Chachi
Download :-
................................................................................................................................
Link for the Version 1.1 dated 27-08-2006... Version 1.1
................................................................................................................................
Link for the Version 1.2 dated 08-09-2006... Version 1.2
................................................................................................................................
First version dated 23-08-2006:-