Re: [GNC] Unable to get TIAA-CREF price quotes

[doug brown via gnucash-user]

Yes. That does work.  Although it takes a very long time to get a response from 
Yahoo.  Like three minutes. That may be a function of my slow internet 
connection.
 Thank you very much, Dale.
Doug
On Wednesday, July 5, 2023 at 07:20:02 PM GMT-7, Dale Alspach 
 wrote:  
 
 Have you tried using Yahoo as JSON to retrieve TIAA prices? This works for all 
of mine. I don't know about that particular one.

Dale
On Wed, Jul 5, 2023, 7:06 PM doug brown via gnucash-user 
 wrote:


Linux Mint v. 20. GNUCASH v. 4.2Finance::Quote v. 1.56
When I update the price Data Base it fails to retrieve TIAA-CREF quotes.
The Security Editor is set up as follows:

Running gnc-fq-dump gives the following result:
doug@sager:~/src/gnucash-5.1$ gnc-fq-dump tiaacref QCBMPXFinance::Quote fields 
Gnucash uses:    symbol: QCBMPX (deduced)     <=== required      date: ** 
missing **        <=== recommended  currency: ** missing **        <=== 
required      last: **missing**          <=\              nav: **missing**      
    <=== one of these     price: **missing**          <=/          timezone:    
                  <=== optional
** This stock quote cannot be used by GnuCash!
Any thoughts?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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: [GNC] Unable to get TIAA-CREF price quotes

[Dale Alspach]

Have you tried using Yahoo as JSON to retrieve TIAA prices? This works for
all of mine. I don't know about that particular one.


Dale

On Wed, Jul 5, 2023, 7:06 PM doug brown via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> Linux Mint v. 20. GNUCASH v. 4.2Finance::Quote v. 1.56
> When I update the price Data Base it fails to retrieve TIAA-CREF quotes.
> The Security Editor is set up as follows:
>
> Running gnc-fq-dump gives the following result:
> doug@sager:~/src/gnucash-5.1$ gnc-fq-dump tiaacref QCBMPXFinance::Quote
> fields Gnucash uses:symbol: QCBMPX (deduced) <=== required
> date: ** missing **<=== recommended  currency: ** missing **
> <=== required  last: **missing**  <=\  nav:
> **missing**  <=== one of these price: **missing**  <=/
> timezone:  <=== optional
> ** This stock quote cannot be used by GnuCash!
> Any thoughts?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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
To update your subscription preferences or to unsubscribe:
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: [GNC] Unable to get TIAA-CREF price quotes

[Bruce Schuck]

On 7/5/23 19:23 UTC, Doug Brown wrote:


Linux Mint v. 20.?GNUCASH v. 4.2Finance::Quote v. 1.56
When I update the price Data Base it fails to retrieve TIAA-CREF quotes.
The Security Editor is set up as follows:



Running?gnc-fq-dump gives the following result:
doug@sager:~/src/gnucash-5.1$  gnc-fq-dump tiaacref QCBMPXFinance::Quote fields Gnucash uses:? ? 
symbol: QCBMPX (deduced)? ? ?<=== required? ? ? date: ** missing **? ? ? ? <=== recommended? 
currency: ** missing **? ? ? ? <=== required? ? ? last: **missing**? ? ? ? ? <=\? ? ? ?? ? ? 
?nav: **missing**? ? ? ? ? <=== one of these? ? ?price: **missing**? ? ? ? ? <=/? ? ? ??? 
timezone:? ? ? ? ? ? ? ? ? ? ? <=== optional
** This stock quote cannot be used by GnuCash!


Doug, et al.,

It looks like TIAA-CREF has changed the format of their website sometime 
since last changed in October 2020. This in turn breaks the parsing 
logic in the module. It will need more investigation to determine if it 
can be corrected and the amount of effort required.


In the meantime, feel free to open an issue at 
https://github.com/finance-quote/finance-quote/issues.


Thank you.

Bruce S.

P.S. I am not sure if the last person to modify the TIAA-CREF module is 
on the GnuCash user list, but I Bcc'd the email address used in their 
commits.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Transferring mutual funds

[AC]

