Originally published: 05/04/2021 16:17
Last version published: 02/02/2024 08:53
Publication number: ELQ-13663-4
View all versions & Certificate
Last version published: 02/02/2024 08:53
Publication number: ELQ-13663-4
View all versions & Certificate
Crypto Viewer and Trendsignals Windows and Mac
With this program you keep track of your CryptoCoins and keep informed of every trend change. You can choose from over 7
Description
With this program you keep track of your CryptoCoins and keep informed of every trend change. You can choose from over 70 trend signals - which are automatically checked at any time!Key Features:Keep track of all your crypto coins at a glance!Choose every crypto ticker from eg. Yahoo Finance – tested with over 300 coinsGet an up to date overview with many measures (Day Low, Day High, Volume, Avg Volume, Market Cap, Circulating Suplly, 52 weeks bandwidth, …)Check signals for consolidation, breaking out and many moving average indicatorsCheck over 60 trend patterns like Doji, High Wave Candle, Hikkake, Hanging Man, Spinning Top, …)Check the patterns for daily data from the last year and also intraday from the last dayOptional email-alert – you can customize in which signals your are interestedParameters for day and percent customization for the consolidation and breaking out signalsDetailed How-To Description in the Excel and ReadMe-File with FAQFully free version to test (full functionality – only restricted to a number of checks per day)PARAMETERS in the Excel:Worksheet "Coins"Column A, starting at cell A3 = Input row for the crypto-tickers you want to work onCell B1, if cell i n or no, no email-alert will be send (otherwise - email-alerting)(only these measures will be put into the alert-email which have a "!" in the first row in the other worksheets)Cell D1, set the number of seconds for waiting between the tickers (if no value default 2 seconds will taken)(the waiting time should not be to narrow - scraping errors can occur on the source-website when the accesses are to fast / much)Cell F1, set the starting row for the working (if no value, working starts with row 3)Worksheet "MAs Signals"Moving Average Measures for the Coins inlcuding Consolidation and Breaking Out Signals in columns E+FAlerting Checks in the columns R to VCell B1: number of days back for which the consolidation / breaking out check will be doneCell D1: percent how much the deviation up and down is allowed for the consolodation / breaking outConsolidation Alert occur when the price in the last x days (=cell B1) ist not going more up and down than x percent (=cell D1)Breaking Out: Consolidation as above the the actual price is > than the maximum from the last x days (=cell B1)Row1 E,F,R to V: only these measures will be put into the alert-email which have a "!" in the first rowWorksheet "Patterns"Column E to BM: for every pattern one column - outputs "Bearish!" or "Bullish!" when then pattern is triggeredRow1 E to BM: only these measures will be put into the alert-email which have a "!" in the first rowWorksheet "Patterns Intraday"same as Worksheet "Pattern" but for intraday pricesColumn E to BM: for every pattern one column - outputs "Bearish!" or "Bullish!" when then pattern is triggeredRow1 E to BM: only these measures will be put into the alert-email which have a "!" in the first rowWorksheet "Parameter"Cell B1 - your email-adress from where the email-alert should be sent (eg. [email protected])Cell B2 - your mail-password - sometimes it must be a generated password(eg. for gmail with 2-factor-authentifiation you have to generate a app-pw - see: https://support.google.com/mail/answer/185833?hl=en)Cell B3 - smtp Server for your email-adress from cell B1 (eg smtp.gmail.com for gmail)Cell B4 - smtp Port for your email-adress from cell B1 (eg. 587 for gmail)Cell B5 - email-adress where you want to send the alerts to (could be also the same adress as in cell B1)
With this program you keep track of your CryptoCoins and keep informed of every trend change. You can choose from over 70 trend signals - which are automatically checked at any time!Key Features:Keep track of all your crypto coins at a glance!Choose every crypto ticker from eg. Yahoo Finance – tested with over 300 coinsGet an up to date overview with many measures (Day Low, Day High, Volume, Avg Volume, Market Cap, Circulating Suplly, 52 weeks bandwidth, …)Check signals for consolidation, breaking out and many moving average indicatorsCheck over 60 trend patterns like Doji, High Wave Candle, Hikkake, Hanging Man, Spinning Top, …)Check the patterns for daily data from the last year and also intraday from the last dayOptional email-alert – you can customize in which signals your are interestedParameters for day and percent customization for the consolidation and breaking out signalsDetailed How-To Description in the Excel and ReadMe-File with FAQFully free version to test (full functionality – only restricted to a number of checks per day)PARAMETERS in the Excel:Worksheet "Coins"Column A, starting at cell A3 = Input row for the crypto-tickers you want to work onCell B1, if cell i n or no, no email-alert will be send (otherwise - email-alerting)(only these measures will be put into the alert-email which have a "!" in the first row in the other worksheets)Cell D1, set the number of seconds for waiting between the tickers (if no value default 2 seconds will taken)(the waiting time should not be to narrow - scraping errors can occur on the source-website when the accesses are to fast / much)Cell F1, set the starting row for the working (if no value, working starts with row 3)Worksheet "MAs Signals"Moving Average Measures for the Coins inlcuding Consolidation and Breaking Out Signals in columns E+FAlerting Checks in the columns R to VCell B1: number of days back for which the consolidation / breaking out check will be doneCell D1: percent how much the deviation up and down is allowed for the consolodation / breaking outConsolidation Alert occur when the price in the last x days (=cell B1) ist not going more up and down than x percent (=cell D1)Breaking Out: Consolidation as above the the actual price is > than the maximum from the last x days (=cell B1)Row1 E,F,R to V: only these measures will be put into the alert-email which have a "!" in the first rowWorksheet "Patterns"Column E to BM: for every pattern one column - outputs "Bearish!" or "Bullish!" when then pattern is triggeredRow1 E to BM: only these measures will be put into the alert-email which have a "!" in the first rowWorksheet "Patterns Intraday"same as Worksheet "Pattern" but for intraday pricesColumn E to BM: for every pattern one column - outputs "Bearish!" or "Bullish!" when then pattern is triggeredRow1 E to BM: only these measures will be put into the alert-email which have a "!" in the first rowWorksheet "Parameter"Cell B1 - your email-adress from where the email-alert should be sent (eg. [email protected])Cell B2 - your mail-password - sometimes it must be a generated password(eg. for gmail with 2-factor-authentifiation you have to generate a app-pw - see: https://support.google.com/mail/answer/185833?hl=en)Cell B3 - smtp Server for your email-adress from cell B1 (eg smtp.gmail.com for gmail)Cell B4 - smtp Port for your email-adress from cell B1 (eg. 587 for gmail)Cell B5 - email-adress where you want to send the alerts to (could be also the same adress as in cell B1)
This Best Practice includes
1 Program, 2 Excel, 2 Readme