Re: Tracking a TIAA mixed fund account

[AC]

Seems like it might but what I want is to have the top level account
(let's just call it TIAA) follow the entire value of the portfolio.
Underneath that I want to see what the three individual funds are doing
(the two lifecycles and the mutual).  In the case of the lifecycle,
you're correct that it sort of looks like a mutual fund except that I
don't know what's actually inside it unlike a traditional MF where I
know the individual distribution of shares that make up the overall MF.

In this case then there would be three under TIAA, TIAA LC 1, TIAA LC2
and TIAA MF and I would want to see the individual values (in dollars)
of those three including the contributions to each, whatever dividends
they earn and then, in the case of TIAA MF, I'd want to have the
underlying distributions recorded just like a normal MF account.

I suppose the sticky point is having the value tracking of the whole
portfolio in addition to the individual fund values and then the MF
distributions.  Trying to get the cascade to work right.

On 2017-07-22 21:17, David T. wrote:
> I may be misunderstanding,  but it seems like the following would work:
> 
> Assets:TIAA (cash)
> Assets:TIAA:Lifecycle 1 (commodity)
> Assets:TIAA:Lifecycle 2 (commodity)
> Assets:TIAA:TIAA Mutual Fund (commodity)
> 
> My experience of the so called "Lifecycle" funds is that they are just like 
> any 
> other mutual funds.
> 
> When I handle payroll deductions, the dollars go into the cash account, and a 
> separate purchase transaction moves the cash into fund shares. It's a little 
> cumbersome, but it allows me to ensure that the right numbers get in.
> 
> HTH,
> David
> 
> On Sun, Jul 23, 2017 at 8:38, AC
>  wrote:
> I want to start tracking my TIAA retirement portfolio for informational
> purposes (no reporting needs, filings, etc.) but I need some suggestions
> on structuring the account trees so that it doesn't affect my existing
> accounts.  However, possibly later I'll edit things so that the paycheck
> contributions are directed accordingly so I'd want the new accounts to
> allow that eventually (i.e. for now I'll add contributions manually
> using a virtual source and eventually go back through and move those to
> withdraw from my paycheck, the amount withheld is already accounted)
> 
> The trick with my TIAA portfolio is that it has three different products
> within it.  Two of them are TIAA funds (one of the lifecycle multi-asset
> funds) that does not have a breakdown of the individual holdings (like a
> mutual fund).  These two only document the employer contributions, my
> contributions, shares and interest/dividends.  The third product is a
> TIAA mutual fund for which the individual holdings are broken out with
> all the same data as a typical mutual fund (shares, prices, etc.)
> 
> What I expect to have is some type of top-level account that tracks the
> overall value of the portfolio in dollars and then either within that or
> somewhere nearby an account or account tree for each of the three
> products.  At first I had considered just making the two TIAA funds into
> an account that was basically a mutual fund with a single holding but I
> wasn't quite sure how to combine that with the one real mutual fund when
> each of the three funds receives different amounts of contributions and
> individual dividends.  Perhaps it would be a top-level account then
> three sub-accounts that are all mutual funds with two of them having one
> holding and the last is the broken out holding?
> 
> I don't plan on using this for any official reporting (I get those
> documents already), and I don't plan on downloading statements, quotes,
> or anything else.  I'll just manually track things as my statements come
> in and I enter the data from those, perhaps updating symbol share prices
> manually if I'm interested at a particular time.  I don't currently use
> much reporting as is with my existing accounts except an occasional cash
> flow report so as long as that isn't affected I'm fine.  I do currently
> have a mutual fund being tracked so I want to be careful not to cause
> trouble for that either.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Fwd: Re: Tracking a TIAA mixed fund account

[Dale Alspach]

I have two TIAA contracts which contain mutual funds and other similar
investments. I have a top level asset account named Retirement and below
that are asset accounts for each contract. Under each contract are accounts
for each mutual fund, ETF, etc. As far as I am aware all TIAA funds now
have symbols and quotes can be obtained from Yahoo. The only exception is
the TIAA guaranteed or stable-value fund. For that one I use pseudo shares
with 1 dollar = 1 share. So each underlying mutual fund is setup to use
prices updated by finance-quote. I download transactions
once a month from the TIAA site.