Since these funds have been held since before I started using Gnucash I 
can't really carry over any cost basis within it. I won't worry about it 
too much because I am not using the reports directly and I don't use 
Gnucash for my taxes. However, it appears it handled it anyway because 
the top-level brokerage account shows a value of zero now because all 
the underlying funds have zeroed out and the new brokerage account shows 
roughly the original value of the old account.


Fortunately with ACATs (Automated Customer Account Transfer) all of the 
data and metadata transferred from one brokerage to the other. I'm able 
to see all of the historic basis values at the new brokerage site for 
all the funds. One less thing to worry about.


On 2023-07-05 15:48, David Carlson wrote:

AC,

Yes, to keep GnuCash happy you want to transfer the cost basis as well as
the securities to the new brokerage account.  By entering the transactions
as a sale at the same price that you purchased the the security and a new
purchase at that same price, you are transferring the cost basis, Since
that is not a real sale, there is no realized gain or loss to report to the
taxman until you really do sell

If you didn't transfer the cost, then GnuCash would think that the old
account still had a cost for a now non-existent asset and the new account
got the security free.  You may have to provide that same information to
your broker or custodian if they didn't get it automatically.



On Wed, Jul 5, 2023 at 3:31 PM AC  wrote:


Answering two at once:

Fred: No I did not work in split view. I was just working at the single
account level.

David: Are you saying I need to instruct GnuCash to treat the transfer
as a sale even though there was no sale thus no realized gains/losses
and no actual change in the cost basis?

On 2023-07-05 10:07, David Carlson wrote:

AC,

Fred implied, but didn't elaborate on the point that the shares in the
original brokerage account had a cost basis that was incurred when they
were purchased.  When you transfer them out, that is equivalent to a sale
or closing transaction, and the cost basis should be adjusted

accordingly,

even though there were no funds involved.  Of course, that exact cost

basis

needs to be added to the receiving account as if the shares were

purchased

at the original price.  This used to be described in great detail in one

of

the help manuals, including the somewhat tricky procedure to enter

realized

gains when an actual sale happens but I haven't checked lately to see if
those parts are still there.  I know that if you do not do those things

and

later run a trial balance or if you use the Investment Portfolio report,
you will quickly see the error of your ways.



On Wed, Jul 5, 2023 at 11:33 AM Fred Bone  wrote:


On 04 July 2023 at 16:29, AC said:


I recently moved some mutual funds from one brokerage to another. The
process did not involve a sale, it was just a transfer of control from

the

old to the new.

In my current books I keep mutual funds listed as subaccount under each
brokerage as such with their respective security/currency:

Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 2 (currency)
--Fund A (security A)
--Fund C (security C)
--Fund D (security D)

I wanted to expand this to add the new brokerage and then perform a
transfer of the funds from one to the other. Let's assume I moved the
funds under Brokerage 1 to Brokerage 3. So the tree would look like the
simplified version below (leaving out Brokerage 2 as it is unaffected):

Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 3 (currency)
--Fund A (security A)
--Fund B (security B)

The securities are the same because it's the same original mutual

funds,

just moved to another brokerage. The tree would be left intact with the
funds under Brokerage 1 being zeroed out and the funds under Brokerage

3

starting off with the incoming values.

My natural tendency was to create a transfer directly within Brokerage

1

Fund A that moved all the shares over to Brokerage 3 Fund A but that
didn't create the transaction I expected.

By example, I transferred Fund A on July 1 which contained 10 shares at
the price of the shares on that day. So in Brokerage 1 I entered -10
shares with a total sell price of X as listed on the statement from
Brokerage 1. The price is autocalculated and the balance correctly goes

to

zero.

Looking inside the Brokerage 3 Fund A account I only see a transaction
that has an amount in the buy column but no shares and a balance of

zero.

I can manually enter the same number of shares in that partially empty
transaction but why was my thought about the transfer incorrect? Should

it

have not transferred those shares over as well?


Did you work in split view?

I can replicate what I think you are saying if I don't enter the

separate

splits.

If I go about it the obvious way (in split view) and enter balan

Re: [GNC] Unable to get TIAA-CREF price quotes

[Ken Farley]

I don't know if this ever worked for you, but when I run it with the 
verbose flag "-v", I get the following:


 [ Begin try with gnc-fq-dump ] 

CMD> ./gnc-fq-dump -v tiaacref QCBMPX
Finance::Quote fields Gnucash uses:
    symbol: QCBMPX (deduced)    <=== required
  date: ** missing **    <=== recommended
  currency: ** missing **    <=== required
  last: **missing**  <=\
   nav: **missing**  <=== one of these
 price: **missing**  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!


All fields returned by Finance::Quote for stock QCBMPX

stock   field  value
-   -  -
QCBMPX  errormsg: Failed to fetch session key from TIAA site. Please 
contact the developers for further assistance.

QCBMPX  last: **missing**
QCBMPX   nav: **missing**
QCBMPX price: **missing**
QCBMPX   success: 0


 [ End try ] 


Perhaps the behavior of the TIAA-CREF site has changed? Have you been 
able to obtain quotes in the past?

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Unable to get TIAA-CREF price quotes

[doug brown via gnucash-user]

Linux Mint v. 20. GNUCASH v. 4.2Finance::Quote v. 1.56
When I update the price Data Base it fails to retrieve TIAA-CREF quotes.
The Security Editor is set up as follows:

Running gnc-fq-dump gives the following result:
doug@sager:~/src/gnucash-5.1$ gnc-fq-dump tiaacref QCBMPXFinance::Quote fields 
Gnucash uses:    symbol: QCBMPX (deduced)     <=== required      date: ** 
missing **        <=== recommended  currency: ** missing **        <=== 
required      last: **missing**          <=\              nav: **missing**      
    <=== one of these     price: **missing**          <=/          timezone:    
                  <=== optional
** This stock quote cannot be used by GnuCash!
Any thoughts?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Transferring mutual funds

[David Carlson]

AC,

Yes, to keep GnuCash happy you want to transfer the cost basis as well as
the securities to the new brokerage account.  By entering the transactions
as a sale at the same price that you purchased the the security and a new
purchase at that same price, you are transferring the cost basis, Since
that is not a real sale, there is no realized gain or loss to report to the
taxman until you really do sell

If you didn't transfer the cost, then GnuCash would think that the old
account still had a cost for a now non-existent asset and the new account
got the security free.  You may have to provide that same information to
your broker or custodian if they didn't get it automatically.



On Wed, Jul 5, 2023 at 3:31 PM AC  wrote:

> Answering two at once:
>
> Fred: No I did not work in split view. I was just working at the single
> account level.
>
> David: Are you saying I need to instruct GnuCash to treat the transfer
> as a sale even though there was no sale thus no realized gains/losses
> and no actual change in the cost basis?
>
> On 2023-07-05 10:07, David Carlson wrote:
> > AC,
> >
> > Fred implied, but didn't elaborate on the point that the shares in the
> > original brokerage account had a cost basis that was incurred when they
> > were purchased.  When you transfer them out, that is equivalent to a sale
> > or closing transaction, and the cost basis should be adjusted
> accordingly,
> > even though there were no funds involved.  Of course, that exact cost
> basis
> > needs to be added to the receiving account as if the shares were
> purchased
> > at the original price.  This used to be described in great detail in one
> of
> > the help manuals, including the somewhat tricky procedure to enter
> realized
> > gains when an actual sale happens but I haven't checked lately to see if
> > those parts are still there.  I know that if you do not do those things
> and
> > later run a trial balance or if you use the Investment Portfolio report,
> > you will quickly see the error of your ways.
> >
> >
> >
> > On Wed, Jul 5, 2023 at 11:33 AM Fred Bone  wrote:
> >
> >> On 04 July 2023 at 16:29, AC said:
> >>
> >>> I recently moved some mutual funds from one brokerage to another. The
> >>> process did not involve a sale, it was just a transfer of control from
> >> the
> >>> old to the new.
> >>>
> >>> In my current books I keep mutual funds listed as subaccount under each
> >>> brokerage as such with their respective security/currency:
> >>>
> >>> Investments
> >>> -Brokerage 1 (currency)
> >>> --Fund A (security A)
> >>> --Fund B (security B)
> >>> -Brokerage 2 (currency)
> >>> --Fund A (security A)
> >>> --Fund C (security C)
> >>> --Fund D (security D)
> >>>
> >>> I wanted to expand this to add the new brokerage and then perform a
> >>> transfer of the funds from one to the other. Let's assume I moved the
> >>> funds under Brokerage 1 to Brokerage 3. So the tree would look like the
> >>> simplified version below (leaving out Brokerage 2 as it is unaffected):
> >>>
> >>> Investments
> >>> -Brokerage 1 (currency)
> >>> --Fund A (security A)
> >>> --Fund B (security B)
> >>> -Brokerage 3 (currency)
> >>> --Fund A (security A)
> >>> --Fund B (security B)
> >>>
> >>> The securities are the same because it's the same original mutual
> funds,
> >>> just moved to another brokerage. The tree would be left intact with the
> >>> funds under Brokerage 1 being zeroed out and the funds under Brokerage
> 3
> >>> starting off with the incoming values.
> >>>
> >>> My natural tendency was to create a transfer directly within Brokerage
> 1
> >>> Fund A that moved all the shares over to Brokerage 3 Fund A but that
> >>> didn't create the transaction I expected.
> >>>
> >>> By example, I transferred Fund A on July 1 which contained 10 shares at
> >>> the price of the shares on that day. So in Brokerage 1 I entered -10
> >>> shares with a total sell price of X as listed on the statement from
> >>> Brokerage 1. The price is autocalculated and the balance correctly goes
> >> to
> >>> zero.
> >>>
> >>> Looking inside the Brokerage 3 Fund A account I only see a transaction
> >>> that has an amount in the buy column but no shares and a balance of
> zero.
> >>> I can manually enter the same number of shares in that partially empty
> >>> transaction but why was my thought about the transfer incorrect? Should
> >> it
> >>> have not transferred those shares over as well?
> >>
> >> Did you work in split view?
> >>
> >> I can replicate what I think you are saying if I don't enter the
> separate
> >> splits.
> >>
> >> If I go about it the obvious way (in split view) and enter balancing
> >> amounts then it all works.
> >>
> >> However, I'm still on 2.6.21 ...
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list 

Re: [GNC] Transferring mutual funds

[AC]

Answering two at once:

Fred: No I did not work in split view. I was just working at the single 
account level.


David: Are you saying I need to instruct GnuCash to treat the transfer 
as a sale even though there was no sale thus no realized gains/losses 
and no actual change in the cost basis?


On 2023-07-05 10:07, David Carlson wrote:

AC,

Fred implied, but didn't elaborate on the point that the shares in the
original brokerage account had a cost basis that was incurred when they
were purchased.  When you transfer them out, that is equivalent to a sale
or closing transaction, and the cost basis should be adjusted accordingly,
even though there were no funds involved.  Of course, that exact cost basis
needs to be added to the receiving account as if the shares were purchased
at the original price.  This used to be described in great detail in one of
the help manuals, including the somewhat tricky procedure to enter realized
gains when an actual sale happens but I haven't checked lately to see if
those parts are still there.  I know that if you do not do those things and
later run a trial balance or if you use the Investment Portfolio report,
you will quickly see the error of your ways.



On Wed, Jul 5, 2023 at 11:33 AM Fred Bone  wrote:


On 04 July 2023 at 16:29, AC said:


I recently moved some mutual funds from one brokerage to another. The
process did not involve a sale, it was just a transfer of control from

the

old to the new.

In my current books I keep mutual funds listed as subaccount under each
brokerage as such with their respective security/currency:

Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 2 (currency)
--Fund A (security A)
--Fund C (security C)
--Fund D (security D)

I wanted to expand this to add the new brokerage and then perform a
transfer of the funds from one to the other. Let's assume I moved the
funds under Brokerage 1 to Brokerage 3. So the tree would look like the
simplified version below (leaving out Brokerage 2 as it is unaffected):

Investments
-Brokerage 1 (currency)
--Fund A (security A)
--Fund B (security B)
-Brokerage 3 (currency)
--Fund A (security A)
--Fund B (security B)

