YQL Is Awesome

And not just because this is an entry for a Yahoo competition. The main RSS scraper for this application is a YQL statement that trims down the SEC's feed and spits it out in JSON. It's an incredibly easy-to-use system and saved me a bit of initial coding, and there is likely a performance boost too.

YQL Tables

To allow anyone access to real-time SEC data on insider trades, I've created two YQL tables.

Getting Transactions by Stock Ticker

This does an exact match for the stock symbol. The official SEC stock ticker is the only accepted format.

Getting Transactions by Insider's Name

This table does a string match for %name% to find the beneficial owner's name and then return the transactions.