There are 2 Mysql tables for Equities, Characteristics and Prices.
>>> Characteristics has 3 columns: Equity, AvgVol and Cap.
>>> Prices has 3 columns: Equity, Date and Price.
I would like to create 2 Views, each with 4 columns:
>>> Equity, Price with Date = Date1 as P1, Price with Date = Date2 as P2 and Gain = (P2 – P1)/P1.
View1 has the Top 50 ordered by Gain, Descending with Cap >= 2 and AvgVol > 100000
View2 has the Bottom 50 ordered by Gain, Ascending with Cap >= 2 and AvgVol > 100000
How should these Queries be written?
Thanx,
Jay
>>> Characteristics has 3 columns: Equity, AvgVol and Cap.
>>> Prices has 3 columns: Equity, Date and Price.
I would like to create 2 Views, each with 4 columns:
>>> Equity, Price with Date = Date1 as P1, Price with Date = Date2 as P2 and Gain = (P2 – P1)/P1.
View1 has the Top 50 ordered by Gain, Descending with Cap >= 2 and AvgVol > 100000
View2 has the Bottom 50 ordered by Gain, Ascending with Cap >= 2 and AvgVol > 100000
How should these Queries be written?
Thanx,
Jay