David - good idea!
Elmar - please see updated SQL here:
https://wiki.gnucash.org/wiki/PostgreSQL-Requests_For_Direct_Database_Access#Extract_prices_and_associated_descriptions
Thanks
Geoff
=
On 16/10/2022 5:50 pm, David T. wrote:
Geoff,
Good advice/help! I do think it would be necessary
Geoff,
Good advice/help! I do think it would be necessary to add the currency to the
result, to inform the resulting prices.
David T.
On Oct 16, 2022, 4:38 AM, at 4:38 AM, Geoff wrote:
>Hi Elmar
>
>To elaborate on John's reply, this SQL statement should do the trick:
>
>
>select
Thank you. This will be a new experience for me - I have never even
looked at SQL, much less have any facility with it. All the included
reports don't touch the price database itself, and I don't know how to
create an appropriate one from the menu in GC. Off to look at the wiki
:) Probably
Thank you, but how I have my investments labeled make sense to me, and
not to any online databases. I personally enter the quarterly (or
monthly) prices that the statements give me (some of which are not
tracked by, say, finance:quote), so conventional tools are really
useless for me. It's
Saludos Cordiales
Murugan
From: gnucash-user
on behalf of john
Sent: Saturday, October 15, 2022 2:40 PM
To: Elmar
Cc: Gnucash Users
Subject: Re: [GNC] Price database
The easiest would be to save your book to SQLite3: File>Save As..., pick
Sqlite3 from the drop-do
The easiest would be to save your book to SQLite3: File>Save As..., pick
Sqlite3 from the drop-down at the top of the dialog, pick a file name and
location.
Then run a query on the prices table (see
https://wiki.gnucash.org/wiki/SQL#Prices for the schema; you may want to join
on commodities to
Thanks, John.
On 6/17/20 7:27 PM, John Ralls wrote:
$ bin/gnc-fq-dump currency HKD USD
1 HKD = 0.12903193 USD
Regards,
John Ralls
On Jun 17, 2020, at 11:15 AM, Les wrote:
Thanks for your reply. However, the problem is I have a Hong Kong bank account
that has multiple currencies. The
$ bin/gnc-fq-dump currency HKD USD
1 HKD = 0.12903193 USD
Regards,
John Ralls
> On Jun 17, 2020, at 11:15 AM, Les wrote:
>
> Thanks for your reply. However, the problem is I have a Hong Kong bank
> account that has multiple currencies. The default is HKD, but I need Price
> Database to
Thanks for your reply. However, the problem is I have a Hong Kong bank
account that has multiple currencies. The default is HKD, but I need
Price Database to reflect the USD amount for tax reporting.
(I hope I am stating this correctly.) :)
Les
On 6/16/20 7:59 PM, Chris Good wrote:
Message: 6
Date: Tue, 16 Jun 2020 17:04:09 -0500
From: Les
To: gnucash-user@gnucash.org
Subject: [GNC] Price Database
Message-ID:
Content-Type: text/plain; charset=utf-8; format=flowed
Hi All:
For at least 2 weeks, I have been unable to obtain a quote for HKD (Hong
Kong dollar).
Is anyone
I cannot comment on why that doesn't work in release 3.7 but it sure is a
handy feature in the 2.6 series that is new to me. I hope it will get
fixed.
David Carlson
On Tue, Dec 3, 2019, 10:45 AM George Riner wrote:
> I'm on Windows 10, build 1903
> running Build ID: 3.7+(2019-09-07)
>
11 matches
Mail list logo
