Portfolioslicer (Automated Excel portfolio tracker)
Results 1 to 10 of 152

Thread: Portfolioslicer (Automated Excel portfolio tracker)

\r\n
\r\n
\r\n
\r\n \r\n
\r\n larry81\r\n \r\n
\r\n larry81 is offline\r\n\r\n \r\n
\r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
\r\n
Join Date
Nov 2010
\r\n
Location
GTA
\r\n \r\n
Posts
1,486
\r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n vidm not sure if you still monitor this thread but i have a question regarding recent activity in my non-reg account:
\n
\nTransaction date: 2015-03-09
\nSettlement date: 2015-01-06
\nDescription: VANGUARD FTSE CDA IDX ETF
\nType: CG DIV
\nUnits: -17 234
\nPrice:5 081,62$
\nComm.: 0$
\n
\nBascily, its a Capital Gain Dividend, should lower my ACB, how should i enter this in portfolioslicer ?
\n
\nBest regards \r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n
\r\n \r\n \r\n \r\n \r\n
My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE
\r\n \r\n \r\n
\r\n \r\n
\r\n
\r\n
\r\n
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
\r\n
\r\n
\r\n\r\n'; pd[632850] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #2\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n Hi Larry,
    \n
    \nIn Portfolio Slicer there are 2 transaction types to deal with such distributions:
    \n
    \nNotionalDistrib Notional Distribution - Capital Gains Increases Book value!
    \nReturnOfCapital Return of Capital - Decreases book value!
    \n
    \nSo you simply enter distribution transaction with type "ReturnOfCapital", Qty=17234 and Price:5081.62\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[633338] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #3\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n larry81\r\n \r\n
    \r\n larry81 is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Nov 2010
    \r\n
    Location
    GTA
    \r\n \r\n
    Posts
    1,486
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n thanks vidm !!! Any plan for the next update ? \r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[638698] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #4\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by larry81\r\n View Post\r\n
    \r\n
    thanks vidm !!! Any plan for the next update ?
    \r\n \r\n
    \r\n
    \r\n
    Hi Larry,
    \n
    \nI am reviewing my own investments and I also see for XEI "CG DIV" transaction. I believe that these "CG DIV" transactions should "Increase" (!!!!) your ACB, so you should be using NotionalDistrib transaction type.
    \n
    \nHere is my look at that:
    \n
    \nLet say I invested in XEI stocks. During the year I receive dividends into my account (assuming regular account, NOT RRSP or TFSA), lets say 100$/month. Around March of next year I receive "Summary of Trust Income" from my bank that now tells me that every month (actually values every month could be different) I received:
    \n 90$ of "Total Capital gains, box 21"
    \n 8$ of "Actual Amount of eligible dividends, box 49"
    \n 2$ of "Return of Capital, box 42"
    \nAs I receive dividends every month I know that my "Return of Capital" for year is 24$ (12x2$).
    \nFor this in portfolio slicer I create 2 transactions for the last day of the year, or if stock was sold during the year, then I enter transactions one day before last sale.
    \nSymbol: XEI, TransType: DivTA, TransSubType: DivTypeAdj, Qty: 1000, Price: -24$
    \nSymbol: XEI, TransType: ReturnOfCapital, TransSubType: DivTypeAdj, Qty: 1000, Price: 24$
    \nSo with these 2 transactions I subtracted 24$ from general dividends paid by that symbol and then added 24$ for "Return of Capital" paid by that symbol. Total paid dividend stays the same.
    \nWith these transaction ACB will be reduced and that means when I will sell that symbol, my Capital Gain will be bigger.
    \n
    \nSome symbols have NotionalDistributions that are "Reinvested distributions". For example symbol XEI on Dec 29, 2014 paid 0.74306$ per share as "Reinvested Distributions". In my TD Waterhouse statement I see this as "CG DIV" transaction followed by "DRIP" transaction. Other banks might not post any transaction for such distribution. In Portfolio Slicer I enter this as one transaction:
    \nSymbol: XEI, TransType: NotionalDistrib, Qty: 1000, Price: 743.06$
    \nThis distribution is not really paid out as you do not see any change in your cash values.
    \nThis transaction increases ACB by distribution amount and that means when you will sell symbol, your capital gain will be smaller.
    \nPlease note that info about this distribution is not included in your "Summary of Trust Income" as separate transaction type, so really if you did not properly identify this transaction and adjust your ACB, you will pay extra tax. But if you carefully review "Summary of Trust Income" usually at the month of December you will see distribution paid that is bigger than amount you received in your account. Please note that if you carefully check T3, you will see that it includes that extra distribution. So really with Notional Distributions you pay Cap Gain tax in the year you receive it and then pay less tax when you sell your symbol.
    \n
    \nSo please double check what type of distribution is this so that you do not overpay tax!!
    \n
    \nRegarding next Portfolio Slicer version - I am working on it every day, I just do not want to rush releasing it before I am happy with functionality. I am not sure when next release will be done.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n \r\n Last edited by vidm; 2015-04-04 at 07:40 PM.\r\n \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[640689] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #5\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n chinamank\r\n \r\n
    \r\n chinamank is offline\r\n\r\n \r\n
    \r\n \r\n Junior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Jan 2015
    \r\n \r\n \r\n
    Posts
    16
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n Excel on steroids. Pretty slick.
    \nWith your server running in the cloud are you having any issues with quote refresh latency?
    \nCan the quote refresh times be modified at all?\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[642338] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #6\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by chinamank\r\n View Post\r\n
    \r\n
    Excel on steroids. Pretty slick.
    \nWith your server running in the cloud are you having any issues with quote refresh latency?
    \nCan the quote refresh times be modified at all?
    \r\n \r\n
    \r\n
    \r\n
    In Portfolio Slicer cloud database stock quotes are refreshed few times per day - mostly to accommodate different time zones (many users are from Europe, Asia) and to capture general days trend. Mutual fund prices are updates once a day - 5 hours after market close. Quote refresh time cannot be modified. Portfolio Slicer is designed for reporting on your investment performance, so having few hours delayed quotes should be sufficient for absolute majority of people.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[642394] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #7\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n m3s\r\n \r\n
    \r\n m3s is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n m3s\'s Avatar\r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Apr 2010
    \r\n
    Location
    Everywhere
    \r\n \r\n
    Posts
    3,080
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n I\'m still using it regularly and it\'s pretty much everything I wanted Quicken to be.
    \n
    \nOn the dashboard, one of my "top YTD winners" seems to be wrong, possibly counting gains from the book value or something (I repurchased it this year, shows as a YTD winner +24% but it\'s actually down slightly this year)
    \n
    \nWhen I reconciled the balances I also found that I had input some bank fees backwards (negative) Not sure if you could have a warning for that somehow but it\'s not a big deal
    \n
    \nI like the buttons for CAD/USD/original and the exchange rate impact etc. All the tabs are great insight as well and easy to use. \r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    amat victoria curam
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[644082] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #8\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n GGO\r\n \r\n
    \r\n GGO is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Feb 2015
    \r\n \r\n \r\n
    Posts
    35
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n i\'m trying this but find documentation seems a bit lagging and does not match current version. Can someone explain what\'s "account" and "portfolio" ? On existing demo and old version there is only portfolio which seems easier to handle. Not sure how I handle account vs. portfolio in the new version when I enter transactions. Thanks !\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[644322] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #9\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by GGO\r\n View Post\r\n
    \r\n
    i\'m trying this but find documentation seems a bit lagging and does not match current version. Can someone explain what\'s "account" and "portfolio" ? On existing demo and old version there is only portfolio which seems easier to handle. Not sure how I handle account vs. portfolio in the new version when I enter transactions. Thanks !
    \r\n \r\n
    \r\n
    \r\n
    Account usually matches your bank account.
    \nPortoflio - group of accounts that you group any way you want. For example you might use 2 values in portfolio - one your name and another your spouse name. Portfolio can be used to apply filter to report, for example you want to see just accounts that belong to you and not to your spouse.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[645482] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #10\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n GGO\r\n \r\n
    \r\n GGO is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Feb 2015
    \r\n \r\n \r\n
    Posts
    35
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by vidm\r\n View Post\r\n
    \r\n
    Account usually matches your bank account.
    \nPortoflio - group of accounts that you group any way you want. For example you might use 2 values in portfolio - one your name and another your spouse name. Portfolio can be used to apply filter to report, for example you want to see just accounts that belong to you and not to your spouse.
    \r\n \r\n
    \r\n
    \r\n
    Thanks very much. I spent some time last night to go through the steps. Got most working but today I can\'t seem to refresh/update as I always get user name/password error when I try to refresh data in power pivot table. Not sure why as it seems to work yesterday. Also got warning about 32 bit version of Excel 2010 which is the one I\'m using.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[645778] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #11\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by GGO\r\n View Post\r\n
    \r\n
    Thanks very much. I spent some time last night to go through the steps. Got most working but today I can\'t seem to refresh/update as I always get user name/password error when I try to refresh data in power pivot table. Not sure why as it seems to work yesterday. Also got warning about 32 bit version of Excel 2010 which is the one I\'m using.
    \r\n \r\n
    \r\n
    \r\n
    Regarding username /password error.
    \nAs on the same PC you were able update yesterday, I have to assume that your PC is setup correctly and you have SQL Server Native Client installed.
    \nSecond most common reason for this error - when you are running some firewall on your PC, strange thing is that in such case I have to assume you had firewall yesterday and it worked.
    \nI had users reported same issue, and then reported back that they had this issue when they run VPN on their PC. Maybe that is your case?
    \n
    \nIf you still experience this issue, please let me know, I\'ll post what you should do next.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[646754] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #12\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n GGO\r\n \r\n
    \r\n GGO is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Feb 2015
    \r\n \r\n \r\n
    Posts
    35
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by vidm\r\n View Post\r\n
    \r\n
    Regarding username /password error.
    \nAs on the same PC you were able update yesterday, I have to assume that your PC is setup correctly and you have SQL Server Native Client installed.
    \nSecond most common reason for this error - when you are running some firewall on your PC, strange thing is that in such case I have to assume you had firewall yesterday and it worked.
    \nI had users reported same issue, and then reported back that they had this issue when they run VPN on their PC. Maybe that is your case?
    \n
    \nIf you still experience this issue, please let me know, I\'ll post what you should do next.
    \r\n \r\n
    \r\n
    \r\n
    You are right it is due to firewall. Now it is working fine.
    \n
    \nI do have another question: in my case I started investment mainly this year, so I plan to track from begining of this year. I do have some stocks/mutual funds prior to this year. Is there a way to just take a snapshot of those previous investment, and only track buy and sell starting this year ? e.g., if I use transaction Deposit, can I deposit a stock instead of cash ? Wonder what\'s the best way to handle that. Thanks again.
    \n
    \nI figured it out. Used Buy+Deposit. Still playing. Looks like an awesome tool.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n \r\n Last edited by GGO; 2015-04-10 at 09:42 PM.\r\n \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[646786] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #13\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n GGO\r\n \r\n
    \r\n GGO is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Feb 2015
    \r\n \r\n \r\n
    Posts
    35
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n Still have questions. Sorry.
    \n
    \nFor RBC RRSP account, we have both US and CAD account to buy US and canadian stocks. Do I need to set up 2 accounts in PS to track them, or shall I handle them in one account with CAD currency ? probably two accounts so easier to track currency ? If two accounts how do I handle Norbert\'s Gambit transaction between the two accounts ? 2nd example in the FAQ below seems to explain this ?
    \n
    \nhttp://portfolioslicer.com/Support/FAQ#norbert\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[647010] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #14\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n GGO\r\n \r\n
    \r\n GGO is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Feb 2015
    \r\n \r\n \r\n
    Posts
    35
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n Still have not figured out how to put some existing stocks into my account without going through cash deposit and buy process. I tried to deposit same amount of cash as the stock market value on Dec 31 2014 and put another buy transaction on same day. Somehow it just does not show up in the holdings tab. not sure what I did wrong. Would appreciate some help from vidm. Thanks\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[647066] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #15\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by GGO\r\n View Post\r\n
    \r\n
    You are right it is due to firewall. Now it is working fine.
    \n
    \nI do have another question: in my case I started investment mainly this year, so I plan to track from begining of this year. I do have some stocks/mutual funds prior to this year. Is there a way to just take a snapshot of those previous investment, and only track buy and sell starting this year ? e.g., if I use transaction Deposit, can I deposit a stock instead of cash ? Wonder what\'s the best way to handle that. Thanks again.
    \n
    \nI figured it out. Used Buy+Deposit. Still playing. Looks like an awesome tool.
    \r\n \r\n
    \r\n
    \r\n
    Actually for initial setup recommendation is:
    \n- Make sure your web workbook minimum date is setup to 2014-12-30.
    \n- Make deposit transaction into account that is in amount of total book value. Use date 2014-12-30 for that deposit transaction
    \n- Make buy transaction with date 2014-12-31 with original price. Data for 2014 will show big cap gain/loss, but you are going to look just into 2015 data.
    \n
    \nQ:For RBC RRSP account, we have both US and CAD account to buy US and canadian stocks. Do I need to set up 2 accounts in PS to track them, or shall I handle them in one account with CAD currency ? probably two accounts so easier to track currency ? If two accounts how do I handle Norbert\'s Gambit transaction between the two accounts ? 2nd example in the FAQ below seems to explain this ?
    \n
    \nA: I make one account in PS per each account in your bank institution. It is very important what is PS account currency - all transactions in that account are assumed to be made in the PS account currency! So if you have 2 accounts, you want to create 2 accounts in PS with correct currency. Yes, for Norbert Gambit I have FAQ that explains how to do this.
    \n
    \nQ: Still have not figured out how to put some existing stocks into my account without going through cash deposit and buy process. I tried to deposit same amount of cash as the stock market value on Dec 31 2014 and put another buy transaction on same day. Somehow it just does not show up in the holdings tab. not sure what I did wrong.
    \n
    \nA: At this point you have to first deposit money into account and then enter buy transactions. I explained above how to deposit one day before buy transactions. I suspect that you might have issues because your minimum workbook date is 2015-01-01 and not 2014-12-30. If you do not know amount you need to deposit first, then deposit 1mln $, do all your buy and then check "Cash Balance", lets say after last buy transaction it shows 912,456$. Then you do simple math: 1,000,000-912,456=87,544 and then you simply replace original 1mln deposit value with 87544$ and that means your last cash balance now will be 0$.
    \n
    \nI realize that PS does not have enough documentation, I am adding more comments and samples to new release I am working on. My highest priority is to make necessary reports and then I\'ll work on more documentation.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[647266] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #16\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n GGO\r\n \r\n
    \r\n GGO is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Feb 2015
    \r\n \r\n \r\n
    Posts
    35
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n Thanks so much, Vidm. I kind of figured out this similar to your suggestions. Basically I deposite some cash end of 2014 and then enter some buy transaction Jan 1 2015 for previous holdings. It now works great.
    \n
    \nYes I also created separate account for RRSP as one holds CAD stocks and the other US stocks in two currencies.
    \n
    \nI have to say that this is an awesome tool and will help me a great deal in tracking my investment. I was doing some of these in Excel myself but it\'s no where close to what I can get with PS tool. Thanks for creating and sharing this !\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[647721] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #17\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n GGO\r\n \r\n
    \r\n GGO is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Feb 2015
    \r\n \r\n \r\n
    Posts
    35
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n Hi Vidm: spent hours to try to get the above to work, i.e., deposit cash and enter buy transaction using same amount of cash so that I can record previous stocks bought. Unfortunately doing that somehow screw up the cash holding calculation. In the srcTran tab the Totalcashbalance is correct, but in the holding tab it gave me less cash and not sure why. If I removed these deposit and buy transactions I get correct cash holdings. If i deposit arbiturary amount of cash to make cash holding correct, then the srcTran tab will show incorrect number ? I hope there is an easy way around this problem as I think this might happen quite often. Thanks,
    \n
    \nSeems found the issue. The reduction of cash is because cash deposit for previous stocks is done in 2014 Dec 30. If I change deposit date to Jan 1 2015 I get correct number now.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n \r\n Last edited by GGO; 2015-04-11 at 09:28 PM.\r\n \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[647761] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #18\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n mf4361\r\n \r\n
    \r\n mf4361 is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Apr 2015
    \r\n \r\n \r\n
    Posts
    133
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n I spent hours trying to get it working. I can\'t get the right amount of total amount shown on dashboard. I\'ve copy and pasted transactions from my brokerage account and the quote it grabbed from cloud is correct. So I don\'t know where it went wrong yet
    \r\n
    \r\nAlso I have an error every time I "refresh all" in Data tab. "A PowerTable Report cannot overlap another PivotTable report."
    \r\n
    \r\nThis error shows up even before I touch anything after downloading it
    \r\n
    \r\nAny idea? Thanks.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[648113] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #19\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by GGO\r\n View Post\r\n
    \r\n
    Hi Vidm: spent hours to try to get the above to work, i.e., deposit cash and enter buy transaction using same amount of cash so that I can record previous stocks bought. Unfortunately doing that somehow screw up the cash holding calculation. In the srcTran tab the Totalcashbalance is correct, but in the holding tab it gave me less cash and not sure why. If I removed these deposit and buy transactions I get correct cash holdings. If i deposit arbiturary amount of cash to make cash holding correct, then the srcTran tab will show incorrect number ? I hope there is an easy way around this problem as I think this might happen quite often. Thanks,
    \n
    \nSeems found the issue. The reduction of cash is because cash deposit for previous stocks is done in 2014 Dec 30. If I change deposit date to Jan 1 2015 I get correct number now.
    \r\n \r\n
    \r\n
    \r\n
    Please check your minimum workbook date you setup through website. It is very important date - if you enter any transactions before that date, these transactions might get ignored.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[648313] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #20\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n GGO\r\n \r\n
    \r\n GGO is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Feb 2015
    \r\n \r\n \r\n
    Posts
    35
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by vidm\r\n View Post\r\n
    \r\n
    Please check your minimum workbook date you setup through website. It is very important date - if you enter any transactions before that date, these transactions might get ignored.
    \r\n \r\n
    \r\n
    \r\n
    Thanks Vidm. Slowly learned my way. Seems everything ok now, and holdings in my bank is matching PS result. This is a great tool to track investment.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[645810] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #21\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n larry81\r\n \r\n
    \r\n larry81 is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Nov 2010
    \r\n
    Location
    GTA
    \r\n \r\n
    Posts
    1,486
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n vidm it would be nice if the CAD-USD exchange rate could be updated during the day. As someone who happens to look at his portfolio in the AM and PM, it would be nice for the exchange rate to update automatically as the rate change. At the end of the day you could simply refresh with the end-of-the-day value.
    \n
    \nportfolioslicer is the best thing since sliced bread ! It replaced my quicken entirely.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[646634] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #22\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by larry81\r\n View Post\r\n
    \r\n
    vidm it would be nice if the CAD-USD exchange rate could be updated during the day. As someone who happens to look at his portfolio in the AM and PM, it would be nice for the exchange rate to update automatically as the rate change. At the end of the day you could simply refresh with the end-of-the-day value.
    \n
    \nportfolioslicer is the best thing since sliced bread ! It replaced my quicken entirely.
    \r\n \r\n
    \r\n
    \r\n
    Larry81 - Thanks! I added your suggestion about exchange rate more frequent updates. But I cannot promise anything in the near future, sorry...\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[696569] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #23\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by larry81\r\n View Post\r\n
    \r\n
    vidm it would be nice if the CAD-USD exchange rate could be updated during the day. As someone who happens to look at his portfolio in the AM and PM, it would be nice for the exchange rate to update automatically as the rate change. At the end of the day you could simply refresh with the end-of-the-day value.
    \r\n
    \r\nportfolioslicer is the best thing since sliced bread ! It replaced my quicken entirely.
    \r\n \r\n
    \r\n
    \r\n
    Larry81 - this is now done and major currency exchange rates are updated few times per day. Thanks for this great suggestion!\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[766554] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #24\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n larry81\r\n \r\n
    \r\n larry81 is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Nov 2010
    \r\n
    Location
    GTA
    \r\n \r\n
    Posts
    1,486
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n I just want to say how happy i am tracking my portfolio with portfolioslicer spreadsheets \r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[767754] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #25\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by larry81\r\n View Post\r\n
    \r\n
    I just want to say how happy i am tracking my portfolio with portfolioslicer spreadsheets
    \r\n \r\n
    \r\n
    \r\n
    Just a warning - if you are using Excel 2010 please wait with update to Windows 10. At this point you cannot use Excel 2010 with PowerPivot on Windows 10 as there are known issues (PowerPivot will crash) - hopefully Microsoft will provide a fix soon. Because of that you cannot use Portfolio Slicer with Excel 2010 on Windows 10.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[767858] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #26\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n larry81\r\n \r\n
    \r\n larry81 is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Nov 2010
    \r\n
    Location
    GTA
    \r\n \r\n
    Posts
    1,486
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by vidm\r\n View Post\r\n
    \r\n
    Just a warning - if you are using Excel 2010 please wait with update to Windows 10. At this point you cannot use Excel 2010 with PowerPivot on Windows 10 as there are known issues (PowerPivot will crash) - hopefully Microsoft will provide a fix soon. Because of that you cannot use Portfolio Slicer with Excel 2010 on Windows 10.
    \r\n \r\n
    \r\n
    \r\n
    Happy Win7 and Office2013 user here
    \n
    \nThe only recent bug i observed is that the USD/CAD range for 2015-07-31 is not present, it just straight from 2015-07-30 to 2015-08-03.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[767874] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #27\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n There is an issue with July 31st exchange rate data - I believe this will be fixed tomorrow.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[1075641] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #28\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n GreatLaker\r\n \r\n
    \r\n GreatLaker is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n GreatLaker\'s Avatar\r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2014
    \r\n
    Location
    Toronto, Ontario
    \r\n \r\n
    Posts
    595
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n

    \r\n New verion of PortfolioSlicer\r\n

    \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n I just noticed a new version of PortfolioSlicer! I don\'t have time to ugrade now, but posting in case anyone wants to have a look at it.
    \r\n
    \r\nhttp://www.portfolioslicer.com/news.html
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n 2016-03-18 Portfolio Slicer version 2.0.0 Released
    \r\n
    \r\nThis release removes Portfolio Slicer dependency on cloud data. From this point Portfolio Slicer becomes Excel workbook that uses data from within workbook and also some data from external files from your PC. Portfolio Slicer does not provide data for these external data files. These files can be created by multiple data services (if you have subscription) or there are already free scripts published by Portfolio Slicer users that will get data from websites in the format that is required by Portfolio Slicer.
    \r\n
    \r\nThis release also includes few minor fixes in data model calculations.\r\n \r\n
    \r\n
    \r\n

    \r\nhttp://www.portfolioslicer.com/mydata.html
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n Older version of Portfolio Slicer required data about your investments to be entered into web workbook. From this page you can still access old website of Portfolio Slicer where you can still work with your old version of web workbook.
    \r\n
    \r\nTo access your old version of web workbook please visit here.
    \r\n
    \r\nPlease note that old version of Portfolio Slicer will be supported until June 30th, 2016. After that any access to web workbook or any other online/cloud data will be removed. Please migrate to new version of Portfolio Slicer before this deadline.\r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[1076066] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #29\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n Just a clarification - there are already scripts released by other Portfolio Slicer users that will get all data you need to run Portfolio Slicer.
    \nUpgrade process from older version should be fairly simple - you will find most of the data and even configuration file provided to you in extract. There is video available on how to migrate: http://www.portfolioslicer.com/docs/upgrade.html
    \nI had many requests to remove PS dependency on cloud data. I guess people were afraid that after they will put effort in setting up Portfolio Slicer, they might get hit with monthly/yearly fees. Now you just get workbook and scripts and use it any way you like - no limitations.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[1081802] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #30\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n GreatLaker\r\n \r\n
    \r\n GreatLaker is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n GreatLaker\'s Avatar\r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2014
    \r\n
    Location
    Toronto, Ontario
    \r\n \r\n
    Posts
    595
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n Hi Vdim,
    \r\nYou previously noted a problem using PortfolioSlicer with Excel 2010 and Windows 10:
    \r\nhttp://canadianmoneyforum.com/showth...l=1#post767754
    \r\n
    \r\nIs that still a problem with PortfolioSlicer version 2? I am currently using Windows 7 with Excel 2010 (32 bit), but want to upgrade to Win10..
    \r\n
    \r\nThank you.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[1082002] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #31\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n larry81\r\n \r\n
    \r\n larry81 is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Nov 2010
    \r\n
    Location
    GTA
    \r\n \r\n
    Posts
    1,486
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n Hi vidm, great news regarding version 2.0 !
    \n
    \nQuick question for you, i used to own a few mutual fund a year back. Since they were sold many years ago and that i dont hold them anymore. Do i need to add them as source in the new v2.00 ?
    \n
    \nedit: i am having trouble following the ~20 steps migration path, receiving error:
    \n
    \nWe couldn\'t get data from the Data Model. Here\'s the error message we got:
    \n
    \nThe AttributeRelationship with AttributeID =- Symbol doesnt exist in the collection\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n \r\n Last edited by larry81; 2016-03-25 at 04:58 PM.\r\n \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n \r\n
    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[1082402] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #32\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by larry81\r\n View Post\r\n
    \r\n
    Hi vidm, great news regarding version 2.0 !
    \n
    \nQuick question for you, i used to own a few mutual fund a year back. Since they were sold many years ago and that i dont hold them anymore. Do i need to add them as source in the new v2.00 ?
    \n
    \nedit: i am having trouble following the ~20 steps migration path, receiving error:
    \n
    \nWe couldn\'t get data from the Data Model. Here\'s the error message we got:
    \n
    \nThe AttributeRelationship with AttributeID =- Symbol doesnt exist in the collection
    \r\n \r\n
    \r\n
    \r\n
    Old mutual funds - you do not need to add them into configuration file, but you should list them in symbol table and for proper history you need to have quotes for them. These mutual funds quotes file should be in "Quotes" folder in any subfolder, for example I created myself "Manual" subfolder were I add quotes for these symbols that are not traded anymore.
    \n
    \nFor problem you have:
    \n1. Make sure that Trans table has no "Red" cells, specifically check Symbol name - it sounds to me that you have some missing symbols, but I am not 100%.
    \n2. Leave just 2-3 transactions in Trans table, delete all other records and try to refresh\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[1086082] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #33\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n larry81\r\n \r\n
    \r\n larry81 is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Nov 2010
    \r\n
    Location
    GTA
    \r\n \r\n
    Posts
    1,486
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by vidm\r\n View Post\r\n
    \r\n
    Old mutual funds - you do not need to add them into configuration file, but you should list them in symbol table and for proper history you need to have quotes for them. These mutual funds quotes file should be in "Quotes" folder in any subfolder, for example I created myself "Manual" subfolder were I add quotes for these symbols that are not traded anymore.
    \n
    \nFor problem you have:
    \n1. Make sure that Trans table has no "Red" cells, specifically check Symbol name - it sounds to me that you have some missing symbols, but I am not 100%.
    \n2. Leave just 2-3 transactions in Trans table, delete all other records and try to refresh
    \r\n \r\n
    \r\n
    \r\n
    I just re-verified, there no red anywhere.
    \nI also deleted all transaction except 2-3
    \n
    \nsame error \r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[1086338] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #34\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by larry81\r\n View Post\r\n
    \r\n
    I just re-verified, there no red anywhere.
    \r\nI also deleted all transaction except 2-3
    \r\n
    \r\nsame error
    \r\n \r\n
    \r\n
    \r\n
    Based on other people experience reported so far, most likely reason for failure:
    \r\n
    \r\n1. Make sure that first record in table Symbol with "* Cash" was not replaced/deleted.
    \r\n
    \r\nIf that is not the case, then other things to check - please very carefully review table Symbol and SymbolSector:
    \r\n
    \r\n2. Symbol[Currency] (table Symbol, column Currency) should have values in report currency list or "Cash".
    \r\n3. Symbol[MER] values should be decimal number and not character. Make column wider and confirm that all values align left.
    \r\n4. Symbol[WHTPercent] - put all values (except first row) as 0.
    \r\n5. SymbolSector[Percent] - make sure all values are numbers.
    \r\n
    \r\nLet me know if you still have any issues.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[1115514] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #35\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n larry81\r\n \r\n
    \r\n larry81 is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Nov 2010
    \r\n
    Location
    GTA
    \r\n \r\n
    Posts
    1,486
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n PVI folks, new version of portfolioslicer (v2.1) and a brand new version with PowerBI support !
    \n
    \nhttp://portfolioslicer.com/download.html
    \n
    \nBig thumbs up for our very own vidm !\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    My portfolio: VCN, VUN, VIU, VEE, HBB, ZRE
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[1116250] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #36\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n newuser\r\n \r\n
    \r\n newuser is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Sep 2014
    \r\n \r\n \r\n
    Posts
    80
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by larry81\r\n View Post\r\n
    \r\n
    PVI folks, new version of portfolioslicer (v2.1) and a brand new version with PowerBI support !
    \n
    \nhttp://portfolioslicer.com/download.html
    \n
    \nBig thumbs up for our very own vidm !
    \r\n \r\n
    \r\n
    \r\n
    That PowerBI stuff looks awesome! Can\'t wait to try this out!\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[1082394] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #37\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by GreatLaker\r\n View Post\r\n
    \r\n
    Hi Vdim,
    \r\nYou previously noted a problem using PortfolioSlicer with Excel 2010 and Windows 10:
    \r\nhttp://canadianmoneyforum.com/showth...l=1#post767754
    \r\n
    \r\nIs that still a problem with PortfolioSlicer version 2? I am currently using Windows 7 with Excel 2010 (32 bit), but want to upgrade to Win10..
    \r\n
    \r\nThank you.
    \r\n \r\n
    \r\n
    \r\n
    Windows 10 is not a problem - I am using WIndows 10 with Excel 2010.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[645442] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #38\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by m3s\r\n View Post\r\n
    \r\n
    I\'m still using it regularly and it\'s pretty much everything I wanted Quicken to be.
    \nOn the dashboard, one of my "top YTD winners" seems to be wrong, possibly counting gains from the book value or something (I repurchased it this year, shows as a YTD winner +24% but it\'s actually down slightly this year)
    \nWhen I reconciled the balances I also found that I had input some bank fees backwards (negative) Not sure if you could have a warning for that somehow but it\'s not a big deal
    \nI like the buttons for CAD/USD/original and the exchange rate impact etc. All the tabs are great insight as well and easy to use.
    \r\n \r\n
    \r\n
    \r\n
    Hi m3s, I believe that issue with top YTD winners will be fixed in the next release - I changed how Profit % is calculated and that affects YTD winner. I also added option not to track cash, so you will not need to do deposits before buying stocks - and that should simplify PS usage substantially.
    \n
    \nRegards,\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[649553] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #39\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n m3s\r\n \r\n
    \r\n m3s is offline\r\n\r\n \r\n
    \r\n \r\n Senior Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n m3s\'s Avatar\r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Apr 2010
    \r\n
    Location
    Everywhere
    \r\n \r\n
    Posts
    3,080
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by vidm\r\n View Post\r\n
    \r\n
    Hi m3s, I believe that issue with top YTD winners will be fixed in the next release - I changed how Profit % is calculated and that affects YTD winner.
    \r\n \r\n
    \r\n
    \r\n
    Is there a way for me to see the formulas? I used to be an excel wiz years ago.. but never used these pivot tables. Some of the cap gains in the yearly tab are way off, but the same holdings seem correct in the holdings tab etc
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by vidm\r\n View Post\r\n
    \r\n
    I also added option not to track cash, so you will not need to do deposits before buying stocks - and that should simplify PS usage substantially.
    \r\n \r\n
    \r\n
    \r\n
    No kidding! I just reconciled 5 years worth of transactions across several accounts to within pennies. I guess without cash you just wouldn\'t get a cash allocation or accurate stats on fees.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    amat victoria curam
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[649585] = '\r\n
  • \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n #40\r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n vidm\r\n \r\n
    \r\n vidm is offline\r\n\r\n \r\n
    \r\n \r\n Member\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    Join Date
    Mar 2012
    \r\n \r\n \r\n
    Posts
    85
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n \r\n \r\n\r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n
    \r\n Quote Originally Posted by m3s\r\n View Post\r\n
    \r\n
    Is there a way for me to see the formulas? I used to be an excel wiz years ago.. but never used these pivot tables. Some of the cap gains in the yearly tab are way off, but the same holdings seem correct in the holdings tab etc
    \n
    \nNo kidding! I just reconciled 5 years worth of transactions across several accounts to within pennies. I guess without cash you just wouldn\'t get a cash allocation or accurate stats on fees.
    \r\n \r\n
    \r\n
    \r\n

    \nCash or no cash tracking will be an option that you can choose. I am tracking cash myself, because there are times when I have some money in cash and I want to be included that in my reports. But tracking cash makes PS usage a bit harder - users have to deposit money before buying and that make system a bit more complex. So having an option to start PS without tracking cash, getting to know system and then turning cash tracking later might be good option for many users.
    \n
    \nAlmost all formulas used in PS calculations are open and available for you to see and change
    . I have few users that adjusted system to their likings and contributed me with some formula suggestions
    \n
    \nIn Excel 2010 click on "PowerPivot Window", then some calculations are defined in calculated column (visible in excel formula bar when you select any cell in that column) and others are defined as calculated measures (Visible at the bottom part of the screen for each table). You can also see calculated measures by selecting measure from "PowerPivot field list" on the right (measure will have calculator icon on the right side) and then choosing "Edit Formula".
    \n
    \nIn Excel 2013 these are similar steps in PowerPivot window and from Excel interface you need to select PowerPivot menu and choose "Calculated Fields" button to edit measures. You can see/change formulas just when you have Excel 2013 Professional Plus Edition.
    \n
    \nIf you find any issue with Capital Gains calculations, please let me know so I can include fix into next release. You can also delete data and leave just one symbol transactions and send me workbook and I can review calculations to figure out issue.\r\n
    \r\n
    \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
    \r\n
    \r\n \r\n
    \r\n \r\n \r\n \r\n \r\n
    Free investment tracking in Excel: Hidden Content
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n -' + '->\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n -' + '->\r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; // next/previous post info pn[277410] = "690849,277522"; pn[0] = ",277410"; pn[277522] = "277410,277546"; pn[277546] = "277522,277881"; pn[277881] = "277546,278113"; pn[278113] = "277881,278273"; pn[278273] = "278113,279689"; pn[279689] = "278273,280025"; pn[280025] = "279689,281345"; pn[281345] = "280025,281369"; pn[281369] = "281345,281385"; pn[281385] = "281369,281425"; pn[281425] = "281385,281489"; pn[281489] = "281425,281706"; pn[281706] = "281489,282018"; pn[282018] = "281706,282250"; pn[282250] = "282018,330409"; pn[330409] = "282250,330537"; pn[330537] = "330409,333977"; pn[333977] = "330537,334105"; pn[334105] = "333977,334473"; pn[334473] = "334105,334945"; pn[334945] = "334473,335057"; pn[335057] = "334945,335441"; pn[335441] = "335057,335569"; pn[335569] = "335441,335761"; pn[335761] = "335569,335825"; pn[335825] = "335761,335841"; pn[335841] = "335825,335881"; pn[335881] = "335841,335905"; pn[335905] = "335881,342857"; pn[342857] = "335905,349353"; pn[349353] = "342857,350361"; pn[350361] = "349353,351033"; pn[351033] = "350361,351649"; pn[351649] = "351033,351705"; pn[351705] = "351649,351721"; pn[351721] = "351705,353009"; pn[353009] = "351721,356265"; pn[356265] = "353009,356481"; pn[356481] = "356265,356505"; pn[356505] = "356481,356521"; pn[356521] = "356505,378649"; pn[378649] = "356521,378969"; pn[378969] = "378649,427529"; pn[427529] = "378969,428977"; pn[428977] = "427529,429033"; pn[429033] = "428977,430985"; pn[430985] = "429033,463410"; pn[463410] = "430985,463554"; pn[463554] = "463410,464170"; pn[464170] = "463554,464546"; pn[464546] = "464170,499369"; pn[499369] = "464546,500161"; pn[500161] = "499369,543866"; pn[543866] = "500161,544202"; pn[544202] = "543866,544370"; pn[544370] = "544202,544458"; pn[544458] = "544370,545146"; pn[545146] = "544458,545138"; pn[545138] = "545146,545154"; pn[545154] = "545138,545162"; pn[545162] = "545154,632514"; pn[632514] = "545162,632850"; pn[632850] = "632514,633338"; pn[633338] = "632850,638698"; pn[638698] = "633338,640689"; pn[640689] = "638698,642338"; pn[642338] = "640689,642394"; pn[642394] = "642338,644082"; pn[644082] = "642394,644322"; pn[644322] = "644082,645482"; pn[645482] = "644322,645778"; pn[645778] = "645482,646754"; pn[646754] = "645778,646786"; pn[646786] = "646754,647010"; pn[647010] = "646786,647066"; pn[647066] = "647010,647266"; pn[647266] = "647066,647721"; pn[647721] = "647266,647761"; pn[647761] = "647721,648105"; pn[648105] = "647761,648113"; pn[648113] = "648105,648313"; pn[648313] = "648113,645810"; pn[645810] = "648313,646634"; pn[646634] = "645810,696569"; pn[696569] = "646634,766554"; pn[766554] = "696569,767754"; pn[767754] = "766554,767858"; pn[767858] = "767754,767874"; pn[767874] = "767858,1075641"; pn[1075641] = "767874,1076066"; pn[1076066] = "1075641,1081802"; pn[1081802] = "1076066,1082002"; pn[1082002] = "1081802,1082402"; pn[1082402] = "1082002,1086082"; pn[1086082] = "1082402,1086338"; pn[1086338] = "1086082,1115514"; pn[1115514] = "1086338,1116250"; pn[1116250] = "1115514,1082394"; pn[1082394] = "1116250,645442"; pn[645442] = "1082394,649553"; pn[649553] = "645442,649585"; pn[649585] = "649553,649729"; pn[649729] = "649585,649737"; pn[649737] = "649729,651137"; pn[651137] = "649737,651193"; pn[651193] = "651137,656386"; pn[656386] = "651193,656410"; pn[656410] = "656386,657658"; pn[657658] = "656410,658378"; pn[658378] = "657658,658434"; pn[658434] = "658378,658898"; pn[658898] = "658434,660002"; pn[660002] = "658898,660737"; pn[660737] = "660002,676498"; pn[676498] = "660737,659970"; pn[659970] = "676498,660833"; pn[660833] = "659970,670193"; pn[670193] = "660833,670681"; pn[670681] = "670193,673386"; pn[673386] = "670681,676282"; pn[676282] = "673386,677946"; pn[677946] = "676282,678018"; pn[678018] = "677946,678394"; pn[678394] = "678018,657474"; pn[657474] = "678394,695401"; pn[695401] = "657474,695441"; pn[695441] = "695401,696553"; pn[696553] = "695441,696537"; pn[696537] = "696553,356529"; pn[356529] = "696537,356577"; pn[356577] = "356529,356593"; pn[356593] = "356577,281906"; pn[281906] = "356593,282242"; pn[282242] = "281906,427953"; pn[427953] = "282242,428737"; pn[428737] = "427953,687346"; pn[687346] = "428737,688610"; pn[688610] = "687346,689081"; pn[689081] = "688610,689121"; pn[689121] = "689081,689625"; pn[689625] = "689121,690777"; pn[690777] = "689625,690793"; pn[690793] = "690777,690817"; pn[690817] = "690793,690841"; pn[690841] = "690817,690849"; pn[690849] = "690841,277410"; // cached usernames pu[0] = guestphrase; pu[21947] = "larry81"; pu[34969] = "Kaitlyn"; pu[45208] = "vidm"; pu[3507] = "fatcat"; pu[32650] = "webber22"; pu[5510] = "m3s"; pu[107864] = "apatel"; pu[299929] = "chinamank"; pu[302354] = "GGO"; pu[305466] = "mf4361"; pu[282301] = "GreatLaker"; pu[305834] = "StockTrader"; pu[305858] = "zaphod"; pu[293073] = "buddyb"; pu[294961] = "newuser"; // -->

    Threaded View

    1. #11
      Member
      Join Date
      Mar 2012
      Posts
      85
      Quote Originally Posted by GGO View Post
      Thanks very much. I spent some time last night to go through the steps. Got most working but today I can't seem to refresh/update as I always get user name/password error when I try to refresh data in power pivot table. Not sure why as it seems to work yesterday. Also got warning about 32 bit version of Excel 2010 which is the one I'm using.
      Regarding username /password error.
      As on the same PC you were able update yesterday, I have to assume that your PC is setup correctly and you have SQL Server Native Client installed.
      Second most common reason for this error - when you are running some firewall on your PC, strange thing is that in such case I have to assume you had firewall yesterday and it worked.
      I had users reported same issue, and then reported back that they had this issue when they run VPN on their PC. Maybe that is your case?

      If you still experience this issue, please let me know, I'll post what you should do next.
      Free investment tracking in Excel: Hidden Content

    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
    •