This link will correctly pull CTL dividend information from 1-1-2010 to 01-05-2017. Upon submit, the csv will instantly download and will contain all the dividend information from 2010 to 2017, but then the URL becomes :
So I am not sure if the URL change is relevant, but wanted to include it. Also I am not sure if this is on yahoo's end or the yql end, but this becomes invalid, and is looking from a start date of 0-1-2015 to end date 2-31-2014, both of which are invalid and invalid date range.
Then just for reference, using the YQL Statement select * from yahoo.finance.dividendhistory where symbol in ("CTL") and startDate = "2010-01-01" and endDate = "2017-01-05" doesnt pull any records after March 2014.
I just started looking at the codebase and have no idea where this issue could be stemming from, but hopefully I provided enough info for someone else to know what went wrong.
EDIT:
Okay, seems to be the fact that the current month is January. If I enter 01, the code subtracts 1 from the month so I'm looking for data that ends on "00" which pulls an error. If I use -02- it works. Is that "-1" in the code needed?
I've been experiencing this issue all week, wasnt sure if it was an issue on Yahoo's end or something else. I looked more into it today.
The ichart data is still there so it seems to be an issue with this code, but I am not sure where so hopefully someone else will know.
http://ichart.finance.yahoo.com/table.csv?a=01&b=01&c=2010&d=01&e=05&f=2017&g=v&s=CTL
This link will correctly pull CTL dividend information from 1-1-2010 to 01-05-2017. Upon submit, the csv will instantly download and will contain all the dividend information from 2010 to 2017, but then the URL becomes :
http://ichart.finance.yahoo.com/table.csv?a=0&b=1&e=31&g=v&c=2015&d=02&f=2014&s=CTL
So I am not sure if the URL change is relevant, but wanted to include it. Also I am not sure if this is on yahoo's end or the yql end, but this becomes invalid, and is looking from a start date of 0-1-2015 to end date 2-31-2014, both of which are invalid and invalid date range.
Then just for reference, using the YQL Statement
select * from yahoo.finance.dividendhistory where symbol in ("CTL") and startDate = "2010-01-01" and endDate = "2017-01-05"doesnt pull any records after March 2014.I just started looking at the codebase and have no idea where this issue could be stemming from, but hopefully I provided enough info for someone else to know what went wrong.
EDIT: Okay, seems to be the fact that the current month is January. If I enter 01, the code subtracts 1 from the month so I'm looking for data that ends on "00" which pulls an error. If I use -02- it works. Is that "-1" in the code needed?