Hi Jeremy,<br><br>As long as the Yahoo! Finance Headlines RSS feed has retained the historical data, then yes you should be able to query it. Your example for news announcements for AAPL doesn't have much historic data for some reason. I tried a similar query aggregating a few different ticker symbols:<br><br>select * from rss where url='http://finance.yahoo.com/rss/headline?s=yhoo,goog,msft&n=425' and pubDate LIKE '%16 Sep 2011%'<br><br>Some things to note is that the feed seems to support the 'n=' parameter to specify the number of items returned. The larger this number the further back in time your news items will go. Not all days have news items associated with them. Also, you can use like to match the format in which pubDate is returned. "9/21/2011" is not a proper date format for the field.<br><br>Hope this helps. Let me know if you have any further questions/problems.<br><br><br>Thanks,<br>Sadaf<br>YQL team<br><br><div class="quote"><div class="quotetop">QUOTE<cite>(jeremy @ 19 Oct 2011 12:52 PM)</cite></div><blockquote class="quotemain"><br>Hello,<br><br>I'm currently using some borrowed Python code (borrowed from <a href="http://www.gurchet-rai.net/dev/yahoo-finance-yql">http://www.gurchet-rai.net/dev/yahoo-finance-yql</a>) to bring in a list of ticker symbols and bring in news associated with these symbols. However, most of the work I'm doing is retrospective, so I need the ability to pull in old new feeds. For instance, I might need to see if there was any news announcements for Apple (AAPL) from around August 20, 2011. Do I have this ability? First, I don't have much exposure to YQL or the YQL table schema. Does this historic data even exist? Secondly, while trying to query it, I was having trouble adding a WHERE clause with pubDate = 9/21/2011.<br><br>My base query looks like:<br>select * from rss where url='http://finance.yahoo.com/rss/headline?s=AAPL'<br><br>Thank you for any help you can provide.<br>Jeremy</blockquote></div>
