Re: [GNC-dev] old online Quotes
Daily prices for a long period of time can increase the size of a file pretty significantly. I don't recall what my own results were when I pruned my price db and replaced it with monthly numbers, but I do remember a dip in size. Whether that size affects anything in regular use is another thing altogether. Original Message From: Chris Good Sent: Sun Oct 31 16:32:06 EDT 2021 To: gnucash-devel@gnucash.org Subject: Re: [GNC-dev] old online Quotes Hi Snehal, Possibly adding daily prices for 7 years would have an unwanted effect on the size of the database or the performance… Perhaps monthly may be all that is required, or only add those prices to a one-off database? Regards, Chris Good > Message: 3 > Date: Sat, 30 Oct 2021 23:07:51 -0400 > From: "D." > To: John Ralls > Cc: Snehal Bhavsar ,gnucash-devel@gnucash.org > Subject: Re: [GNC-dev] old online Quotes > Message-ID: <2b063c73-b360-44ec-8332-9357c33cd...@yahoo.com> > Content-Type: text/plain; charset=UTF-8 > > There are a few external projects that do this as well, although they are at > this point rather dated, and may not work in the current environment. There > is something on the wiki about these. > > > Original Message > From: John Ralls > Sent: Sat Oct 30 16:10:56 EDT 2021 > To: Snehal Bhavsar > Cc: gnucash-devel@gnucash.org > Subject: Re: [GNC-dev] old online Quotes > > > >> On Oct 30, 2021, at 12:18 PM, Snehal Bhavsar wrote: >> >> hi All, >> >> I have been using GnuCash for the last 7 years... and started using Online >> Fund get Quotes from the last 1-2 years... >> >> Get Quotes gets the latest file.. is there a way to get old quotes. >> >> I would like to bring all the daily fund prices for all my funds for the >> last 7 years for use in a report.. > > Not directly. You can get historical prices from yahoo or alpha vantage as a > CSV and then import it into GnuCash with File>Import>Import Prices From a CSV > File. > > Regards, > John Ralls ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] old online Quotes
Hi Snehal, Possibly adding daily prices for 7 years would have an unwanted effect on the size of the database or the performance… Perhaps monthly may be all that is required, or only add those prices to a one-off database? Regards, Chris Good > Message: 3 > Date: Sat, 30 Oct 2021 23:07:51 -0400 > From: "D." > To: John Ralls > Cc: Snehal Bhavsar ,gnucash-devel@gnucash.org > Subject: Re: [GNC-dev] old online Quotes > Message-ID: <2b063c73-b360-44ec-8332-9357c33cd...@yahoo.com> > Content-Type: text/plain; charset=UTF-8 > > There are a few external projects that do this as well, although they are at > this point rather dated, and may not work in the current environment. There > is something on the wiki about these. > > > Original Message > From: John Ralls > Sent: Sat Oct 30 16:10:56 EDT 2021 > To: Snehal Bhavsar > Cc: gnucash-devel@gnucash.org > Subject: Re: [GNC-dev] old online Quotes > > > >> On Oct 30, 2021, at 12:18 PM, Snehal Bhavsar wrote: >> >> hi All, >> >> I have been using GnuCash for the last 7 years... and started using Online >> Fund get Quotes from the last 1-2 years... >> >> Get Quotes gets the latest file.. is there a way to get old quotes. >> >> I would like to bring all the daily fund prices for all my funds for the >> last 7 years for use in a report.. > > Not directly. You can get historical prices from yahoo or alpha vantage as a > CSV and then import it into GnuCash with File>Import>Import Prices From a CSV > File. > > Regards, > John Ralls ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] old online Quotes
There are a few external projects that do this as well, although they are at this point rather dated, and may not work in the current environment. There is something on the wiki about these. Original Message From: John Ralls Sent: Sat Oct 30 16:10:56 EDT 2021 To: Snehal Bhavsar Cc: gnucash-devel@gnucash.org Subject: Re: [GNC-dev] old online Quotes > On Oct 30, 2021, at 12:18 PM, Snehal Bhavsar wrote: > > hi All, > > I have been using GnuCash for the last 7 years... and started using Online > Fund get Quotes from the last 1-2 years... > > Get Quotes gets the latest file.. is there a way to get old quotes. > > I would like to bring all the daily fund prices for all my funds for the > last 7 years for use in a report.. Not directly. You can get historical prices from yahoo or alpha vantage as a CSV and then import it into GnuCash with File>Import>Import Prices From a CSV File. Regards, John Ralls ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] old online Quotes
> On Oct 30, 2021, at 12:18 PM, Snehal Bhavsar wrote: > > hi All, > > I have been using GnuCash for the last 7 years... and started using Online > Fund get Quotes from the last 1-2 years... > > Get Quotes gets the latest file.. is there a way to get old quotes. > > I would like to bring all the daily fund prices for all my funds for the > last 7 years for use in a report.. Not directly. You can get historical prices from yahoo or alpha vantage as a CSV and then import it into GnuCash with File>Import>Import Prices From a CSV File. Regards, John Ralls ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
[GNC-dev] old online Quotes
hi All, I have been using GnuCash for the last 7 years... and started using Online Fund get Quotes from the last 1-2 years... Get Quotes gets the latest file.. is there a way to get old quotes. I would like to bring all the daily fund prices for all my funds for the last 7 years for use in a report.. thank you, Snehal ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel