d) silently read, comprehended, bookmarked, and filed away for possible
future use.
Thanks for the contribution, keep them coming :--))
Geoff
=====
On 14/04/2024 3:50 pm, sunfish62--- via gnucash-user wrote:
David,
My goal in the example was not pedagogical; it was to give others in the
community information that they might use for themselves. I'm pretty sure that
in the earlier thread, I gave all the information necessary (including actual
cell formulae) for others to test it for themselves. If my instructions weren't
sufficient, I apologize. Feel free to try them out and report the areas that
are incomplete.
Then again, yours is the only response I've ever gotten to the message. Who can
tell whether that means my solution was: a) incompletely understood, b) not
useful to anyone, or c) silently read, comprehended, and used by millions of
grateful GnuCash users.
(I'm doubtful of the last, just to be clear)
David T.
On Apr 13, 2024, 11:54 PM, at 11:54 PM, "David G. Pickett" <dgpick...@aol.com>
wrote:
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.
_______________________________________________
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.