The securities are the same because it's the same original mutual funds,
just moved to another brokerage. The tree would be left intact with the
funds under Brokerage 1 being zeroed out and the funds under Brokerage 3
starting off with the incoming values.

My natural tendency was to create a transfer directly within Brokerage 1
Fund A that moved all the shares over to Brokerage 3 Fund A but that
didn't create the transaction I expected.

By example, I transferred Fund A on July 1 which contained 10 shares at
the price of the shares on that day. So in Brokerage 1 I entered -10
shares with a total sell price of X as listed on the statement from
Brokerage 1. The price is autocalculated and the balance correctly goes

to

zero.

Looking inside the Brokerage 3 Fund A account I only see a transaction
that has an amount in the buy column but no shares and a balance of zero.
I can manually enter the same number of shares in that partially empty
transaction but why was my thought about the transfer incorrect? Should

it

have not transferred those shares over as well?


Did you work in split view?

I can replicate what I think you are saying if I don't enter the separate
splits.

If I go about it the obvious way (in split view) and enter balancing
amounts then it all works.

However, I'm still on 2.6.21 ...

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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
To update your subscription preferences or to unsubscribe:
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: [GNC] Transferring mutual funds

[David Carlson]

AC,

Fred implied, but didn't elaborate on the point that the shares in the
original brokerage account had a cost basis that was incurred when they
were purchased.  When you transfer them out, that is equivalent to a sale
or closing transaction, and the cost basis should be adjusted accordingly,
even though there were no funds involved.  Of course, that exact cost basis
needs to be added to the receiving account as if the shares were purchased
at the original price.  This used to be described in great detail in one of
the help manuals, including the somewhat tricky procedure to enter realized
gains when an actual sale happens but I haven't checked lately to see if
those parts are still there.  I know that if you do not do those things and
later run a trial balance or if you use the Investment Portfolio report,
you will quickly see the error of your ways.



On Wed, Jul 5, 2023 at 11:33 AM Fred Bone  wrote:

> On 04 July 2023 at 16:29, AC said:
>
> > I recently moved some mutual funds from one brokerage to another. The
> > process did not involve a sale, it was just a transfer of control from
> the
> > old to the new.
> >
> > In my current books I keep mutual funds listed as subaccount under each
> > brokerage as such with their respective security/currency:
> >
> > Investments
> > -Brokerage 1 (currency)
> > --Fund A (security A)
> > --Fund B (security B)
> > -Brokerage 2 (currency)
> > --Fund A (security A)
> > --Fund C (security C)
> > --Fund D (security D)
> >
> > I wanted to expand this to add the new brokerage and then perform a
> > transfer of the funds from one to the other. Let's assume I moved the
> > funds under Brokerage 1 to Brokerage 3. So the tree would look like the
> > simplified version below (leaving out Brokerage 2 as it is unaffected):
> >
> > Investments
> > -Brokerage 1 (currency)
> > --Fund A (security A)
> > --Fund B (security B)
> > -Brokerage 3 (currency)
> > --Fund A (security A)
> > --Fund B (security B)
> >
> > The securities are the same because it's the same original mutual funds,
> > just moved to another brokerage. The tree would be left intact with the
> > funds under Brokerage 1 being zeroed out and the funds under Brokerage 3
> > starting off with the incoming values.
> >
> > My natural tendency was to create a transfer directly within Brokerage 1
> > Fund A that moved all the shares over to Brokerage 3 Fund A but that
> > didn't create the transaction I expected.
> >
> > By example, I transferred Fund A on July 1 which contained 10 shares at
> > the price of the shares on that day. So in Brokerage 1 I entered -10
> > shares with a total sell price of X as listed on the statement from
> > Brokerage 1. The price is autocalculated and the balance correctly goes
> to
> > zero.
> >
> > Looking inside the Brokerage 3 Fund A account I only see a transaction
> > that has an amount in the buy column but no shares and a balance of zero.
> > I can manually enter the same number of shares in that partially empty
> > transaction but why was my thought about the transfer incorrect? Should
> it
> > have not transferred those shares over as well?
>
> Did you work in split view?
>
> I can replicate what I think you are saying if I don't enter the separate
> splits.
>
> If I go about it the obvious way (in split view) and enter balancing
> amounts then it all works.
>
> However, I'm still on 2.6.21 ...
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Importing data from QuickBooks Online

