[GNC] NEw user assistance

Sat Jan 7 00:10:20 EST 2023

I would think that if your home currency is CAD and you buy some USD
stocks, you'd first transfer some cash from your CAD bank into your
brokerage account in USD, then immediately use the latter to purchase your
AAPL.

On Sat, 7 Jan 2023, 5:46 am Karl, <karlsawatzky419 at gmail.com> wrote:

> Hi there John,
>
> Thanks for the information. Very helpful! Perhaps I am setting up my
> foreign (USD) investment accounts all wrong. I'm trying to follow the
> instructions and examples in Chapters 9.5 and 9.6, but I can't
> reconcile the instructions with your explanation.
>
> So if I set-up the account structure as you described:
>
> Assets
> Investments
> Stocks
> Stocks-USD
> AAPL
>
>  ... when I go to make an initial purchase of AAPL shares/stock, do I enter
> the transaction in CAD or USD? For example, AAPL closed at $129.62 USD
> today, so if I bought 10 stocks, should my entry be:
>
> DR AAPL stock          1,296.20 (USD)
>       CR Cash                             1,296.20 (USD)
>
> or should it be:
>
> DR AALP stock          1,736.91 (CAD)
>       CR Cash                              1,736.91 (CAD)
>
> ???
>
> CAD-USD was at $1.00 USD = $1.34 CAD.
>
>
> Ideally, when I run the "Advanced Portfolio" Report, I would like for what
> I'm seeing to be in CAD. Is this possible?
>
> Thanks again for your help. As you can probably tell, I'm terrible with
> computers, but not too bad with accounting! haha
>
> Regards,
>
> *Karl*
>
>
> On Fri, 6 Jan 2023 at 13:12, john <jralls at ceridwen.us> wrote:
>
> > That's a very long-running discussion with another Canadian CPA, see
> > https://bugs.gnucash.org/show_bug.cgi?id=797796
> > and https://bugs.gnucash.org/show_bug.cgi?id=798004.
> >
> > The simplest workaround is to set up an account structure that looks like
> > Assets
> > Investments
> > Stocks
> > Stocks-USD
> > AAPL
> >
> > As long as you keep the priceDB updated with both CAD-USD exchange rates
> > and AAPL prices the Stocks account will show the value of the AAPL shares
> > in CAD. Unfortunately if you have several USD stocks and want to track
> them
> > individually you'd need to do something like
> > Stock-AAPL-CAD
> > Stock-AAPL-USD
> > AAPL
> > Stock-GOOG-CAD
> > Stock-GOOG-USD
> > GOOG
> >
> > Which could be a bit tiresome. An alternative is to set things up as you
> > would normally, i.e.
> > Assets
> > Investments
> > Cash
> > Stocks-USD
> > AAPL
> > GOOG
> >
> > and use the Advanced Portfolio Report to show the values in CAD.
> >
> > I don't understand what you mean by "the currency exchange function", but
> > if you want to retrieve the CAD-USD exchange rate you need to get an
> > Alphavantage API key. The issue in bug 798599 is resolved because
> > Alphavantage put currency exchange rates back to being available with a
> > free API key. F::Q version 1.53 switched to a different retrieval method
> > that broke retrieving precious metal rates (e.g. XAU-CAD) so if that's
> your
> > concern you need a F::Q version that isn't 1.53; the current release is
> > 1.54.
> >
> > Regards,
> > John Ralls
> >
> >
> > On Jan 6, 2023, at 6:05 AM, Karl <karlsawatzky419 at gmail.com> wrote:
> >
> > Hello David and everyone,
> >
> > Thank you for your messages. A little background about myself: I'm a
> > Canadian (born and raised), and a CPA. I have been using GnuCash for a
> > while now, but am interested in delving deeper into its functions that
> can
> > be useful to me. I use GnuCash only for personal and private use for my
> > household, not for business purposes in any way.
> >
> > I am currently running Microsoft Windows 10 Pro (Build 19045) on my main
> > machine at home, and am using GnuCash Version 4.10 with "Finance::Quote
> > 1.54" and perl (v5.32.1).
> >
> > I am enjoying the Chapter 9 - Investments part of GnuCash and have
> > successfully set up the Automatic Online Retrieval of Stock Quotes. What
> a
> > great function!
> >
> > The trouble is, I can't figure out a way to have any foreign investments
> > denominated in my local currency (CAD). For example, if I invest in,
> let's
> > say, Apple Inc (NASDAQ: AAPL), which is traded on the NASDAQ (a foreign
> > market for me), the share(s) value only shows up in the currency of the
> > market in which it is being traded (in this case, USD). How do I get
> > GnuCash to denominate and show me my foreign investments in my local
> > currency (CAD)?
> >
> > Not sure if this is related but, I also tried to set-up the currency
> > exchange function, but it appears that this is no longer functional due
> to
> > the API Key from Alphavantage. Is this true?
> > https://bugs.gnucash.org/show_bug.cgi?id=798599
> >
> > Thank you everyone. Happy to see that there is a supportive and
> > collaborative community here!
> >
> > Regards,
> >
> > *Karl*
> >
> >
> > On Thu, 5 Jan 2023 at 20:07, David H <hellvee at gmail.com> wrote:
> >
> > Welcome to gnucash Karl.
> >
> > I think from memory Nabble went away during the pandemic about 12 months
> > ago, so maybe forget that one :-)  If you have any questions, post them
> > here to the gnucash user list (gnucash-user at gnucash.org) and you'll get
> > all the help you need.  Also just a heads up do NOT use reply to reply to
> > individuals, use REPLY ALL so that everyone benefits and can contribute
> to
> > the question at hand.  Also if you subscribe to the digest version and
> > reply to something, update the subject to something meaningful don't just
> > leave it as "Digest ......." which is pretty meaningless and trim any
> > extraneous cruft out of the reply.
> >
> > Also it always helps to include what version of Gnucash you installed and
> > on what OS as things vary a little from Windows to Linux to MacOS - so
> lets
> > start there, which is it ?
> >
> > Cheers David H.
> >
> > ps don't forget that "Reply All". :-)
> >
> >
> > On Fri, 6 Jan 2023 at 11:31, Karl <karlsawatzky419 at gmail.com> wrote:
> >
> > Hello there!
> >
> > I am a new user to GnuCash and am looking for some assistance. I have
> > subscribed to the mailing list and am attempting to access the Web Forum
> > (Nabble) for further assistance from other users.
> >
> > Specifically, I am trying to set-up the online pricing list for stock
> > quotes.
> >
> > Please assist. Thank you for your assistance.
> >
> > Regards,
> >
> > *Karl*
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at 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 at 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 at 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.
>