Created
May 20, 2018 06:33
-
-
Save kevincdurand1/d5218e564799aba999d964a1b847ac63 to your computer and use it in GitHub Desktop.
FibboMatrix
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select * | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 1 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) END/2 as MA2 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 2 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) END/3 as MA3 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 4 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 4 PRECEDING AND CURRENT ROW) END/4 as MA5 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 7 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) END/8 as MA8 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 12 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 12 PRECEDING AND CURRENT ROW) END/13 as MA13 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 20 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 20 PRECEDING AND CURRENT ROW) END/21 as MA21 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 33 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 33 PRECEDING AND CURRENT ROW) END/34 as MA34 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 54 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 54 PRECEDING AND CURRENT ROW) END/55 as MA55 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 88 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 88 PRECEDING AND CURRENT ROW) END/89 as MA89 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 143 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 143 PRECEDING AND CURRENT ROW) END/144 as MA144 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 232 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 232 PRECEDING AND CURRENT ROW) END/233 as MA233 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 376 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 376 PRECEDING AND CURRENT ROW) END/377 as MA377 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 609 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 609 PRECEDING AND CURRENT ROW) END/610 as MA610 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 986 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 986 PRECEDING AND CURRENT ROW) END/987 as MA987 | |
| ,CASE WHEN ROW_NUMBER() OVER (ORDER BY [Datetime]) > 1596 THEN SUM([Close]) OVER (ORDER BY [Datetime] ROWS BETWEEN 1596 PRECEDING AND CURRENT ROW) END/1597 as MA1597 | |
| from [dbo].[EURUSD_M1_199701020000_201805151555_Quant] | |
| where DateTime >= '2018-01-01' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment