Portfolioslicer (Automated Excel portfolio tracker) - Page 7
Page 7 of 16 FirstFirst ... 56789 ... LastLast
Results 61 to 70 of 152

Thread: Portfolioslicer (Automated Excel portfolio tracker)

  1. #61
    Member
    Join Date
    Mar 2012
    Posts
    85
    In my workbook I always enter Payment date. I do this to match my bank statements with my own generated statements. Side effect is that dividends in your example will be assigned and reported in year 2015. But because I do this consistently year over year, my 2014 dividends include some of the 2013 data and so on.
    You could use record date or ex-dividend date and assign distribution to proper month/year, but that would be more work for you - you would have to track each distribution and find these dates.

    Free investment tracking in Excel: Hidden Content

  2. #62
    Junior Member
    Join Date
    Jun 2013
    Posts
    6

    Will it work with Excel 2007??

    Hi Vidm,

    Will portfolio slicer work with Microsoft Office Enterprise Excel 2007.

    I wanted to know before I register and set up my portfolio

    Thanks for your great efforts.

    apatel

  3. #63
    Member
    Join Date
    Mar 2012
    Posts
    85
    Quote Originally Posted by apatel View Post
    Hi Vidm,

    Will portfolio slicer work with Microsoft Office Enterprise Excel 2007.

    I wanted to know before I register and set up my portfolio

    Thanks for your great efforts.

    apatel
    Hi Apatel,

    No, Sorry, Portfolio Slicer will not work with Excel 2007 as it needs PowerPivot add-in that was introduced just in Excel 2010 and then later integrated into Excel 2013.
    Free investment tracking in Excel: Hidden Content

  4. Remove Advertisements
    CanadianMoneyForum.com
    Advertisements
     

  5. #64
    Senior Member
    Join Date
    Nov 2010
    Location
    GTA
    Posts
    1,488
    Whats in for the next update vidm ?

    Any big plan for a 1.0 release ?
    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE

  6. #65
    Senior Member
    Join Date
    Nov 2010
    Location
    GTA
    Posts
    1,488
    vidm, regarding RESP tracking in portfolioslicer, what TransType/TransSubType would you use for government grant ?
    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE

  7. #66
    Member
    Join Date
    Mar 2012
    Posts
    85
    Quote Originally Posted by larry81 View Post
    Whats in for the next update vidm ?

    Any big plan for a 1.0 release ?
    I am not sure yet, there might be 0.9.9 release before 1.0. But I am close to having release that has features that I believe must be present in Portfolio Slicer. I am working on it every day. There will be option not to track cash and help with dividends .
    Free investment tracking in Excel: Hidden Content

  8. #67
    Member
    Join Date
    Mar 2012
    Posts
    85
    Quote Originally Posted by larry81 View Post
    vidm, regarding RESP tracking in portfolioslicer, what TransType/TransSubType would you use for government grant ?
    I probably would add this as TransType = 'Deposit', TransSubType = 'Grant'. Alternative would be to add it as TransType = 'DivTA', TransSubType='Grant', but then your dividends would be affected.
    In any way you will have to create your own report (Pivot Table) that shows data by TransSubType so you would know what deposits you made and what part was grant.
    Free investment tracking in Excel: Hidden Content

  9. #68
    Junior Member
    Join Date
    Jun 2013
    Posts
    6
    Quote Originally Posted by vidm View Post
    Hi Apatel,

    No, Sorry, Portfolio Slicer will not work with Excel 2007 as it needs PowerPivot add-in that was introduced just in Excel 2010 and then later integrated into Excel 2013.
    Thanks vidm, I am planning to buy a new laptop. I will then be able to use this

    apatel

  10. #69
    Senior Member
    Join Date
    Nov 2010
    Location
    GTA
    Posts
    1,488
    Portfolioslicer is DIY investor best friend !

    I look at my dashboard daily
    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE

  11. #70
    Senior Member
    Join Date
    Nov 2010
    Location
    GTA
    Posts
    1,488
    vidm not sure if you still monitor this thread but i have a question regarding recent activity in my non-reg account:

    Transaction date: 2015-03-09
    Settlement date: 2015-01-06
    Description: VANGUARD FTSE CDA IDX ETF
    Type: CG DIV
    Units: -17 234
    Price:5 081,62$
    Comm.: 0$

    Bascily, its a Capital Gain Dividend, should lower my ACB, how should i enter this in portfolioslicer ?

    Best regards

    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE

Page 7 of 16 FirstFirst ... 56789 ... LastLast

Tags for this Thread

Posting Permissions

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