Excel Based Financial Calculators - Page 3
Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 42

Thread: Excel Based Financial Calculators

  1. #21
    Senior Member Sustainable PF's Avatar
    Join Date
    Nov 2010
    Posts
    190
    Quote Originally Posted by sonneti View Post
    Are there any good "open office" based calculators?

    I think I'm going to have to switch back to excel again :/
    You should be able to convert the .xls into the OO format I would think ...

  2. #22
    Senior Member HaroldCrump's Avatar
    Join Date
    Jun 2009
    Posts
    7,253
    If you have Office 2007 or above, try saving as XLSX format.
    That is the "open" format and should work with other spreadsheet programs.

  3. #23
    Junior Member
    Join Date
    Feb 2011
    Posts
    3
    Hi All,
    I was looking for these. I even asked people from them but didn't get proper response.
    Thanks I got them in this forum.

  4. Remove Advertisements
    CanadianMoneyForum.com
    Advertisements
     

  5. #24
    Junior Member
    Join Date
    Jan 2011
    Location
    Halifax, Nova Scotia
    Posts
    3
    Thanks! just what i needed...

  6. #25
    Junior Member
    Join Date
    Nov 2011
    Posts
    3

    Smile Excel based investment analysis

    Thanks for the calculators Cannon_Fodder. Any chance of viruses in these before I enable the macros?

  7. #26
    Senior Member Barwelle's Avatar
    Join Date
    Feb 2011
    Location
    Alberta
    Posts
    742

    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.

    Attachment 90

    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!*

    Attachment 91

    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 11:59 PM.

  8. #27
    Member
    Join Date
    Apr 2009
    Posts
    90
    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.
    Attached Files Attached Files

  9. #28
    Senior Member Barwelle's Avatar
    Join Date
    Feb 2011
    Location
    Alberta
    Posts
    742
    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.

  10. #29
    Member
    Join Date
    Apr 2009
    Posts
    90
    Sub GetQuote()
    Dim ie As Object
    Set ie = CreateObject("InternetExplorer.Application")
    With ie
    .navigate "http://download.finance.yahoo.com/d/quotes.csv?s=" & "IBM" & "&f=l1"
    Do
    DoEvents
    Loop Until Not .busy
    Do
    DoEvents
    Loop Until .Document.readystate = "complete"
    Cells(1, 1) = .Document.body.innertext
    End With
    ie.Quit
    End Sub

    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.

  11. #30
    Member
    Join Date
    May 2009
    Location
    Canada
    Posts
    85
    Can we add this DCF stock model to the list?

    http://www.canadiancorner.ca/files/f...luation-model/

Page 3 of 5 FirstFirst 12345 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •