Portfolio Manager
This is a simple spreadsheet that allows you to pull stock quotes in from Yahoo Finance, for a range named 'Stock Symbol'. If you change the symbol, the company names and stock prices will change as well. This spreadsheet just makes it easier to track a portfolio using Excel.
For NSE use 9 or less Character NSE Code and suffix with .NS(i.e NSE Code for Infosys is INFOSYSTCH so in Stock Symbol type INFOSYSTC.NS)
For BSE use BSE Code and suffix with .BO (i.e BSE Code for Infosys is 500209 so in Stock Symbol Type 500209.BO)
Step1: Add your stock in Stock List Sheet,Get Yahoo Quote for the same.
Step2: Then Add your Stock in your Portfolio Sheet.
Virtually all-financial quotes tell you the amount that a stock has changed since the prior close. One benefit of this spreadsheet approach is that by recording your observation, you can review the change since the last time you looked at your portfolio, whether that was an hour or a week ago.
This is written in visual basic for excel, and we have left the source code open.
Discuss about portfolio manager excel
|
|
Google Pack(A free collection of essential software) provides a single installer for many essential PC applications from Google and other trusted partners. These applications improve your browsing with increased speed and security, provide better searching capability for the web and for your own PC and enable you to collect and organize your personal data, including photos.
'Google Pack' include following softwares:
- Google Desktop
- Google Earth
- Picasa
- Google Toolbar for Internet Explorer
- Google Pack Screensaver
Additional Software Included:
- Mozilla Firefox with Google Toolbar
- Ad-Aware SE Personal
- Norton Antivirus 2005 Special Edition
- Adobe Reader 7
Optional Software:
- Google Talk
- Google Video Player
- RealPlayer
- GalleryPlayer HD Images
|
