You have to get the historical data from another source, like AlphaVantage or EOD, or from your broker. Stooq is currently not delivering data for direct download, not even with an API key. We have already looked for a free alternative, but found none. If anyone knows a free and daily updated source for D1 data, please let us know.
@jcl How can this be done using the Z9 system? I've been using Z9 for quite some time and now need to rebalance but obviously the Stooq mechanism no longer works properly.
Edit the asset list and remove the "!STOOQ:..." part from the symbol. Then load the recent asset histories in D1 format from your broker or another source, and put them in the History folder. Then run Z8 or Z9 as usual.
I am trying to run Z9 after updating Zorro S to the latest 3.11.12 version.
Because my IBKR account does not currently have US ETF real-time streaming market data (due geo restriction), I updated the Z9 history files from EODHD instead. This part now seems to work.
But when I start Z9 Trade, the log shows some symbols that are not in my current AssetsZ9.csv, for example AMZN and AOK: ``` Loading 16 assets.. NY time 13:42 !Requested market data requires additional subscription for API. See link in 'Market Data Connections' dialog for more details.AGG ARCA/TOP/ALL AGG-STK--0.00--SMART/--USD !The contract description specified for AGG is ambiguous; you must specify the currency. AGG-STK--0.00--SMART/-- !Requested market data requires additional subscription for API. See link in 'Market Data Connections' dialog for more details.AMZN NASDAQ.NMS/TOP/ALL AMZN-STK--0.00--SMART/--USD !The contract description specified for AMZN is ambiguous; you must specify the currency. AMZN-STK--0.00--SMART/-- !Requested market data requires additional subscription for API. See link in 'Market Data Connections' dialog for more details.AOK ARCA/TOP/ALL AOK-STK--0.00--SMART/--USD `` So I have questions:
1. Which asset list does Z9 Trade actually load? I expected it to use my current History/AssetsZ9.csv, but the log suggests that another asset list or cached list is being used.
2. Is there a generated/cache file that I should delete after replacing AssetsZ9.csv or after updating history files? For example, does Z9 use another internal list, optimized list, .fac/.par/.c/.trd file, or something generated by Z8/Z9?
I understand that the “Requested market data requires additional subscription for API” message is probably expected. But I was previously sucesfuly Trade with Z9 without live quote subscription. My main confusion is why Z9 Trade loads symbols that are not in my current AssetsZ9.csv, and whether there is a proper cleanup/rebuild step after updating the asset list and history.
Yes, it used the Z8 asset list. We have changed it, so it's now using the correct Z9 list. If you want a specific list, you can give it in a z9.ini file. There is no cache for assets.
NY time 15:22 Loading 17 assets.. !Requested market data requires additional subscription for API. See link in 'Market Data Connections' dialog for more details.AGG ARCA/TOP/ALL AGG-STK--0.00--SMART/--USD !The contract description specified for AGG is ambiguous; you must specify the currency. AGG-STK--0.00--SMART/-- !Requested market data requires additional subscription for API. See link in 'Market Data Connections' dialog for more details.DIA ARCA/TOP/ALL DIA-STK--0.00--SMART/--USD !The contract description specified for DIA is ambiguous; you must specify the currency. DIA-STK--0.00--SMART/-- !Requested market data requires additional subscription for API. See link in 'Market Data Connections' dialog for more details.FDN ARCA/TOP/ALL FDN-STK--0.00--SMART/--USD Error 047: No bars generated Logout.. !Logout complete ok
You normally don't start Z8 or Z9 in Trade mode. Only when you want to connect to a broker that does not support portfolio rebalancing. In that case you must adapt the asset list to the symbols of your broker, and must subscribe market data for all assets. Otherwise you'll get 'ambiguous' or 'invalid symbol' errors.
If your broker supports rebalancing: First download the latest historical data from AssetsZ9, then run a backtest. It wil generate the rebalance CSV file. In your broker's platform, open the portfolio rebalance window and import that CSV file.
Yes, but this workflow worked correctly in previous Zorro versions.
As I understand it, Z9 first downloaded the required historical data from Stooq. After that, when I pressed the `Trade` button in the Zorro GUI, Z9 connected to TWS/IBKR and rebalanced my portfolio directly.
I used this workflow successfully for several years without a US equity market-data subscription.
The reason I cannot simply subscribe now is that IBKR does not offer this live data feed for my account because of my passport/residency jurisdiction.
So my question is: has the intended Z9 workflow changed in recent versions, or was the previous Trade-mode behavior relying on delayed or locally downloaded prices in a way that is no longer supported?
Yes, the free historical data does no longer exist. To get the old workflow, you need to subscribe data from a vendor, and enter that source in the symbol in your z9 asset list.
For my setup, IBKR should remain the execution broker, while EODHD should provide both the current price and historical data.
Is this the correct Symbol syntax for AssetsZ9.csv?
*-STK-SMART-USD!EOD:*.US!EOD:*.US
For example:
AGG-STK-SMART-USD!EOD:AGG.US!EOD:AGG.US
Or does the EODHD source require a different prefix?
My goal is to preserve the previous Z9 Trade workflow: Z9 calculates and executes the rebalance through TWS/IBKR, but does not request US equity market data from IBKR.
Apologies for the confusion and for sending everyone down the wrong path. The diagnostics did exactly what they were supposed to do and eventually exposed my configuration mistake.
Thanks jcl for suggesting the paper-account test — that was what led me to isolate the real cause.