SLA Computer Technical Support

Unlimited Remote & Phone Support For Your Business
ID Symbol 10 30 100 200 365 Avg Weighted Avg
SELECT `tblPrice_Log`.*
,`tblCrypto_Symbols`.`owned`, (`moving_avg_10_diff_percent_whole`+`moving_avg_30_diff_percent_whole`+`moving_avg_100_diff_percent_whole`+`moving_avg_200_diff_percent_whole`+`moving_avg_365_diff_percent_whole`) AS Sum_Of_MA
, ((`moving_avg_10_diff_percent_whole`+`moving_avg_30_diff_percent_whole`+`moving_avg_100_diff_percent_whole`+`moving_avg_200_diff_percent_whole`+`moving_avg_365_diff_percent_whole`)/5) AS Avg_Of_MA

, ((
(`moving_avg_10_diff_percent_whole`*10)+(`moving_avg_30_diff_percent_whole`*30)+
(`moving_avg_100_diff_percent_whole`*100)+
(`moving_avg_200_diff_percent_whole`*200)+
(`moving_avg_365_diff_percent_whole`*365)
)/(10+30+100+200+365)) AS Weighted_Avg_Of_MA

FROM `tblPrice_Log`
INNER JOIN `tblCrypto_Symbols` ON `tblCrypto_Symbols`.`symbol`=`tblPrice_Log`.`symbol`
WHERE `date` >= '2022-09-25' AND `tblCrypto_Symbols`.`owned`=1
AND `tblCrypto_Symbols`.`stablecoin`=0


ORDER BY (`moving_avg_10_diff_percent_whole`+`moving_avg_30_diff_percent_whole`+`moving_avg_100_diff_percent_whole`+`moving_avg_200_diff_percent_whole`+`moving_avg_365_diff_percent_whole`) DESC



ID Symbol 10 30 100 200 365 Avg Weighted Avg
SELECT `tblPrice_Log`.*
,`tblCrypto_Symbols`.`owned`, (`moving_avg_10_diff_percent_whole`+`moving_avg_30_diff_percent_whole`+`moving_avg_100_diff_percent_whole`+`moving_avg_200_diff_percent_whole`+`moving_avg_365_diff_percent_whole`) AS Sum_Of_MA
, ((`moving_avg_10_diff_percent_whole`+`moving_avg_30_diff_percent_whole`+`moving_avg_100_diff_percent_whole`+`moving_avg_200_diff_percent_whole`+`moving_avg_365_diff_percent_whole`)/5) AS Avg_Of_MA

, ((
(`moving_avg_10_diff_percent_whole`*10)+(`moving_avg_30_diff_percent_whole`*30)+
(`moving_avg_100_diff_percent_whole`*100)+
(`moving_avg_200_diff_percent_whole`*200)+
(`moving_avg_365_diff_percent_whole`*365)
)/(10+30+100+200+365)) AS Weighted_Avg_Of_MA

FROM `tblPrice_Log`
INNER JOIN `tblCrypto_Symbols` ON `tblCrypto_Symbols`.`symbol`=`tblPrice_Log`.`symbol`
WHERE `date` >= '2022-09-25' AND `moving_avg_10_diff_percent_whole` < 0 AND `moving_avg_30_diff_percent_whole` < 0 AND `moving_avg_100_diff_percent_whole` < 0 AND `moving_avg_200_diff_percent_whole` < 0 AND `moving_avg_365_diff_percent_whole` < 0
AND `tblCrypto_Symbols`.`stablecoin`=0


ORDER BY (`moving_avg_10_diff_percent_whole`+`moving_avg_30_diff_percent_whole`+`moving_avg_100_diff_percent_whole`+`moving_avg_200_diff_percent_whole`+`moving_avg_365_diff_percent_whole`)



ID Symbol 10 30 100 200 365 Avg Weighted Avg
SELECT `tblPrice_Log`.*
,`tblCrypto_Symbols`.`owned`, (`moving_avg_10_diff_percent_whole`+`moving_avg_30_diff_percent_whole`+`moving_avg_100_diff_percent_whole`+`moving_avg_200_diff_percent_whole`+`moving_avg_365_diff_percent_whole`) AS Sum_Of_MA
, ((`moving_avg_10_diff_percent_whole`+`moving_avg_30_diff_percent_whole`+`moving_avg_100_diff_percent_whole`+`moving_avg_200_diff_percent_whole`+`moving_avg_365_diff_percent_whole`)/5) AS Avg_Of_MA

, ((
(`moving_avg_10_diff_percent_whole`*10)+(`moving_avg_30_diff_percent_whole`*30)+
(`moving_avg_100_diff_percent_whole`*100)+
(`moving_avg_200_diff_percent_whole`*200)+
(`moving_avg_365_diff_percent_whole`*365)
)/(10+30+100+200+365)) AS Weighted_Avg_Of_MA

FROM `tblPrice_Log`
INNER JOIN `tblCrypto_Symbols` ON `tblCrypto_Symbols`.`symbol`=`tblPrice_Log`.`symbol`
WHERE `date` >= '2022-09-25' AND `moving_avg_10_diff_percent_whole` > 0 AND `moving_avg_30_diff_percent_whole` > 0 AND `moving_avg_100_diff_percent_whole` > 0 AND `moving_avg_200_diff_percent_whole` > 0 AND `moving_avg_365_diff_percent_whole` > 0
AND `tblCrypto_Symbols`.`stablecoin`=0


ORDER BY (`moving_avg_10_diff_percent_whole`+`moving_avg_30_diff_percent_whole`+`moving_avg_100_diff_percent_whole`+`moving_avg_200_diff_percent_whole`+`moving_avg_365_diff_percent_whole`) DESC
h