I need a YQL (Yahoo Query Language) query. The quesry should give me all the companies symbols listed in a given stock exchange.
Here is a psudocode for what I am looking for:
select * from yahoo.finance.??? where exchange(??) in ("NYSE","OTCEI")
The query should return all IPOs listed in the current stock exchange
Any other method to achieve the same result is also appreciated.
Thanks in advance.
I also need this query,
It's a huge table