[Tom Olin via gnucash-user]

I’ve posted my script here:

https://gist.github.com/trolin522581/cd9b8d684b0f9e0c8aed8876b256e31e

I’ll leave the wiki link to someone else.

--
Tom

For the government, which came first? (a) first $ taxed; (b) first $ borrowed; 
(c) first $ spent. (Hint: state or federal?)

> On Jul 4, 2023, at 8:31 PM, Vincent Dawans  wrote:
> 
> May I suggest also posting this in the FAQ section on the wiki, there is a 
> section that mentions Quickbooks import.
> See here: 
> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_... 
> 
> 
> You could put your file in a github gist for easy sharing. Then link from the 
> FAQ. There is already a link there for some other script from Linux Weekly 
> News but I haven't checked what that looks like.
> 
> On Tue, Jul 4, 2023 at 3:44 PM Tom Olin  > wrote:
> Here’s the final version (for now) of my script. I hope someone else finds it 
> useful.
> 
> Thanks to all who responded to my query with suggestions.
> 
> --
> Tom
> 
> Federal taxes can be paid with dollars, but the dollars have to be created 
> (spent) by the government before anyone has dollars with which to pay their 
> taxes.
> 
>> On Jul 4, 2023, at 8:00 AM, Tom Olin via gnucash-user 
>> mailto:gnucash-user@gnucash.org>> wrote:
>> 
>> Vincent,
>> 
>> Thanks so much for figuring this out! If you don’t mind, I’d like to give 
>> you credit in my file.
>> 
>> I’m going to rerun the entire dataset as a final test. I will repost the 
>> final version of the script here for anyone else looking to do this.
>> 
>> Thanks, again!
>> 
>> --
>> Tom
>> 
>> Federal spending funds taxes. It is impossible to pay taxes until the 
>> government has spent money into the economy.
>> 
>>> On Jul 3, 2023, at 10:37 PM, Vincent Dawans >> > wrote:
>>> 
>>> Tom:
>>> 
>>> I tested both files and it seems that it fails on the reconcile column for 
>>> 2022. When I skip the reconcile column it works. 2022 has Y entries in that 
>>> column while 2023 doesn't, and when I replace the 2022 Y entries with c it 
>>> works. So it seems to be related to either the inability to import 
>>> reconciled flag or the flag is different, I am not sure. But that's where 
>>> the problem is, something to do with the Y reconcile flag.
>>> 
>>> Sincerely,
>>> 
>>> Vincent Dawans
>>> 
>>> On Mon, Jul 3, 2023 at 4:41 PM Tom Olin >>  >> >> wrote:
>>> Vincent,
>>> 
>>> Good suggestions. I’ve attached 2 files, 3 transactions each, for 2022 and 
>>> 2023. Instructions for importing them are in the documentation of the 
>>> script, latest version also attached.
>>> 
>>> 2022 still fails, 2023 still works. Create the accounts as needed; there 
>>> are only a few.
>>> 
>>> --
>>> Tom
>>> 
>>> Money is created when banks loan and when the federal government spends. 
>>> The latter increases someone’s net worth. The former does not, but the 
>>> interest and fees transfer net worth from the borrower to the lender.
>>> 
 On Jul 3, 2023, at 6:44 PM, Vincent Dawans >>>  >> wrote:
 
 Tom:
 
 I haven't read every single email in this thread but have this advice for 
 you to further diagnose. When I face a puzzle like this, I like to try 
 creating the simplest possible scenario in which I am still able to 
 reproduce the problem. In this case this would start by figuring out how 
 far you can pare down your 2022 csv file while still having the problem. 
 Can you pair it down to just a few transactions, like 5 or 10 max?  Can 
 you then change some of that data in that pared down file and still have 
 the problem? By simplifying you can often more easily find the source of 
 the problem and also might be able to share your csv file when it reaches 
 the point where the data in it is no longer personal.
 
 Sincerely,
 
 Vincent Dawans
 
 On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user 
 mailto:gnucash-user@gnucash.org> 
 >> wrote:
 I would add that I’m more inclined to attribute the problem to GnuCash 
 logic. However, the code will require a lot of study on my part before I 
 can make meaningful sense of it. I just wish I could think of some 
 possible logic that might explain it.
 
 --
 Tom
 
 Money is created out of thin air when banks loan and when the federal 
 government spends. Money is destroyed into thin air when bank loans are 
 repaid and when federal taxes are paid.
 
