David T,
Nice, but I am told pedagogy suggests even the best explanations are best
packaged with examples, like on a nice web page. In fact, the Finance Quote
process itself might be divided into three processes: a gnucash call to extract
the symbols and sources as a CSV, a web scraper process to convert the input
CSV to an output CSV, and a second gnucash call to accept that CSV and
update/insert the prices database. It might make testing simpler, too!
One wonders what the update versus insert policy is. Buy and sell transactions
create price info, often of low precision intraday pricing, as if you are
buying a 4 digit precise $98.76 stock for a $1.23 dividend, the apparent price
might be $99.19 for 0.0124 shares. If there are multiple entries for a symbol
and date, one must win out when I do net worth line graph with table report
using price nearest date to report? (Also amazing: that is not the default!)
Thanks,
David P
On Friday, April 12, 2024 at 05:20:25 PM EDT, sunfis...@yahoo.com
<sunfis...@yahoo.com> wrote:
Several years back, I sent this in to the list:
https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html
Pretty sure it still works.
David T. On Apr 12, 2024, at 10:02 PM, "David G. Pickett via gnucash-user"
<gnucash-user@gnucash.org> wrote:
Not all users know that the nice table of your stocks and prices that you see
on so many web sites like my morningstar portfolio can be selected and pasted
into a spreadsheet like Excel, Google Sheets, or LibreOffice Calc, maybe not
perfectly, but so it is easy to turn them into a clean spreadsheet table. My
Morningstar did something weird with the first column but it was all there and
not too hard to cut and paste or paste-special it into a nice table. Then you
have the option of saving it as a CSV file (Comma Separated Value), which loses
any funny formatting and hypertext links and is maybe gnucash friendly.
It would be a bit of an emergency, and I could do this one stock at a time, but
importing this CSV to gnucash prices would be a nice backup. I have not done
the research or reading above to know how to import such a table into gnucash
prices. Can someone give a simple how-to? Do I need a date column? A column
to say it is nav or close? Is there a web page help on this?
gnucash-user mailing list
gnucash-user@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@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.
