|
Post by yogibearbull on Jul 23, 2022 12:55:32 GMT
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Jul 23, 2022 17:24:10 GMT
I'm looking forward to your opinion. Thanks.
|
|
|
Post by nobhead on Jul 23, 2022 19:56:04 GMT
I'm looking forward to your opinion. Thanks. +1 I have not tried it yet but seems to be about the best alternative I found. Please post your feelings about it.
|
|
|
Post by yogibearbull on Jul 24, 2022 21:31:18 GMT
Stock Rover (SR) Pointers
There are several Stock Rover (SR) links for Help, FAQs, etc, so I will not try to prepare a “Guide”. Rather, as the SR site is not very user-friendly or intuitive, I will give some POINTERS for new users. NAVIGATION is difficult. Some features/functions appear only on relevant pages/tabs. Page FRAMES can be expanded or shrunk – note up-pointing and side-pointing ARROWS; down-pointing arrows only open the MENUS. FREE version is very limited. It allows creation of 10 (max) Portfolios and Watchlists but doesn’t allow Table-displays or any analytics. DASHBOARD will show overall summaries including portfolio value, G/L, daily changes; PORTFOLIO right-PANEL (expandable with side-arrow) shows basic portfolio details. If you want to use SR just for QUOTES and CHARTS, the FREE version may be fine. CHARTS are not linkable but can be SAVED as images (so, this eliminates taking a screenshot). To POST them elsewhere, use copy-and-paste, site upload/attachment feature or an image hosting site link to share/post. WATCHLISTS have tickers only, but PORTFOLIOS have tickers, quantities, purchase prices. PORTFOLIO details and analytics are available with PREMIUM and PREMIUM PLUS. Premium has full portfolio functionality, but Premium Plus allows for larger (600 tickers vs 250 tickers) and more (60 vs 25) Portfolios and Watchlists. Premium Plus has many other advanced features. Unfortunately, Essentials doesn’t have much portfolio functionality. So, PREMIUM should be fine for serious portfolio users. www.stockrover.com/plans/why-go-premium/ Portfolios to be IMPORTED should have required Excel columns for tickers, quantities, costs/share. For M* Portfolio (that don’t have these 3 columns present in any tab/view), use Export from Tracking==>Gain/Loss to your PC. Insert a column for Tickers and add tickers (using another M* tab/view or from memory), then IMPORT into SR; Name/Rename (see below). SR Portfolio basically starts fresh from the import date; old transaction history at M* (or elsewhere) will be lost. Multiple Portfolios can be COMBINED. For SR-IMPORT, Click PORTFOLIO on the left-menu, make sure that Portfolio HEADING is clicked/highlighted in the main page (down-ARROW will show full Menu), then from the Menu or the right-PANEL, choose CREATE PORTFOLIO. Entries can then be made MANUALLY, or portfolio IMPORTED from Excel (with Tickers, quantities, costs/share columns), or via CONNECTION to selected brokerages (I won't be trying that). Steps are similar for importing a WATCHLIST, but some options shown are different. Portfolio TOOLS/Future SIMULATION can be used to conduct SYSTEMATIC WITHDRAWALS/INVESTMENT studies with various other options. CASH row can be displayed in Portfolio Table (from Portfolio, EXPAND Portfolio panel to see the option for cash display). ADJUSTING CASH (transactional) is by click on every buy/sell. Fully SOLD positions are not deleted from the record (so that performance calculations remain accurate). LAST-CLOSE prices are updated after next market open. This is to properly indicate price change data. (this is unusual as most want complete updates by evening, but SR notes that this would make all changes 0) YIELDS are forward yields. FUND YIELDS include CG distributions. Most financial data are for CALENDAR years and for GAAP accounting with applicable RESTATEMENTS. DIVIDENDS are shown as cash and must be reinvested manually. However, Portfolio Analytics does dividend reinvesting internally. Standard deviation (SD; 1-yr, 3-yr) is based on DAILY returns and then ANNUALIZED (using sqrt(252) = 15.87 or 16); multiply by 100 to show as %. The SR SD values are much higher than those from M* and Portfolio Visualizer (PV) that use monthly returns. Unfortunately, SR just uses a WEIGHTED-AVERAGE of component SDs for PORTFOLIO SD and that is an overestimation (as it ignores cross-correlations). SUMMARY VALUES in portfolio Tables are also weighted-averages (so, not good for Portfolio MPT data) except for ratios such as P/E, P/B, P/S etc for which harmonic-averages are used. Negative P/Es are replaced by blanks. LIMITATIONS SR system is POSITIONS-based, not TRANSACTIONS-based. INTRADAY trades are netted for the day; holding SALE prices are closing prices only (default) – so all G/L are approximations. Prices are delayed 1-5-15 minutes. Tables and charts REFRESH manually on browser refresh but can be set to Auto-Refresh at 1-5-10 minutes (OFF by default) in Preferences for Premium and Premium Plus. LINK
|
|
|
Post by ECE Prof on Jul 24, 2022 21:58:54 GMT
Pay and buy Quicken Premier. You will be glad you did the right thing.
Many of my cost basis given by Vanguard were a few thousand dollars less than the cost basis in my Quicken entries. I was not particular what shares I sold. Since I have the history in the Vanguard Website for the current securities, I am trying to reconstruct my cost basis. One security at a time. Today, I have finally succeeded in reconstructing the longest holding VTI since 2010. I learned how to do it using spreadsheets. It seems that this would help during my tax time. There are some techniques in Quicken to take care of even for wash sales.
Anyway, in short, no more freebies.
ECEProf.
|
|
|
Post by nobhead on Jul 25, 2022 1:38:37 GMT
Pay and buy Quicken Premier. You will be glad you did the right thing. Many of my cost basis given by Vanguard were a few thousand dollars less than the cost basis in my Quicken entries. I was not particular what shares I sold. Since I have the history in the Vanguard Website for the current securities, I am trying to reconstruct my cost basis. One security at a time. Today, I have finally succeeded in reconstructing the longest holding VTI since 2010. I learned how to do it using spreadsheets. It seems that this would help during my tax time. There are some techniques in Quicken to take care of even for wash sales. Anyway, in short, no more freebies. ECEProf. ECE Prof, I am struggling to do the same thing. I have the cost basis downloaded to a .csv file but cannot figure out how to get it into Quicken Premier. Any help would be greatly appreciated.
TIA
|
|
|
Post by yogibearbull on Jul 25, 2022 3:40:33 GMT
I have built some SR Charts to show examples in this LINK.
|
|
|
Post by ECE Prof on Jul 25, 2022 14:52:08 GMT
Pay and buy Quicken Premier. You will be glad you did the right thing. Many of my cost basis given by Vanguard were a few thousand dollars less than the cost basis in my Quicken entries. I was not particular what shares I sold. Since I have the history in the Vanguard Website for the current securities, I am trying to reconstruct my cost basis. One security at a time. Today, I have finally succeeded in reconstructing the longest holding VTI since 2010. I learned how to do it using spreadsheets. It seems that this would help during my tax time. There are some techniques in Quicken to take care of even for wash sales. Anyway, in short, no more freebies. ECEProf. ECE Prof , I am struggling to do the same thing. I have the cost basis downloaded to a .csv file but cannot figure out how to get it into Quicken Premier. Any help would be greatly appreciated.
TIA
It is a long and difficult process. I printed the cost basis data for each security from the Quicken and also from Vanguard. Mostly, they are likely to be identical, if you have specified the sale shares same as in Vanguard. However, I was that particular about this several years ago. Why? Our legacy is from mutual funds. Load them into spreadsheet - Libreoffice or Google sheets so that they have the same forms. You can identify the differences. Wherever, there is a difference, you use "remove" those shares in Quicken, and then "add" the shares using the cost basis from Vanguard. Fortunately, I had only some 10 reinvested new shares for various quarters since 2010 until 2012 that I had to enter manually for VTI yesterday. Then, I found that difference in the cost basis, overall cost basis. The cost basis difference reduced from $5000+ to only $830. This is a lot better. Then, I used "remove" and "add" feature and took out $830 from the old shares of the original purchase back in 2010, when I took the offer from Vanguard to convert from mutual fund (VTSAX) to VTI. It should be from those shares because all the rest of the data were identical in both places. It took me the whole day to figure out this and finally got it done.
I also learned an interesting thing during this process. Something 30% of the shares were reinvested dividends. I never paid cash from my pocket. So, the power of invisible hand was very much evident in observing the data file. Normally, you do not think about the old stuff and just remember for about a year. So, the growth is not only about the original investment and also the growth of the reinvested shares and their prices. Amazing. In fact, in about 12 years, the investments have grown nearly 5 to 6 times, not 4 times due to price appreciation alone. Real estate and bond investments do not, and indeed, cannot grow at this rate. Anyway, just my two cents.
|
|
|
Post by nobhead on Jul 26, 2022 0:01:12 GMT
ECE Prof , I am struggling to do the same thing. I have the cost basis downloaded to a .csv file but cannot figure out how to get it into Quicken Premier. Any help would be greatly appreciated.
TIA
It is a long and difficult process. I printed the cost basis data for each security from the Quicken and also from Vanguard. Mostly, they are likely to be identical, if you have specified the sale shares same as in Vanguard. However, I was that particular about this several years ago. Why? Our legacy is from mutual funds. Load them into spreadsheet - Libreoffice or Google sheets so that they have the same forms. You can identify the differences. Wherever, there is a difference, you use "remove" those shares in Quicken, and then "add" the shares using the cost basis from Vanguard. Fortunately, I had only some 10 reinvested new shares for various quarters since 2010 until 2012 that I had to enter manually for VTI yesterday. Then, I found that difference in the cost basis, overall cost basis. The cost basis difference reduced from $5000+ to only $830. This is a lot better. Then, I used "remove" and "add" feature and took out $830 from the old shares of the original purchase back in 2010, when I took the offer from Vanguard to convert from mutual fund (VTSAX) to VTI. It should be from those shares because all the rest of the data were identical in both places. It took me the whole day to figure out this and finally got it done.
I also learned an interesting thing during this process. Something 30% of the shares were reinvested dividends. I never paid cash from my pocket. So, the power of invisible hand was very much evident in observing the data file. Normally, you do not think about the old stuff and just remember for about a year. So, the growth is not only about the original investment and also the growth of the reinvested shares and their prices. Amazing. In fact, in about 12 years, the investments have grown nearly 5 to 6 times, not 4 times due to price appreciation alone. Real estate and bond investments do not, and indeed, cannot grow at this rate. Anyway, just my two cents. Thanks, @ece Prof. It looks like that is the only way. I searched in vain for a way to import the .csv cost basis file I downloaded from Vanguard. I was keeping all my transactions in a Google Sheet but decided it was too much trouble. I could have had mine half way done with the time I wasted looking for a way to import it. I also have transactions that go back almost 15 years that show how the "invisible hand" worked well for me too.
Thanks again for the information. Take care.
|
|
|
Post by ECE Prof on Jul 26, 2022 0:10:48 GMT
"I also have transactions that go back almost 15 years that show how the "invisible hand" worked well for me too.
My investments go back to 1995/96. But, in 2010, Vanguard offered to move to the brokerage service and convert VTSAX to VTI without any taxable event. So, I accepted it, and they moved the stuff. The same thing to VIG, and another one also. I forgot the name now because I do not own it now.
|
|
|
Post by yogibearbull on Jul 30, 2022 13:00:40 GMT
|
|