aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGertjan van den Burg <gertjanvandenburg@gmail.com>2020-09-07 12:46:02 +0100
committerGertjan van den Burg <gertjanvandenburg@gmail.com>2020-09-07 12:46:02 +0100
commit610f6815f25d99679ba519e088daea9f335b0007 (patch)
tree0db7411ea138c2f259121da96be9a0c85d32ea0a
parentMerge branch 'bugfix/measles_download' into master (diff)
parentBugfix for aapl download script (diff)
downloadTCPD-610f6815f25d99679ba519e088daea9f335b0007.tar.gz
TCPD-610f6815f25d99679ba519e088daea9f335b0007.zip
Merge branch 'bugfix/aapl' into master
-rw-r--r--datasets/apple/get_apple.py12
1 files changed, 12 insertions, 0 deletions
diff --git a/datasets/apple/get_apple.py b/datasets/apple/get_apple.py
index 76d8e27..12c173b 100644
--- a/datasets/apple/get_apple.py
+++ b/datasets/apple/get_apple.py
@@ -86,6 +86,18 @@ def write_csv(target_path=None):
rounding=False,
threads=False,
)
+ # Somewhere between 2020-08-26 and 2020-09-07 an API change
+ # happened (I guess) that changed these prices and the volume by a
+ # factor of 4. Long term this is a fragile solution, but for now
+ # this condition ensures that the correct file is generated.
+ if 0.2131696 <= aapl["Close"][0] <= 0.2131697:
+ aapl["Open"] = aapl["Open"] * 4
+ aapl["High"] = aapl["High"] * 4
+ aapl["Low"] = aapl["Low"] * 4
+ aapl["Close"] = aapl["Close"] * 4
+ # Adj Close doesn't adhere to factor 4
+ aapl["Volume"] = aapl["Volume"] // 4
+
aapl.round(6).to_csv(target_path, float_format="%.6f")
return
except URLError as err: