> On Apr 4, 2024, at 9:42 AM, fromvendor <fromven...@outtacyte.com> wrote:
>
> I'm having trouble trying to tell gnucash-cli -Q get which provider to use.
> I want it to use yahoo_json, which is what I have set up in the Security
> Editor ("Yahoo as JSON" for single quote source)
>
> When I do get it to run, it looks like it's getting the data from
> AlphaVantage as I get the following Warning message:
> WARN <gnc.price-quotes> [GncFQQuoteSource::GncFQQuoteSource()] No Alpha
> Vantage API key set, currency quotes and other AlphaVantage based quotes
> won't work.
>
> It did work as I only have three securities at the moment. So, how do I
> specify yahoo_json on the command line or is the warning spurious?
>
>
>
> BTW, I really had a hard time getting the command to run properly on windows.
> Perhaps I'm dumb, but the online places give no examples of what a properly
> formatted command to look like. I did, however get the command to run and it
> did update my file.
>
> Here's what I discovered. Perhaps useful to someone in the future.
>
> Apparently the datafile specification won't allow specifying the drive as I
> get this error: failed to get_backend using access method "O"
> I don't know if it would have handled a path specification, but since I had
> to change to a different drive anyway, I changed my command window to the
> location where the file resides.
> Further, the datafile name wants the entire name with the suffix (so
> <datafilename>.gnucash)
> This resulted in a command line which looked like this: "C:\Program Files
> (x86)\gnucash\bin\gnucash-cli.exe" -Q info <-- case matters for the -Q
> This resulted in output so I did that right
> Continued on to use the get and ended up with: "C:\Program Files
> (x86)\gnucash\bin\gnucash-cli.exe" -Q get "<datafilename>.gnucash"
> and that did update my datafile albeit with the warning above.
The missing Alphavantage key warning is independent of the price sources in
your file because of Alphavantage being the default source for retrieving
currency exchange rates.
You don't specify the source on the command line with '-Q get'. It's specified
for each commodity in the data file.
The data-file spec takes a URI so you can use the form
'file:///o:/path/to/datafile.gnucash' to access files on a a different drive
from your CWD.
Regards,
John Ralls
_______________________________________________
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.
