It can get the prices for both stocks and mutual funds. The lookup is
done by ticker symbol.
GNUC's csv price importer requires a date to be present in the csv file
so I'm not sure what you are asking in your second question.
Below is a sample of a couple of lines from the csv file. It's has the
bare minimum of information the csv price importer requires.
This is the format of each line:
TICKER,PRICE,TYPE,DATE,CURRENCY
ARSIX,15.73,Ray Jay,2021/04/22,USD
BAFGX,35.07,Ray Jay,2021/04/22,USD
On 4/24/21 2:11 AM, David Carlson wrote:
Jack,
Your scripts offer an opportunity to massage the data, if needed. Out
of curiosity, can you import both stock prices and mutual fund
prices? And can you keep the timestamps in your CSV files?
On Fri, Apr 23, 2021 at 8:55 PM Jack Frillman <[email protected]
<mailto:[email protected]>> wrote:
It may be doing what I'm doing and making the date of the closing
price as the day the script is run.
I don't run it using cron. I run it manually and if I forget a day
I don't worry about it.
I just run one of these two commands from the terminal.
getquotes -y <-- gets the prices from Yahoo
......OR.....
getquotes -m <-- gets the prices from Market Watch
Then I import the resulting csv file that appears on my desktop.
I have two places to get the quotes so if one is unreachable for
some reason I have a backup source.
On 4/23/21 9:43 PM, David Carlson wrote:
I am not sufficiently comfortable with BASH, Chron jobs, etc to
be willing to set up an outside utility to do that. I manually
download prices inside the GnuCash price database using Yahoo as
JSON as the source. If I forget to do it in the late evening I
sometimes try to do it in the morning before the market opens as
I have several stock prices that I am also tracking. That is how
I discovered the incorrect dates on the mutual funds prices, I
am not sure if, for example, GnuCash downloads a stock price
during the day, does it replace it with a closing price if it
downloads again after the market closes. I suspect it may not
even keep the timestamps that come with the prices, so there may
not be any clue about that.
On Fri, Apr 23, 2021 at 8:18 PM Jack Frillman via gnucash-user
<[email protected] <mailto:[email protected]>> wrote:
I'm not sure what you are using to updated the your prices
but I wrote a
python script & a bash script that get the quotes and put
them into a
csv file for importing into GNUCash and I don't have that
date issue. I
run the scrips in the evening when the markets are closed.
On 4/23/21 8:59 PM, David Carlson wrote:
> I noticed recently that if I download mutual fund prices
after about 7 AM
> central daylight time the prices are saved in GnuCash with
todays date even
> though they are still yesterday's closing NAV until
sometime after the
> markets close. To reliably get the correct price posted on
the correct
> date it seems that I must wait until after 7PM Central time
but before 7AM
> the following morning.
>
> I would like to suggest an enhancement that if GnuCash
downloads a United
> States mutual fund price with a morning time stamp that it
presume it to be
> yesterday's closing NAV price. I would like comments from
others about
> this.
>
--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
_______________________________________________
gnucash-user mailing list
[email protected] <mailto:[email protected]>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<https://wiki.gnucash.org/wiki/Mailing_Lists> for more
information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
--
David Carlson
--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
--
David Carlson
--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
