Miscellaneous Quicken Questions
Does Quicken download TDW transactions?
My 2002 quicken is no longer supported. I was going to upgrade to 2006 (XG - is for Canada?) so that I can try to download the transactions.
Is it able to download the TDW brokerage transactions? I have no interest in the credit card or banking stuff - I use the software just for keeping track of the transactions - especially non-registered taxable accounts.
In the past I have entered the buys, sells, dividends etc manually.
I know there are a number of quicken experts among us.
Is it able to download the TDW brokerage transactions? I have no interest in the credit card or banking stuff - I use the software just for keeping track of the transactions - especially non-registered taxable accounts.
In the past I have entered the buys, sells, dividends etc manually.
I know there are a number of quicken experts among us.
- Bylo Selhi
- Veteran Contributor
- Posts: 29494
- Joined: 16 Feb 2005 10:36
- Location: Waterloo, ON
- Contact:
Re: Does Quicken download TDW transactions?
Sez who? It works fine with TD EasyWeb and there's nothing on their site that says it is or will be unsupported. (Q02's days are numbered. The US version is now unsupported in the US.)marcharry wrote:My 2002 quicken is no longer supported.
Yes.2006 (XG - is for Canada?)
AFAIK, no. (That feature has been available in the US version for years, i.e. to download transaction from TD WH US.)Is it able to download the TDW brokerage transactions?
Sedulously eschew obfuscatory hyperverbosity and prolixity.
More Problems with Quicken
In addition to the Quicken stock quote problem that everyone is experiencing I seem to have an additional problem that I can't quite figure out.
I'm using Quicken XG and when I open my portfolio all dollar figures are shown correctly with two decimal places such as Price, Cost Basis, Market Value, Realized Gain, etc. However, any column with a percentage such as ROI, % Gain, % Invested, etc., the two decimal places are not there. What should read as 68.34 reads only 68.
How do I get the percentages in my portfolio to display two decimal places?
Strangely enough my Quicken XG portfolio used to display all percentages with two decimal places but my computer crashed a week ago and I had to reinstall Windows XP, reinstall my Quicken software and import my backed up Quicken files. Since then I simply cannot get the percentages to display correctly.
Within Quicken I've already clicked on "Edit", "Preferences", "Reports and Graphs" and changed the "Decimal Places for Prices and Shares" to 3 but that doesn't have any effect, of course, on the percentages display.
I've also clicked on "Start", "Control Panel", "Regional and Language Options", "Customize", and then the "Numbers" tab" and changed "No. of digits after decimal" to 2 but the percentages in the portfolio still look like XX. and not XX.XX.
Does anyone know what I'm doing wrong?
Help is appreciated.
I'm using Quicken XG and when I open my portfolio all dollar figures are shown correctly with two decimal places such as Price, Cost Basis, Market Value, Realized Gain, etc. However, any column with a percentage such as ROI, % Gain, % Invested, etc., the two decimal places are not there. What should read as 68.34 reads only 68.
How do I get the percentages in my portfolio to display two decimal places?
Strangely enough my Quicken XG portfolio used to display all percentages with two decimal places but my computer crashed a week ago and I had to reinstall Windows XP, reinstall my Quicken software and import my backed up Quicken files. Since then I simply cannot get the percentages to display correctly.
Within Quicken I've already clicked on "Edit", "Preferences", "Reports and Graphs" and changed the "Decimal Places for Prices and Shares" to 3 but that doesn't have any effect, of course, on the percentages display.
I've also clicked on "Start", "Control Panel", "Regional and Language Options", "Customize", and then the "Numbers" tab" and changed "No. of digits after decimal" to 2 but the percentages in the portfolio still look like XX. and not XX.XX.
Does anyone know what I'm doing wrong?
Help is appreciated.
Don't know either but you might post the question on the Intuit Quicken forum.
As noted in the other thread, Quicken seems to be having trouble with the 'quote server' source data for price updates, i.e. it is not necessarily their problem, but their provider's problem, i.e. Yahoo, or equivalent.
FWIW, when I did my usual Saturday morning price update, I noticed I did not get any price update data for US domiciled stocks yet (June 29 only). All other price update data looks fine.
As noted in the other thread, Quicken seems to be having trouble with the 'quote server' source data for price updates, i.e. it is not necessarily their problem, but their provider's problem, i.e. Yahoo, or equivalent.
FWIW, when I did my usual Saturday morning price update, I noticed I did not get any price update data for US domiciled stocks yet (June 29 only). All other price update data looks fine.
-
- Contributor
- Posts: 67
- Joined: 18 Mar 2005 13:36
Miscellaneous Quicken Questions
Anyone remember TIPS35? How do you enter/categorize (in Quicken) the change from TIPS35 to XIU? Canadian Shareowners transferred out/transferred in (but the share number wasn't the same), but how does that affect ACB, rate of return etc. Any suggestions?
- Bylo Selhi
- Veteran Contributor
- Posts: 29494
- Joined: 16 Feb 2005 10:36
- Location: Waterloo, ON
- Contact:
Re: A quick Quicken question
I remember TIPS35 (and HIPS) but I can't remember how I handled the transition to XIU in Quicken. That said, here's what I'd do if I had it to do again.JohnMorgan wrote:Anyone remember TIPS35? How do you enter/categorize (in Quicken) the change from TIPS35 to XIU?
1. Record your ACB for TIPS.
2. In Quicken, do a ShrsOut of all TIPS shares.
3. Now do a ShrsIn of XIU using the ACB from 1.
Sedulously eschew obfuscatory hyperverbosity and prolixity.
-
- Contributor
- Posts: 67
- Joined: 18 Mar 2005 13:36
TIPS35/XIU/QUICKEN
Thank you for quick reply.Am now at home and looking at this. In the drop down menu for transaction entry, 'Add' and 'Remove' seem to be the closest options to Shrsout/in. However in Remove there is nowhere to enter $ amounts, just number of shares; whereas in Add, there is 'price paid per share'. Also they didn't give a price for either of the securities at the time of swap. I'm not clear how all this washes for ACB of XIU in the long run. Quicken help, of course, doesn't. Is this time for near enough being good enough???
- Bylo Selhi
- Veteran Contributor
- Posts: 29494
- Joined: 16 Feb 2005 10:36
- Location: Waterloo, ON
- Contact:
Re: TIPS35/XIU/QUICKEN
Yeah. I used Quicken 2002 terminology. I see that they've changed it to Add and Remove in more recent versions.JohnMorgan wrote:In the drop down menu for transaction entry, 'Add' and 'Remove' seem to be the closest options to Shrsout/in.
In Quicken 2007 (at least) Remove asks for both number of shares and share price. Use ACB divided by the number of shares to get the latter. Then similarly when you do the Add, use ACB divided by the number of new shares to get the "book" share price. You want to make sure that the transactions both occur at the ACB value, not market value. The next time you update stock prices Quicken will find the current NAV and compute the current market value of your position.However in Remove there is nowhere to enter $ amounts, just number of shares; whereas in Add, there is 'price paid per share'.
As long as the ACB on your XIU holding is the same as the ACB on your TIPS35 holding, regardless of the number of shares of either, the taxman should be happy.I'm not clear how all this washes for ACB of XIU in the long run.
Sedulously eschew obfuscatory hyperverbosity and prolixity.
-
- Contributor
- Posts: 67
- Joined: 18 Mar 2005 13:36
TIPS35/XIU/QUICKEN
Thank you. It all looks pretty reasonable now.
-
- Contributor
- Posts: 67
- Joined: 18 Mar 2005 13:36
Foreign non-resident tax deducted at source // Quicken XG 20
Whats the best way of keeping track of this?
Not necessarily precise tax treatment but even keeping track for each security.
Thank you.
Not necessarily precise tax treatment but even keeping track for each security.
Thank you.
how do i enter cap gains distribution for XDV on quicken?
how do i add the distributon to affect my ACB without affecting all the other parameters on quicken 2007
thanks all
nile
thanks all
nile
- Bylo Selhi
- Veteran Contributor
- Posts: 29494
- Joined: 16 Feb 2005 10:36
- Location: Waterloo, ON
- Contact:
Re: how do i enter cap gains distribution for XDV on quicken
See a previous thread starting at about here.nile wrote:how do i add the distributon to affect my ACB without affecting all the other parameters on quicken 2007
("RtnCapX" is what Q02 calls it. Q07 calls it "RtrnCapX." Same difference.)
Sedulously eschew obfuscatory hyperverbosity and prolixity.
Tracking in Quicken
I know that many here use Quicken to track their investments and I need some advice about starting..
I have been tracking my investments using Globe..mutual funds since 1998 and stocks since 2000 but have been hestitate to start tracking in Quicken...overwhelmed by the task of imputing all figures!
So..can I start now...say by using Dec. 31, 2007 as the start date???
IF..I use that date..what figures should I use to get the most accurate results in the future? Hope this question makes sense...
Any tips greatly appreciated.
I have been tracking my investments using Globe..mutual funds since 1998 and stocks since 2000 but have been hestitate to start tracking in Quicken...overwhelmed by the task of imputing all figures!
So..can I start now...say by using Dec. 31, 2007 as the start date???
IF..I use that date..what figures should I use to get the most accurate results in the future? Hope this question makes sense...
Any tips greatly appreciated.
- Bylo Selhi
- Veteran Contributor
- Posts: 29494
- Joined: 16 Feb 2005 10:36
- Location: Waterloo, ON
- Contact:
Depends on what you want to accomplish.
If you're just maintaining records for tax purposes then all you'd need to "import" into Quicken would be, for each security, the number of shares and the ACB. (If it's a US security you'll also need to calculate the blended FX rate for all purchases and sales of that security.)
If you want to calculate things like IRR and/or produce nice-looking historical charts, etc. then you'll need to "import" all the transactions. That could be impractical if you have a lot of history.
Have you investigated if Globefund has any export features, either in CSV or QIF formats? If so that would make it very easy to import all the historical data into Quicken.
If you're just maintaining records for tax purposes then all you'd need to "import" into Quicken would be, for each security, the number of shares and the ACB. (If it's a US security you'll also need to calculate the blended FX rate for all purchases and sales of that security.)
If you want to calculate things like IRR and/or produce nice-looking historical charts, etc. then you'll need to "import" all the transactions. That could be impractical if you have a lot of history.
Have you investigated if Globefund has any export features, either in CSV or QIF formats? If so that would make it very easy to import all the historical data into Quicken.
Sedulously eschew obfuscatory hyperverbosity and prolixity.
Tracking in Quicken
Thanks Bylo for your suggestions..
I decided to take a chance and have just downloaded my accounts from TDW...will work with the results and may be back for more advice once I have worked with the figures.
**
Dennis..I hate to admit it BUT.. spreadsheets 'terrify' me even more than Quicken! Perhaps a project for my spare time, eh!
Thanks..
I decided to take a chance and have just downloaded my accounts from TDW...will work with the results and may be back for more advice once I have worked with the figures.
**
Dennis..I hate to admit it BUT.. spreadsheets 'terrify' me even more than Quicken! Perhaps a project for my spare time, eh!
Thanks..
-
- Veteran Contributor
- Posts: 3385
- Joined: 27 May 2008 16:25
Real-return bond fund in Quicken
I'm aware that XRB has an odd tax treatment: The inflation appreciation of this real-return bond fund is reflected in its NAV and investors are taxed on it as reinvested interest; meanwhile the actual interest component is paid out.
I was thinking about how to enter this properly in Quicken, which I believe has no proper "interest reinvested but not in extra shares" option. Suppose I get $110 in reinvested interest and $130 in cash interest. Then I could enter:
1) An interest dividend of $240: tax treatment is now correct but at this point, my Quicken cash balance will be $110 too high and my ACB will be $110 too low.
2) A *negative* Return Of Capital of $110. This will reduce my cash by $110 and add the same number to ACB. Net result is now correct.
Hope this is useful Let me know if you can think of a briefer way.
I was thinking about how to enter this properly in Quicken, which I believe has no proper "interest reinvested but not in extra shares" option. Suppose I get $110 in reinvested interest and $130 in cash interest. Then I could enter:
1) An interest dividend of $240: tax treatment is now correct but at this point, my Quicken cash balance will be $110 too high and my ACB will be $110 too low.
2) A *negative* Return Of Capital of $110. This will reduce my cash by $110 and add the same number to ACB. Net result is now correct.
Hope this is useful Let me know if you can think of a briefer way.
-
- Veteran Contributor
- Posts: 3385
- Joined: 27 May 2008 16:25
Quicken online
Anyone using quicken online? Apparently the online version is free now. I have some (major) qualms about keeping my data secure. Thoughts on security?