You should be able to convert the .xls into the OO format I would think ...
Originally Posted by sonneti
If you have Office 2007 or above, try saving as XLSX format.
That is the "open" format and should work with other spreadsheet programs.
I was looking for these. I even asked people from them but didn't get proper response.
Thanks I got them in this forum.
Thanks! just what i needed...
Excel based investment analysis
Thanks for the calculators Cannon_Fodder. Any chance of viruses in these before I enable the macros?
Investment Tracking Spreadsheet
Okay folks... I have been working on an Excel workbook to track stocks. It is a lot more complicated than I thought it would be to do this!
I'm posting it here so that others could use it. The only other one I've been able to come across is KaeJS', but since I do enjoy playing with Excel, thought I'd give a shot at it myself. There is a phoney account inputted already for demonstration.
The workbook is far from perfect, but it will work for me, for now. I don't have anything for options (as I don't fully understand them yet), share splits/reverse splits, things like that. There is no space for keeping track of taxes payable, though you should be able to figure it out using the dividend total and net profit columns in the ledger tab. Also, contributing and withdrawing cash part-way through the year throws off some of the gain/loss % calculations.
I am open to suggestions for how to improve it, and if there is enough interest I will update and create new versions for your use, then you can just copy/paste your info from the old tracking workbook into the new one. Maybe it is a good idea to subscribe to this thread so that you know when an updated version comes along, I really don't know yet how far this is going to go though.
v1.0 is a .xlsx file for Excel 2007 and 2010.
v1.0a is a .xls file for Excel 97-2003. *I cannot guarantee this will work properly, as I made the workbook in Excel 2010!*
I will post instructions on how to use the live quote sheet within the next few days. If anyone else knows an easier way to get live quotes, please share.
Last edited by Barwelle; 2012-02-23 at 10:59 PM.
I like the spreadsheet, but needs a little importing quotes. Try this. Just keep adding stock tickers down column A (unlimited).
It downloads from Yahoo, which doesn't have perfect source data, so be careful in trusting the data as you would be careful in trusting yahoo data on their website. Lookup the correct ticker value there.
Only works with Excel 2007.
Max, thanks for the tip, however it won't work for me. My computer won't let me run the macros due to security issues. Do you know how to create the macro to do this? I'm not too familiar with them. Ideally, I'd like to have something that will pull only the current market price straight into the cell on my "holdings" sheet.
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
.navigate "http://download.finance.yahoo.com/d/quotes.csv?s=" & "IBM" & "&f=l1"
Loop Until Not .busy
Loop Until .Document.readystate = "complete"
Cells(1, 1) = .Document.body.innertext
Cutting it down as simple as possible, this will get the current price for IBM into cell A1. Use a variable for the ticker symbol and change cells(1,1) to desired output range.
This should now work with earlier versions of Excel as well.