Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Price retrieval issue with Stooq historical

Questions about updating prices or transactions in Fund Manager

Postby Djobydjoba » Sat Oct 14, 2023 11:16 am

Hi Mark,

I try to retrieve historical prices of Crude Oil WTI in Stooq (ticker: CL.F)
https://stooq.com/q/d/?s=cl.f&i=d
This works OK with Stooq server but not with Stooq historical

The error is:
WARNING: Server used but did not update any prices: (STOOQ-HISTORICAL)
Could not update any investments

Do you see what could cause the error?

(PS: same error for some other commodities)
Djobydjoba
 
Posts: 794
Joined: Tue Mar 09, 2010 9:39 am

Postby Mark » Sun Oct 15, 2023 1:34 pm

Hi Djobydjoba,

Interesting... For some reason Stooq isn't supporting this symbol for CSV download. If you look on that page of historical prices, at the bottom there should be a link to:

"Download data in csv file..."

as there is on other historical quote pages, like:

https://stooq.com/q/d/?s=eurusd

Fund Manager is using the same link as it would for other symbols and historical prices, but no data is returned.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11595
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Djobydjoba » Mon Oct 16, 2023 10:49 am

It seems the commodities I was trying to download were commodities futures (".F" at the end of the ticker) and indeed the possibility to download futures quotes from a .csv seems not available on Stooq.

This is not a problem as what I was looking for was in fact commodity cash prices, and I've just seen the dedicated page for them (https://stooq.com/t/?i=584) (for cash, the ticker has a ".C" at the end). For them it works like a charm.

Commodities on Stooq.png
Commodities on Stooq.png (26.84 KiB) Viewed 1124 times


AFAIK, this is the only server where all the main commodity cash prices can be downloaded, that's excellent.
Djobydjoba
 
Posts: 794
Joined: Tue Mar 09, 2010 9:39 am

Postby Mark » Mon Oct 16, 2023 4:06 pm

Hi Djobydjoba,

Okay, great, glad you found a solution for your needs.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11595
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 13 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.