For those of you who didn't read my earlier thread, I've been sharing an Excel spreadsheet that keeps track of your portfolio. Its originally a Microsoft template, but I've modified it to add a lot more functionality.
The newest feature: Refreshable stock quotes. You no longer need to manually enter stock information to update your portfolio, you just hit a button!
For this feature, you do need to download something from Microsoft. Its a Stock Quote add-in, that allows all of this to work. The add-in is only 320kb, so its a fast download. Go here, click on the Download link, and choose "Open". The installer will do the rest.
http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=en
For those of you who have my portfolio manager, you need to add the following line of code. For the "Current Quote" column, add the following:
=MSNStockQuote("????","Last Price","US")
In the above line of code, just replace the Question Marks with your stock symbol. The spreadsheet will automatically pull the last selling price, and you're set! Oh, you may want to format the cells to display 3 digits after the decimal, to receive the most accurate last price.
If there are any questions or any requests for the portfolio file, just reply to this thread.
uncle milty
miltymullet@yahoo.com
The funny part is that I'm in class...haha
Fozzy
I'm in the process of writing some instructions, and trying to force Excel to do something extra special. So just give me a little bit more time, and you'll have an even better portfolio manager
if I download it, I get problems with Excell. It shuts itself down and says an error has occured. The problem is gone when I remove the add in.
Could it be because I use 2000... in stead of 2002...???
pres
It is possible that it wont work with Excel 2000. I will check and see if it works on one of my other computers.
If you are receiving an error message though, could you post what the error says? I may be able to help troubleshoot and fix the problem.
-----
Bauer,
What problem are you having with Office 2003? The download is designed for 2002, and thus should be compatible with Excel 2003. Can you explain your problem, or tell me what errors you are receiving?
I would recommend doing a search by keywords though, as there are a ton of templates to look at.
I would love a copy as well please.
risc999@yahoo.com
thanks
As I told you via email, the template works quite well, even in Quatra Pro. Of course, the add-on won't work as it is designed for Excel. I did do a small amount of tweaking to your original however. I added two new columns ... Date Bought and Date Sold.
Thanks again.
Walt
Also customized the quote column so that in the quote it pulls the symbol from the SYMBOL column and looks it up instead of manually having to type it in.
If you guys want these formulas lemme know I'll post them, that is if GK doesn't mind the customization
There seems to be compatability issues with Excel versions, below the 2002 release. Anything above that(2003, XP) should work fine.
I'm trying to tweak the file on my Excel 2000 version to make it work, and if I can, I'll make a seperate file for that version.
quote:
Originally posted by Marcidius:
Also customized the quote column so that in the quote it pulls the symbol from the SYMBOL column and looks it up instead of manually having to type it in.
I made that change also. The most current version has that feature.
I dont mind at all if anyone tweaks the thing and improves it, just share the changes if they're really good/helpful
quote:
Originally posted by Marcidius:
I've customized it a little too so that in the trade fees it puts a 5.00 if I have a buy price put in, and adds 5.00 to it if there is a sell price recorded.
Marcidius,
Thats a good change for us Lowtrade users, but I left it out originally because of those block fees. I still haven't seen a charge for my purchase of 125,000 shares, but if they add some Misc. fees, it will through off the formula. So if you ever experience a fee like that, remember to add it in by hand.
And yes if I ever find any Misc. fees I will definitely add that in, good point. Thanks for the sheets and the help GK!
Formula (just paste it in the first column under "trade fees"):
=IF(D6 > 0, IF(E6 > 0, 10, 5), 0)
Can you please send me your latest and greatest excel porfolio sheet. Thanks Chris
chrissy1@eircom.net
quote:
Originally posted by GreenKnight37:
Marcidius,Thats a good change for us Lowtrade users, but I left it out originally because of those block fees. I still haven't seen a charge for my purchase of 125,000 shares, but if they add some Misc. fees, it will through off the formula. So if you ever experience a fee like that, remember to add it in by hand.
Thank you for using Allstocks.com.
quote:
Originally posted by Marcidius:
Newstockpicker: did you get it to automatically place the date, or do you enter it? I am trying to figure out if there is a function to get the current date built into Excel.
Thanks
tlseabaugh@earthlink.net
quote:
Originally posted by bauer:
The one for office 2003 differs a lot. It won't let you insert just the current stock quote. It gives you ALL the information inclusing high/low etc.... not so benificial ;/
Bauer,
I believe I know what you're talking about. That is a different stock feature in Excel, it is not the Add-in that I am using for my spreadsheet.
The one you're referring to displays the large graphic, with all sorts of information, right? Thats just a built in feature, try out the Stock Quote Add-In instead. You can specify exactly what you want to be displayed(high, low, close, bid, volume, etc)