search

alangrainger / cryptorates.ai

Completely free live crypto rates for Google Sheets and Excel
https://cryptorates.ai/
4 stars 0 forks source link

Question: All time high for each coin? #7

Closed prismanet closed 2 weeks ago

prismanet commented 10 months ago

Hi, I found your cryptorates.ai site searching on Google. What you have done is great and thanks for that. I'd like to know if it would be possible to add a new column for All Time High (ATH) of each coin to your Full.csv export? Let me know if you have questions. Regards, Prismanet

chefsas commented 6 months ago

I'd like to second the request for this item. If I had ATH (may as well add ATL while you're at it), I could use that value for certain projections and/or rules around my portfolio.

PS. Thank you so much for going through the effort to put this tool out there. It's incredibly helpful and simplifies much of the organization of my mining operations.

alangrainger commented 2 weeks ago

This has been added :) @chefsas please pass it around to your mining contacts - the more people using this the merrier. As the data is cached for free by Cloudflare it doesn't cost anything to have a million people using this vs 5 people.

See the docs here: https://cryptorates.ai/

All-Time High (ATH) and Low (ATL)

The dates for these columns are in Unix epoch time. To convert to a normal Google Sheets date, use the EPOCHTODATE formula:

=EPOCHTODATE(K2)
chefsas commented 2 weeks ago

This is awesome! Thanks so much!

-Scott

On Fri, Sep 27, 2024, 2:49 AM Alan Grainger @.***> wrote:

This has been added :) @chefsas https://github.com/chefsas please pass it around to your mining contacts - the more people using this the merrier. As the data is cached for free by Cloudflare it doesn't cost anything to have a million people using this vs 5 people.

See the docs here: https://cryptorates.ai/ All-Time High (ATH) and Low (ATL)

The dates for these columns are in Unix epoch time. To convert to a normal Google Sheets date, use the EPOCHTODATE formula:

=EPOCHTODATE(K2)

— Reply to this email directly, view it on GitHub https://github.com/alangrainger/cryptorates.ai/issues/7#issuecomment-2378634631, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARY5P3POOHV6CBC6CJUFU63ZYUEX5AVCNFSM6AAAAABO6S7IFSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGNZYGYZTINRTGE . You are receiving this because you were mentioned.Message ID: @.***>