Is there a free crypto screener?

Discussion in 'Crypto Assets' started by nwoptions, Oct 26, 2024.

  1. Hi all, I'm looking for a crypto screener that will show currencies that have the price bouncing of a rising 200-day moving average.

    Stock Fetcher does this for stocks and ETFs, but not cryptos.

    Are there any screeners that do this?

    Thank you
     
  2. Baron

    Baron Administrator

    I know you said "free crypto screener" in the title, but at $39/mo Messari's screener is probably your best choice.
     
    nwoptions and MarkBrown like this.
  3. Peter8519

    Peter8519

    Yahoo Finance has crypto heatmap and table view.
    Visual heatmap of crypto currency prices, changes, and volume - Yahoo Finance
    There is no download button for downloading the EOD data. Fret not, here is the Excel VBA script for download the EOD data into Sheet1 of your Excel spreadsheet.

    Sub btc_usd()

    Dim my_url As String
    Dim XMLpage As New MSXML2.XMLHTTP60
    Dim HTMLdoc As New MSHTML.htmlDocument
    Dim price_data As Object, td_data As Object
    Dim tr_element As Object, td_element As Object
    Dim row As Integer, col As Integer

    ThisWorkbook.Sheets("Sheet1").Cells.Clear
    ThisWorkbook.Sheets("Sheet1").Cells(1, 1) = "Date"
    ThisWorkbook.Sheets("Sheet1").Cells(1, 2) = "Open"
    ThisWorkbook.Sheets("Sheet1").Cells(1, 3) = "High"
    ThisWorkbook.Sheets("Sheet1").Cells(1, 4) = "Low"
    ThisWorkbook.Sheets("Sheet1").Cells(1, 5) = "Close"
    ThisWorkbook.Sheets("Sheet1").Cells(1, 6) = "Adj Close"
    ThisWorkbook.Sheets("Sheet1").Cells(1, 7) = "Volume"

    my_url = "https://finance.yahoo.com/quote/BTC-USD/history/?period1=1729926295&period2=1730012695"
    XMLpage.Open "GET", my_url, False
    XMLpage.send
    HTMLdoc.body.innerHTML = XMLpage.responseText
    Set price_data = HTMLdoc.getElementsByTagName("tbody")(0).getElementsByTagName("tr")
    row = 2
    For Each tr_element In price_data
    Set td_data = tr_element.getElementsByTagName("td")
    col = 1
    For Each td_element In td_data
    ThisWorkbook.Sheets("Sheet1").Cells(row, col) = td_element.innerText
    col = col + 1
    Next
    row = row + 1
    Next

    End Sub

    1. Open a new Excel spreadsheet and click on Macros and select create and give any name. Cut and paste the above script into it.
    2. You need to check the following references for it to work. Go to Tool -> References and select the followings.
    upload_2024-10-27_16-21-56.png
    3. Go to Yahoo Finance and select ticker BTC-USD and click Historical Data. Select the data range that you need. Copy the URL and update the VBA script my_url string.
    4. Run the macro by clicking Macro button and select Run. It may take sometime if your data range is large. With these EOD data, you can plot the 200MA.
     
    nwoptions and richie90 like this.
  4. cumaz

    cumaz

    You can try:
    • Re-uploading the image.
    • Converting it to a different format like JPG or PNG.
    • Taking a screenshot of the content and uploading that instead.
     
  5. Lee-me

    Lee-me

    Crypto trading is wild, but finding a good screener can really help. So, some platforms like TradingView and CryptoCompare offer custom screeners that might let you set up criteria based on moving averages, like the 200-day one.
     
  6. 2rosy

    2rosy

    cumaz likes this.
  7. cumaz

    cumaz

    Yeah, finding a solid crypto screener that doesn’t cost an arm and a leg is a challenge. I’ve tested a few, and while most don’t offer deep TA filters for free, ICOholder has been surprisingly handy for tracking upcoming tokens and filtering based on basics like sector, funding, and launch stage. It won’t replace a full-blown charting screener like Messari, but for early trend-spotting or just keeping tabs on new projects, it’s been useful without needing to spend a dime.