BUG FOUND: Monthly dividends vs daily
1) Test download PIMIX data, using a very early start date and today for end date (I use 1/1/1900 and the URL converts). Dividend only, frequency = 1mo. Download data as .csv. You will NOT get most of 2018 dividends (the last 7 months). Now change frequency to 1d. Download again. Open both in excel and compare. Daily will show ALL dividends. You have a bug in your selection me thinks.
2) When doing dividends on your webpage, they are sorted by date. When doing a download, they are not, which requires a secondary sort (macro in my case) in excel. Why? Thank you.
44th
ranked
Michael Smith
shared this idea
