Forum: Platforms and Indicators
April 9th, 2015, 06:43 PM
|
Replies: 8
Views: 1,416
You can change the "order by xdate" clause to...
You can change the "order by xdate" clause to "order by symbol, xdate" and the partition by clause to "partition by symbol, DATEPART..." if you want to run the query for multiple symbols at the same...
|
Forum: Platforms and Indicators
April 9th, 2015, 05:03 PM
|
Replies: 8
Views: 1,416
I havent run these so please fix any syntax...
I havent run these so please fix any syntax issues but this should get you what you want.
This gives you the current day's price and the previous days price in the same row.
select xdate,
...
|