To keep things organized I have separate income accounts for tax sheltered
income and taxed income. Transactions
under the Retirement account only affect the tax sheltered income accounts.

Dale

On Jul 22, 2017 10:38 PM, "AC"  wrote:

> I may be misunderstanding,  but it seems like the following would work:
> Assets:TIAA (cash)Assets:TIAA:Lifecycle 1 (commodity)Assets:TIAA:Lifecycle
> 2 (commodity)Assets:TIAA:TIAA Mutual Fund (commodity)
> My experience of the so called "Lifecycle" funds is that they are just
> like any other mutual funds.
> When I handle payroll deductions, the dollars go into the cash account,
> and a separate purchase transaction moves the cash into fund shares. It's a
> little cumbersome, but it allows me to ensure that the right numbers get
> in.
> HTH, David
>
>
>   On Sun, Jul 23, 2017 at 8:38, AC wrote:   I want
> to start tracking my TIAA retirement portfolio for informational
> purposes (no reporting needs, filings, etc.) but I need some suggestions
> on structuring the account trees so that it doesn't affect my existing
> accounts.  However, possibly later I'll edit things so that the paycheck
> contributions are directed accordingly so I'd want the new accounts to
> allow that eventually (i.e. for now I'll add contributions manually
> using a virtual source and eventually go back through and move those to
> withdraw from my paycheck, the amount withheld is already accounted)
>
> The trick with my TIAA portfolio is that it has three different products
> within it.  Two of them are TIAA funds (one of the lifecycle multi-asset
> funds) that does not have a breakdown of the individual holdings (like a
> mutual fund).  These two only document the employer contributions, my
> contributions, shares and interest/dividends.  The third product is a
> TIAA mutual fund for which the individual holdings are broken out with
> all the same data as a typical mutual fund (shares, prices, etc.)
>
> What I expect to have is some type of top-level account that tracks the
> overall value of the portfolio in dollars and then either within that or
> somewhere nearby an account or account tree for each of the three
> products.  At first I had considered just making the two TIAA funds into
> an account that was basically a mutual fund with a single holding but I
> wasn't quite sure how to combine that with the one real mutual fund when
> each of the three funds receives different amounts of contributions and
> individual dividends.  Perhaps it would be a top-level account then
> three sub-accounts that are all mutual funds with two of them having one
> holding and the last is the broken out holding?
>
> I don't plan on using this for any official reporting (I get those
> documents already), and I don't plan on downloading statements, quotes,
> or anything else.  I'll just manually track things as my statements come
> in and I enter the data from those, perhaps updating symbol share prices
> manually if I'm interested at a particular time.  I don't currently use
> much reporting as is with my existing accounts except an occasional cash
> flow report so as long as that isn't affected I'm fine.  I do currently
> have a mutual fund being tracked so I want to be careful not to cause
> trouble for that either.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Tracking a TIAA mixed fund account

[David T. via gnucash-user]

I may be misunderstanding,  but it seems like the following would work:
Assets:TIAA (cash)Assets:TIAA:Lifecycle 1 (commodity)Assets:TIAA:Lifecycle 2 
(commodity)Assets:TIAA:TIAA Mutual Fund (commodity)
My experience of the so called "Lifecycle" funds is that they are just like any 
other mutual funds. 
When I handle payroll deductions, the dollars go into the cash account, and a 
separate purchase transaction moves the cash into fund shares. It's a little 
cumbersome, but it allows me to ensure that the right numbers get in. 
HTH, David
 
 
  On Sun, Jul 23, 2017 at 8:38, AC wrote:   I want to 
start tracking my TIAA retirement portfolio for informational
purposes (no reporting needs, filings, etc.) but I need some suggestions
on structuring the account trees so that it doesn't affect my existing
accounts.  However, possibly later I'll edit things so that the paycheck
contributions are directed accordingly so I'd want the new accounts to
allow that eventually (i.e. for now I'll add contributions manually
using a virtual source and eventually go back through and move those to
withdraw from my paycheck, the amount withheld is already accounted)

The trick with my TIAA portfolio is that it has three different products
within it.  Two of them are TIAA funds (one of the lifecycle multi-asset
funds) that does not have a breakdown of the individual holdings (like a
mutual fund).  These two only document the employer contributions, my
contributions, shares and interest/dividends.  The third product is a
TIAA mutual fund for which the individual holdings are broken out with
all the same data as a typical mutual fund (shares, prices, etc.)

What I expect to have is some type of top-level account that tracks the
overall value of the portfolio in dollars and then either within that or
somewhere nearby an account or account tree for each of the three
products.  At first I had considered just making the two TIAA funds into
an account that was basically a mutual fund with a single holding but I
wasn't quite sure how to combine that with the one real mutual fund when
each of the three funds receives different amounts of contributions and
individual dividends.  Perhaps it would be a top-level account then
three sub-accounts that are all mutual funds with two of them having one
holding and the last is the broken out holding?

I don't plan on using this for any official reporting (I get those
documents already), and I don't plan on downloading statements, quotes,
or anything else.  I'll just manually track things as my statements come
in and I enter the data from those, perhaps updating symbol share prices
manually if I'm interested at a particular time.  I don't currently use
much reporting as is with my existing accounts except an occasional cash
flow report so as long as that isn't affected I'm fine.  I do currently
have a mutual fund being tracked so I want to be careful not to cause
trouble for that either.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Tracking a TIAA mixed fund account

[AC]

I want to start tracking my TIAA retirement portfolio for informational
purposes (no reporting needs, filings, etc.) but I need some suggestions
on structuring the account trees so that it doesn't affect my existing
accounts.  However, possibly later I'll edit things so that the paycheck
contributions are directed accordingly so I'd want the new accounts to
allow that eventually (i.e. for now I'll add contributions manually
using a virtual source and eventually go back through and move those to
withdraw from my paycheck, the amount withheld is already accounted)

The trick with my TIAA portfolio is that it has three different products
within it.  Two of them are TIAA funds (one of the lifecycle multi-asset
funds) that does not have a breakdown of the individual holdings (like a
mutual fund).  These two only document the employer contributions, my
contributions, shares and interest/dividends.  The third product is a
TIAA mutual fund for which the individual holdings are broken out with
all the same data as a typical mutual fund (shares, prices, etc.)

What I expect to have is some type of top-level account that tracks the
overall value of the portfolio in dollars and then either within that or
somewhere nearby an account or account tree for each of the three
products.  At first I had considered just making the two TIAA funds into
an account that was basically a mutual fund with a single holding but I
wasn't quite sure how to combine that with the one real mutual fund when
each of the three funds receives different amounts of contributions and
individual dividends.  Perhaps it would be a top-level account then
three sub-accounts that are all mutual funds with two of them having one
holding and the last is the broken out holding?

I don't plan on using this for any official reporting (I get those
documents already), and I don't plan on downloading statements, quotes,
or anything else.  I'll just manually track things as my statements come
in and I enter the data from those, perhaps updating symbol share prices
manually if I'm interested at a particular time.  I don't currently use
much reporting as is with my existing accounts except an occasional cash
flow report so as long as that isn't affected I'm fine.  I do currently
have a mutual fund being tracked so I want to be careful not to cause
trouble for that either.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: No stock quote for LU1233758587

[farleykj]

I made a quick shell script to try to get quotes for this symbol
(LU1233758587) on all the sources available. Running gnc-fq-check gives all
the sources, and sending an inquiry to gnc-fq-dump  LU1233758587 for
each source checks them. None of the sources yielded anything.
Some possibilities I can think of:
(1) The fund (Robeco QI Emerging Conservative Equities?) has changed its
symbol.
(2) The service(s) providing a quote for this have changed their interface
enough so that finance:quote can't obtain the necessary information from
it/them anymore.
(3) The service(s) providing a quote for this have changed the symbol they
use for this fund. For example, a somewhat popular stock in the US is
Berkshire Hathaway, B shares. Some services use BKR-B for it, while others
use BRKB, some use BRK:B. They might decide to use different symbols, which
finance:quote wouldn't know about.
You might have to do a little searching to find out if you need to change
the source and/or symbol for this fund.



-
Ken Farley
--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/No-stock-quote-for-LU1233758587-tp4692765p4692768.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.