While I can see you're passionate about this request, sarcasm rarely helps in these situations and won’t change the fact that we simply can’t accommodate it. The restrictions in place are there to protect all users and to comply with the terms set by data providers.
1 Like
Thanks Tomasz for your hard work.
I wanted to download Adjusted price. I followed this instruction:
I modified the aqh.format file as instructed, but it did not work. I examined the javascript in Amiquote, and saw that adjusted close is not supported.
Am I correct or missing something?
As explained in numerous posts written after Yahoo Finance breaking change, .AQH is NOT the format used anymore. This KB article is OLD and was written in 2007, way before 2024 when Yahoo has changed.
Obviously OLD articles don't apply to new situation.
Javascript that is present in the user-definable data source allows practically anything, including performing adjustment on the fly. The thing is that "Yahoo Finance Workaround" is as it name says a workaround, it was quick way of dealing with firestorm of frustrated emails. A more complete solution is in the design phase. I am not really keen to release dozens of versions since experience shows that each release is super painful process of explaining things over and over again. I need to design something that requires zero explanations.
1 Like
Seems like we need another patched update for a new workaround as the old one is experiencing issues:
The screenshot doesn't show anything useful. It just says that you have "syntax error" in script. It might mean that you modified the script, or that you have some outdated script. Or that something else is wrong but it is NOT specific. In fact the error is nonsensical as same script worked fine for all those "green" symbols. You need to check the version you are using. It must be 4.16.
I checked that AAN symbol and it works 100% fine with AmiQuote 4.16 just downloaded from the web site.
Maybe just try different dates, because there are faulty quotes on AAN From October 4 on Yahoo Finance.
If you try dates BEFORE October 4 then you will get data
Raw Yahoo data looks like this:
{"chart":{"result":[{"meta":{"currency":"USD","symbol":"AAN","exchangeName":"NYQ","fullExchangeName":"NYSE","instrumentType":"EQUITY","firstTradeDate":1606487400,"regularMarketTime":1727985735,"hasPrePostMarketData":true,"gmtoffset":-14400,"timezone":"EDT","exchangeTimezoneName":"America/New_York","regularMarketPrice":10.09,"fiftyTwoWeekHigh":10.1,"fiftyTwoWeekLow":10.08,"regularMarketDayHigh":10.1,"regularMarketDayLow":10.08,"regularMarketVolume":2775856,"longName":"The Aaron's Company, Inc.","shortName":"Aarons Holdings Company, Inc.","chartPreviousClose":9.95,"priceHint":2,"currentTradingPeriod":{"pre":{"timezone":"EDT","start":1729152000,"end":1729171800,"gmtoffset":-14400},"regular":{"timezone":"EDT","start":1729171800,"end":1729195200,"gmtoffset":-14400},"post":{"timezone":"EDT","start":1729195200,"end":1729209600,"gmtoffset":-14400}},"dataGranularity":"1d","range":"","validRanges":["1d","5d","1mo","3mo","6mo","1y","2y","5y","ytd","max"]},"timestamp":[1727789400,1727875800,1727962200,1728048600,1728307800,1728394200,1728480600,1728567000,1728653400,1728912600,1728999000,1729085400],"indicators":{"quote":[{"open":[9.970000267028809,9.949999809265137,10.079999923706055,null,null,null,null,null,null,null,null,null],"close":[9.920000076293945,9.989999771118164,10.09000015258789,null,null,null,null,null,null,null,null,null],"high":[9.979999542236328,10.020000457763672,10.100000381469727,null,null,null,null,null,null,null,null,null],"volume":[1933939,518114,2765717,null,null,null,null,null,null,null,null,null],"low":[9.90999984741211,9.925000190734863,10.079999923706055,null,null,null,null,null,null,null,null,null]}],"adjclose":[{"adjclose":[9.920000076293945,9.989999771118164,10.09000015258789,null,null,null,null,null,null,null,null,null]}]}}],"error":null}}
There are NULLS all the way from Oct 4.
Thanks I retired the download and it's working again. Maybe it's some server side issue. All good now thanks.
I understand the issue and don't want to get anyone banned from Yahoo...
But there is a use case for updating historical data because dividends and splits cause the historical data to all be adjusted - so it's useful to backfill all of history when these events occur.
Is it possible to allow us to just put in e.g. a 40 year range in the two boxes and AmiQuote just chunks up the requests to Yahoo into 10 year subsets, then concats them back together at the end. From the user perspective it would make the workflow simpler
You don't need to concat downloaded files. When you import (auto-import) data to AmiBroker everything is correctly placed where it belongs and if you download in multiple chunks it will just become one data set with all history covering all chunks, no matter how you import them (chronological, inverse or random).
So actually, you can just download those 40 years now, by doing 4 downloads for entire universe. Not much work if you ask me.
Besides - AmiQuote 4.17 allows more than 10 years already.
1 Like
How much more than 10 years? I didn't see this information mentioned in the release docs.