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
Asking again - is there any way to get the accumulated data copied from
the price database into a spreadsheet?
- Elmar
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
. 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
> 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
&g
:
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 else having
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
Hi All:
For at least 2 weeks, I have been unable to obtain a quote for HKD (Hong
Kong dollar).
Is anyone else having this problem? Any suggestions?
Thanks,
Les
Linux Mint 19.3 GC 3.10 (Flatpak)
___
gnucash-user mailing list
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)
>
I'm on Windows 10, build 1903
running Build ID: 3.7+(2019-09-07)
Finance::Quote: 1.47 (I don't use the downloading of prices)
I'm manually entering prices in the Price Database. Apparently, the tab
order of the fields skips over the field value and will only land on the
down arrow to the
14 matches
Mail list logo