Portfolioslicer (Automated Excel portfolio tracker)

Thread: Portfolioslicer (Automated Excel portfolio tracker)

\r\n
\r\n \r\n \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 i performed a norbert gambit transaction yesterday and i am not sure how to enter it properly:
\n
\nin my TDDI:
\n2014-12-03, TD.to, BUY, 614, 56,92\$, -9,99\$, -34 958,87\$
\n2014-12-03, TD, SELL, -614, 50,062\$, -9,99\$, 30 727,89\$
\n
\nin my portfolioslicer:
\nCAD 2014-12-03 SymbolTransferOut TD.TO 614.00 56.94 34958.87
\n???
\n???
\n
\nI did look at the FAQ, it say to use the following formula for transaction #3
\nTransPrice=TransTotalAmnt(PrevTransaction)*BankExc hRate/TransQty and
\nTBookValueOverride=TotalTransAmnt(PrevTransaction) *BankExchRate.
\n
\nWhat kind of operation is TransTotalAmnt(PrevTransaction) ??? Could you provide a working example based on my transaction ?
\n
\nAlso, in my detailled TDDI transaction slip, i see that i was charged 0.68\$ of US taxes for the SELL operation, how do i handle this in portfolioslicer, do i simply adjust the TD stock price of the SELL operation ?
\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
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n 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[463554] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \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 Larry81,
\n
\nNow my assumption is that you bought in account CAD and then transferred it into account USD
\n
\nAccount Date Trans Symbol Qty Price Fee BookValue Override Amount
\nAccntCAD 12/3/2014 SymbolTransferOut TD.TO 614 56.93627036 34958.87
\nAccntUSD 12/3/2014 SymbolTransferIn TD 614 50.0628 30738.5592 30738.5592
\nAccntUSD 12/3/2014 Sell TD 614 50.0628 10.67 30738.5592 30727.8892
\n
\nI added 0.68 to sell fee, so instead of 9.99 it became 10.67.
\nFor symbol transfer into price I included fee, so total transfer amount matches amount that was paid.
\nYou specify sell price for 50.062, but really I had to calculate it more precise to get sales amount 30727.89 after all expenses. So my calcs shows that price was supposed to be 50.0628 (just simple excel magic)
\nBookValueOverride was amount you got before subtracting fees you paid.
\n
\nImage: gamb20141204.PNG\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[464170] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n sound good but where do you use the BankExchRate in 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 \r\n \r\n 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[464546] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by larry81\r\n \r\n
\r\n
sound good but where do you use the BankExchRate in this ?
\r\n \r\n
\r\n
\r\n
BankExchRate plays bigger role in case when you are doing this transaction in single account - first example in FAQ.
\nAs you bough in CAD account and then transferred symbol into USD account and sold right away, your bank provided with actual price for sale.
\n
\nThe goal of these transactions really is:
\n- For CAD account your buy and Transfer out "TotalAmount" should be exactly the same. So there is really no capital gain for this transaction.
\n- For USD account your Transfer In value for "TotalAmount" will be in USD currency and it should be equal to CAD account book value converted to USD currency using that days exchange rate. If you are selling this symbol same day, you can then use sales price (adjusted for transaction 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
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n 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[499369] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n Regarding distribution, should i enter the Ex-dividend date, the Record date or Payment date in Portfolio slicer ?
\n
\nFor example, VCE latest distribution
\n
\nEx-dividend date Record date Payment date Cash distribution per unit Reinvested distribution per unit Total distribution per unit
\n24-12-2014 30-12-2014 05-01-2015 \$0.18935 \$0.00000 \$0.18935\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[500161] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n 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.
\nYou 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.\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[543866] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n

\r\n Will it work with Excel 2007??\r\n

\r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n Hi Vidm,
\r\n
\r\nWill portfolio slicer work with Microsoft Office Enterprise Excel 2007.
\r\n
\r\nI wanted to know before I register and set up my portfolio
\r\n
\r\n
\r\napatel\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[544202] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by apatel\r\n \r\n
\r\n
Hi Vidm,
\n
\nWill portfolio slicer work with Microsoft Office Enterprise Excel 2007.
\n
\nI wanted to know before I register and set up my portfolio
\n
\n
\napatel
\r\n \r\n
\r\n
\r\n
Hi Apatel,
\n
\nNo, 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.\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[544370] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n Whats in for the next update vidm ?
\n
\nAny big plan for a 1.0 release ?\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[544458] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \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, regarding RESP tracking in portfolioslicer, what TransType/TransSubType would you use for government grant ?\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[545146] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by larry81\r\n \r\n
\r\n
vidm, regarding RESP tracking in portfolioslicer, what TransType/TransSubType would you use for government grant ?
\r\n \r\n
\r\n
\r\n
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.
\nIn 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.\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[545138] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by larry81\r\n \r\n
\r\n
Whats in for the next update vidm ?
\n
\nAny big plan for a 1.0 release ?
\r\n \r\n
\r\n
\r\n
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 .\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[545154] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by vidm\r\n \r\n
\r\n
Hi Apatel,
\r\n
\r\nNo, 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.
\r\n \r\n
\r\n
\r\n
Thanks vidm, I am planning to buy a new laptop. I will then be able to use this
\r\n
\r\napatel\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[545162] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n Portfolioslicer is DIY investor best friend !
\n
\nI look at my dashboard daily \r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[632514] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \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
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n 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
\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
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n 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
\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
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n 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
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by larry81\r\n \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.
\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
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n 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
\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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by chinamank\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
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
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n 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
\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
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n 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[356529] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by vidm\r\n \r\n
\r\n
1. I am surprised that in Holdings % you see previous holdings. Somehow for you default filter was removed. To add filter back: on the same worksheets move cursor to cell BA:14. This is symbol values pivot table used for that chart. You need to add filter to this pivot table - click on arrow near "Row Labels" then "Value Filters" then "Greater than...". Then Choose condition "Total Value" "is greater than" 0.
\r\n \r\n
\r\n
\r\n
Not sure i understand your directive, when you say "worksheets" you mean the "Dashboard" ? Also not sure what is cell BA:14, for me columns are denominated A,B,C,etc. there is no BA.
\n
\nalways amazed by your support vidm
\n
\nedit: another symbol to modify when you have the chance, HBB.TO
\n
\ncurrent: HORIZONS CDN SELECT UNIVERSE BO
\n
\nshould be: Horizons CDN Select Universe Bond ETF\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[356577] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by larry81\r\n \r\n
\r\n
Not sure i understand your directive, when you say "worksheets" you mean the "Dashboard" ? Also not sure what is cell BA:14, for me columns are denominated A,B,C,etc. there is no BA.
\n
\nalways amazed by your support vidm
\n
\nedit: another symbol to modify when you have the chance, HBB.TO
\n
\ncurrent: HORIZONS CDN SELECT UNIVERSE BO
\n
\nshould be: Horizons CDN Select Universe Bond ETF
\r\n \r\n
\r\n
\r\n
Yes, it is "Dashboard" worksheet. If you start moving to right side, you will see pivot tables used for charts. After Z column Excel starts using AA, AB, etc. So you need to go far right till column BA. You will see pivot table there.
\n
\nHBB.TO name was fixed.\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[356593] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n edit: fixed ! \r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[281906] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by vidm\r\n \r\n
\r\n
Hi Larry,
\r\n
\r\nI added FAQ entry on how to enter Norbert\'s Gambit transactions into Portfolio Slicer: http://portfolioslicer.com/Support/FAQ#norbert
\r\nIf you have any problems - please do not hesitate to ask!
\r\n \r\n
\r\n
\r\n
Not sure i understand, i have both a US and a Canadian account, isnt something that should be configured in Portfolio Slicer ? Can you do an example of Norbert Gambit with the an interlisted stock (Ex: TD) ? Just want to avoid any confusion \r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[282242] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by larry81\r\n \r\n
\r\n
Not sure i understand, i have both a US and a Canadian account, isnt something that should be configured in Portfolio Slicer ? Can you do an example of Norbert Gambit with the an interlisted stock (Ex: TD) ? Just want to avoid any confusion
\r\n \r\n
\r\n
\r\n
Larry - You are right, I assumed that you are looking to do Norbert Gambit in the same account. But of course there could be different usage when you buy in one account and sell in another. I just updated same FAQ entry and added another example what you should do when you are buying in one and selling in another account. Please visit same page: http://portfolioslicer.com/Support/FAQ#norbert
\r\n
\r\nAnd thank you for good question - I am sure this FAQ entry will help many 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
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n 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[427953] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n Have you migrated symbol alias table? That is most likely reason.\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[428737] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by vidm\r\n \r\n
\r\n
Have you migrated symbol alias table? That is most likely reason.
\r\n \r\n
\r\n
\r\n
i added them in my symbol table, do i also need to add them in my portfolio on the website ? They are not listed on yahoo finance and dont have fixed price so i am not sure how...\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[687346] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \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: I tried to update my spreadsheet latest with latest price but for some reason it seems always stuck with a price on previous date. Same procedure which works well before no longer update. Wonder what may go wrong. I am still at version 0.9. 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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[688610] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by GGO\r\n \r\n
\r\n
Vidm: I tried to update my spreadsheet latest with latest price but for some reason it seems always stuck with a price on previous date. Same procedure which works well before no longer update. Wonder what may go wrong. I am still at version 0.9. Thanks.
\r\n \r\n
\r\n
\r\n
Quotes availability does not depend on PS version. Can yo please post symbol example that was not available when you tried to update and what time you did update.
\nFYI - Stocks/ETFs quotes are updated few times a day. Mutual fund update is usually done after 9pm.\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[689081] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by vidm\r\n \r\n
\r\n
Quotes availability does not depend on PS version. Can yo please post symbol example that was not available when you tried to update and what time you did update.
\nFYI - Stocks/ETFs quotes are updated few times a day. Mutual fund update is usually done after 9pm.
\r\n \r\n
\r\n
\r\n
Thanks vidm. When I go to powerpivot window and do refresh all, it does get updated and see green check mark. but when i go back to the holding tab, stock price is still the old price. I tried right click and update but nothing changes. On title page it does show latest date.\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[689121] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by GGO\r\n \r\n
\r\n
Thanks vidm. When I go to powerpivot window and do refresh all, it does get updated and see green check mark. but when i go back to the holding tab, stock price is still the old price. I tried right click and update but nothing changes. On title page it does show latest date.
\r\n \r\n
\r\n
\r\n
If you go to Holdings tab - please check slicers "Year" and "Month". If you selected any value in these slicers, then you will see holdings report for the end of period you selected. So if you selected Month "4", you will see holdings as if they were at the end of April 2015. Maybe that is your 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
\r\n -' + '->\r\n
\r\n \r\n \r\n \r\n \r\n \r\n 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[689625] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n Bingo, you nailed it. Thanks so much.\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[690777] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n Has anyone else noticed that quotes are not updating today? The holdings tab shows "Last Quote Update 2015-05-14 16:22:59 ET.
\r\nBut the prices in PS are from yesterday. Examples: XEF 27.24, VCN 30.22, HXT 28.06.
\r\nWhen I look in the Quotes tab of the PowerPivot window it does not show any quotes newer than 2015-05-13.
\r\n
\r\nI updated to version 1.0.2 today; not sure if that would have any effect. PowerPivot does seem to update correctly. It indicates Success and one of the items says Quotes Success 2,246 Rows Transferred\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[690793] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by GreatLaker\r\n \r\n
\r\n
Has anyone else noticed that quotes are not updating today? The holdings tab shows "Last Quote Update 2015-05-14 16:22:59 ET.
\nBut the prices in PS are from yesterday. Examples: XEF 27.24, VCN 30.22, HXT 28.06.
\nWhen I look in the Quotes tab of the PowerPivot window it does not show any quotes newer than 2015-05-13.
\n
\nI updated to version 1.0.2 today; not sure if that would have any effect. PowerPivot does seem to update correctly. It indicates Success and one of the items says Quotes Success 2,246 Rows Transferred
\r\n \r\n
\r\n
\r\n
Sorry, there was a problem with quotes that I just resolved. Please refresh your data now - you should see todays quotes.\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[690817] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n Yes it is working now. Thanks very much VDIM.
\r\nNice update. it is much faster to refresh the pivot tables.
\r\n
\r\nOne thing I noticed in the new release is on the Monthly and Yearly tabs the charts comparing to the indexes, the values for Index2 % are all at 100.00%. I attached a screen capture.
\r\n
\r\nThanks again.
\r\n
\r\nUntitled.png\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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[690841] = '\r\n
• \r\n\r\n\r\n \r\n
\r\n \r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n \r\n
\r\n Originally Posted by GreatLaker\r\n \r\n
\r\n
Yes it is working now. Thanks very much VDIM.
\nNice update. it is much faster to refresh the pivot tables.
\n
\nOne thing I noticed in the new release is on the Monthly and Yearly tabs the charts comparing to the indexes, the values for Index2 % are all at 100.00%. I attached a screen capture.
\n
\nThanks again.
\n
\nUntitled.png
\r\n \r\n
\r\n
\r\n
Could you please go to your web workbook (web interface, "edit" next to your workbook) and check what is your "Market Index2" symbol. Did you change that symbol from original value? Can you use symbol ^GSPC and see if that works better?
\n
\nAs you notice this release has lots of improvements for performance - I had to spend lots of time on that. I have users with many thousands of transactions who complained, so I did my best...\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n
\r\n
\r\n \r\n \r\n \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 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\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,645442"; pn[645442] = "644082,356529"; pn[356529] = "645442,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"; // -->

1. Hi Larry,

In Portfolio Slicer there are 2 transaction types to deal with such distributions:

NotionalDistrib Notional Distribution - Capital Gains Increases Book value!
ReturnOfCapital Return of Capital - Decreases book value!

So you simply enter distribution transaction with type "ReturnOfCapital", Qty=17234 and Price:5081.62