> On Jul 3, 2023, at 5:41 PM, Ken Pyzik    >> wrote:
> 
> Tom -- I believe at the beginning of 20

Re: [GNC] Transferring mutual funds

[Fred Bone]

On 04 July 2023 at 16:29, AC said:

> I recently moved some mutual funds from one brokerage to another. The
> process did not involve a sale, it was just a transfer of control from the
> old to the new.
> 
> In my current books I keep mutual funds listed as subaccount under each
> brokerage as such with their respective security/currency:
> 
> Investments
> -Brokerage 1 (currency)
> --Fund A (security A)
> --Fund B (security B)
> -Brokerage 2 (currency)
> --Fund A (security A)
> --Fund C (security C)
> --Fund D (security D)
> 
> I wanted to expand this to add the new brokerage and then perform a 
> transfer of the funds from one to the other. Let's assume I moved the
> funds under Brokerage 1 to Brokerage 3. So the tree would look like the
> simplified version below (leaving out Brokerage 2 as it is unaffected):
> 
> Investments
> -Brokerage 1 (currency)
> --Fund A (security A)
> --Fund B (security B)
> -Brokerage 3 (currency)
> --Fund A (security A)
> --Fund B (security B)
> 
> The securities are the same because it's the same original mutual funds,
> just moved to another brokerage. The tree would be left intact with the
> funds under Brokerage 1 being zeroed out and the funds under Brokerage 3
> starting off with the incoming values.
> 
> My natural tendency was to create a transfer directly within Brokerage 1
> Fund A that moved all the shares over to Brokerage 3 Fund A but that
> didn't create the transaction I expected.
> 
> By example, I transferred Fund A on July 1 which contained 10 shares at
> the price of the shares on that day. So in Brokerage 1 I entered -10
> shares with a total sell price of X as listed on the statement from
> Brokerage 1. The price is autocalculated and the balance correctly goes to
> zero.
> 
> Looking inside the Brokerage 3 Fund A account I only see a transaction
> that has an amount in the buy column but no shares and a balance of zero.
> I can manually enter the same number of shares in that partially empty
> transaction but why was my thought about the transfer incorrect? Should it
> have not transferred those shares over as well?

Did you work in split view?

I can replicate what I think you are saying if I don't enter the separate 
splits.

If I go about it the obvious way (in split view) and enter balancing 
amounts then it all works.

However, I'm still on 2.6.21 ...

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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: [GNC] Finance-Quote 1.57 released!

[Bruce Schuck]

On 7/4/23 23:22:09 +, Richard Ullger wrote:

When prices are updated after midnight, the yahooweb price source is
returning the current date instead of the price date. See below...

On 7/4/23 22:35 -0400, Ken Farley replied:


My understanding of the new Yahooweb module is that it uses the 
current date when reporting prices. I believe this is because the 
data source from which the quote is built does not provide a "quote

date" or that sort of information. Therefore, the author of the new
module had to do something to satisfy the requirements of Gnucash,
so they chose to use today's date. It does, judging from the Perl
code, make adjustments if the date returned is not a "work day",
but doesn't do any other sort of "date correction".


Thank you for that explanation, since I receive GnuCash-user in digest
form I did not see Richard's email until receiving the digest.

Yes, I believe I may have posted this caveat of the YahooWeb module in
the last week or so. It is also noted in the POD documentation of the
module (although I misspelled caveat).

"Yahoo cleverly obscures the trade date using JavaScript. Because of 
this the module uses the current date, but accounts for weekends."


I have been investigating the use of the Date::Business module, but that 
would require regular maintenance of keeping holidays for multiple 
exchanges updated.


But, the YahooWeb module is intended as an emergency module if Yahoo 
pulls the plug on access to the API used in the YahooJSON module.


Bruce S.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.