I have a stock price table with the regular fields one might expect, as well as a few indicator fields. I want to select more than one ticker. Here is how I select one ticker, how might I select two in the same query so they come back together?
I would also like to be able to do addition and subtraction and averaging on the field "news" so that say I could subtract the news score from the index for a ticker. (Ie, BAC-XLF) or for average I would want (XLF- average(BAC,WFC,C, etc)
where Ticker = '@ticker1'
and EntryTime > '4/25/2011'
order by EntryTime
View Complete Post