Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread Mike Alexander
On 22 Jan 2021, at 20:10, John Ralls wrote: To answer your earlier question, no, F::Q doesn't work for me either on my DTK. I hadn't actually even tried to install it. It took two passes through sudo gnc-fq-update to get a good install so that I could run gnc-fq-check successfully from

Re: [GNC] Representing fund restructure in Gnucash

2021-01-22 Thread Peter Lamb via gnucash-user
Thanks to all who've replied. I've followed Geoff's advice here and it's done exactly what I was trying to do. Robin, thanks for the note about the bogus price in the price database. I'd noticed the same in my earlier attempts to do this. I've cleaned up the bogus price, and the new stocks

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread John Ralls
Justin, To answer your earlier question, no, F::Q doesn't work for me either on my DTK. I hadn't actually even tried to install it. It took two passes through sudo gnc-fq-update to get a good install so that I could run gnc-fq-check successfully from terminal. I've been sticking print

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread Justin via gnucash-user
So... it doesn't actually work quite yet, but GnuCash does recognize it.  Attempting to get quotes via the GnuCash-cli program results in a "unable to retrieve quotes for these items" message, followed by all of my securities. The following will not work. It shows a bunch of missing dependency

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread Justin via gnucash-user
Woo. I've made progress. So I manually installed the latest F::Q from there GitHub release (following their instructions): https://github.com/finance-quote/finance-quote/releases/tag/v1.50-rc.1 This fixes the issue with running "perl -w gnc-fq-check" (and prints F::Q v1.50) that I mentioned in

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread Justin via gnucash-user
Alright. I think I might have found part of the issue.  According to this line in GnuCash source, gnc-fq-check is run as an argument to perl: https://github.com/Gnucash/gnucash/blob/maint/gnucash/price-quotes.scm#L47 So I tried that out and it says F::Q is not installed. > $ perl -w

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread Justin via gnucash-user
John, sorry I forgot to check if launching GnuCash from the terminal makes a difference. F::Q does not work if I run GnuCash from the terminal. Good idea though. ‐‐‐ Original Message ‐‐‐ On Friday, January 22nd, 2021 at 4:38 PM, David H wrote: > I think that's what John meant in the

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread David H
I think that's what John meant in the second message he posted in this thread re running under Rosetta2 . >> BigSur absolutely is supported. What's not yet available yet is a native build for Apple Silicon, but I've found so far that the Intel build of GnuCash works fine with Rosetta2. >>

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread Chris Graves
John Ralls, have you had success running F::Q on an M1 Mac (I seem to recall that you had a dev kit)? > On Jan 22, 2021, at 1:11 PM, Justin wrote: > > Chris, this did not fix my issue. > > ‐‐‐ Original Message ‐‐‐ > > On Friday, January 22nd, 2021 at 9:17 AM, Chris Graves > wrote:

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread Justin via gnucash-user
Chris, this did not fix my issue. ‐‐‐ Original Message ‐‐‐ On Friday, January 22nd, 2021 at 9:17 AM, Chris Graves wrote: > I reinstalled (on my Intel Mac) by running: > > /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update > > > On Jan 21, 2021, at 5:43 PM, Justin

Re: [GNC] Import CSV: save settings doesn't save

2021-01-22 Thread Marcus Winston
>>> the next time you run the csv import assistant the name you typed in should be present... That's the problem: the name I typed in doesn't show up. That's what I mean by "nothing happens". -marcus On Fri, Jan 22, 2021 at 8:19 AM John Ralls wrote: > > > > On Jan 22, 2021, at 7:26 AM, Marcus

[GNC] Import CSV: save settings doesn't save

2021-01-22 Thread Marcus Winston
Hello, I'm using GnuCash 3.6 on Linux. Trying to get CSV import working a bit "faster". I see the "Save Settings" (https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-csv-save). Unfortunately for me, saving settings doesn't work. I type in a name, click the

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread Chris Graves
I reinstalled (on my Intel Mac) by running: /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update > On Jan 21, 2021, at 5:43 PM, Justin wrote: > > Hello all, thank you for replying. I'm new to this email list. > > Dave, I do have an M1 Mac. Maybe that's part of the problem. > >

Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"

2021-01-22 Thread Chris Graves
Intel > On Jan 21, 2021, at 5:05 PM, davel...@mac.com wrote: > > Chris, do you have an M1 or Intel Mac? > >> On Jan 21, 2021, at 6:02 PM, Chris Graves wrote: >> >> Just another point of information, I had the same issue, but it was resolved >> after reinstalling F::Q as John mentions below.

Re: [GNC] Representing fund restructure in Gnucash

2021-01-22 Thread D. via gnucash-user
For what it's worth, users should also know that this method establishes a new date of acquisition for the shares, which may affect short term versus long term capital gains calculations if the user isn't careful. Original Message From: Robin Chattopadhyay Sent: Fri Jan 22

Re: [GNC] Switching to trading accounts in existing database

2021-01-22 Thread Christoph R
Hi Mike, Lukas, I am using trading accounts since multiple years and can confirm that the UI can be pretty cumbersome. I got used to it. Besides the regular problems in getting the transactions straight it works pretty well Cheers, Christoph > Am 22.01.2021 um 06:13 schrieb Mike Alexander : >

Re: [GNC] Representing fund restructure in Gnucash

2021-01-22 Thread Robin Chattopadhyay
Hi Peter- This is also how I have done similar transactions (and in-kind transfers to a new broker). One thing to note is that this method will also create a new price record in the price database. So I also go into the price editor and remove that extra, invalid price. On Fri, Jan 22, 2021 at

Re: [GNC] Switching to trading accounts in existing database

2021-01-22 Thread Christopher Lam
Personally I'd stick with 1 book = 1 currency, and record all transactions in their home currency only. I'd only record the same transaction in both books if they're a formal currency transfer. A simple issue is balance sheet: if you hold stocks eg TSLA in your USD account, and ANA from your

Re: [GNC] Switching to trading accounts in existing database

2021-01-22 Thread Christopher Lam
The issue is when currency fluctuates, you have capital gains or losses, depending on whatever you consider to be your home currency. These gains/losses are unrecorded (but not unrealised). C On Fri, 22 Jan 2021 at 04:36, w...@theprescotts.com wrote: > I am probably missing something here. > >

Re: [GNC] Representing fund restructure in Gnucash

2021-01-22 Thread Christopher Lam
You could use the stock split assistant to record the stock split (cannot record stock split using the register only), then use the security editor to rename the stock. Someone else may have better ideas. On Fri, 22 Jan 2021, 3:59 pm Peter Lamb via gnucash-user, < gnucash-user@gnucash.org> wrote:

Re: [GNC] Representing fund restructure in Gnucash

2021-01-22 Thread Geoff
Hi Peter From what you have said, the new security will inherit the old security's cost base. So I would create a transaction to reduce the old one to zero and add the new quantity to the new one. Blank out the price and put in the cost base as the value - GnuCash will calculate the price.

[GNC] Representing fund restructure in Gnucash

2021-01-22 Thread Peter Lamb via gnucash-user
I own some Exchange Traded Fund stocks, and one of the stocks has been restructured: the stock I owned has been converted into another stock, so that 1 ABC share (the original stock) has been converted into N DEF shares. I have only been provided with the ratio of share values, not with