The market has dropped -48% from its 90 day high and here I tabulate how many months it had took to recover from such an event.

source: coinbase API. They only have data starting 2016, Jan 1st so this is where I start my analysis.

since 2016 this even has occurred 14 times in monthly bins.

method:

  • I calculated the lagging 90 day high closing price and then figure out how many days and months it took to recover.
  • Currently bitcoin is ~ 48% of the 90 day high so I filter by events this has occur by month.
  • I then figure out how many days or months it took to recover had you bought at the absolute highest.

results:

date close BTC.USD.volume max_90 pct_change recover_days recover_months
2018-01 9014.23 38171.97 19650.01 -54.1 1033 34.4
2018-02 6905.19 59578.6982 19650.01 -64.9 1029 34.3
2018-03 6816.01 15434.5228 17098.99 -60.1 961 32
2018-04 6619.01 10756.5497 17098.99 -61.3 956 31.9
2018-06 5851.66 7769.81165 9800 -40.3 358 11.9
2018-11 3731.32 36455.2237 7360 -49.3 168 5.6
2018-12 3183 9343.2724 6750 -52.8 147 4.9
2019-01 3397.42 8709.6973 6503.12 -47.8 102 3.4
2019-02 3409.57 6032.81895 6503.12 -47.6 96 3.2
2020-03 4857.1 113902.203 10371.33 -53.2 137 4.6
2021-05 34627.82 27999.1507 63588.22 -45.5 143 4.8
2021-06 31594.63 26505.1927 63588.22 -50.3 116 3.9
2021-07 29796.16 18114.1529 58958.05 -49.5 87 2.9
2022-01 35101.33 21310.7209 67554.84 -48

So as you can see, historically this has occurred 14 times since 2016. In 2018 was the worse, because just when you thought you bought at the absolute lowest, the ATH actually shifts and every month it kept on dropping.

Median

the median months it took to recover is 4.9 months or 147 days. The lowest it dropped was 64.9% on 2018, Feb.

Here is a histogram.

https://preview.redd.it/7ul6wj37z9d81.png?width=600&format=png&auto=webp&s=640ecac37cc7b325ffa979954eac0cbbd38b8fc0

TLDR: buckle up; historically it takes about 4.9 months or 147 days to recover from a drop of -40-64%. The shortest it took was 2.9 months and the longest was 34.4 months to recover. The lowest it ever drop was on Feb 2018 about 64.9% and that took 1029 days to recover. The good news is that it will likely recover again.

edit: A few comments below observed that the recovery phase seems to be getting faster so plotted this this as well.

recover time

πŸ‘︎ 6k
πŸ’¬︎
πŸ‘€︎ u/greenappletree
πŸ“…︎ Jan 22 2022
🚨︎ report
What’s the air quality like in Fiji since the volcano eruption in Tonga? Due to travel tomorrow to tabulate island and am so worried as Fijian government advised Sulfur in air been recorded and potential acid rain? Any information on what is going on in Fiji would be greatly appreciated ❀️

Correction : travelling to Shangri La Yanuka Island

πŸ‘︎ 11
πŸ’¬︎
πŸ“…︎ Jan 17 2022
🚨︎ report
The market has dropped -48% from its 90 day high and here I tabulate how many months it had took to recover from such an event. /r/CryptoCurrency/comment…
πŸ‘︎ 17
πŸ’¬︎
πŸ“…︎ Jan 22 2022
🚨︎ report
Update on polishing this tabulate coral in quartz. The space that’s half-dug-out with the remaining limestone is a hole that goes kind of deep into the coral. In life, was something burrowing into the colony? What could it be?
πŸ‘︎ 42
πŸ’¬︎
πŸ‘€︎ u/DemocraticSpider
πŸ“…︎ Jan 02 2022
🚨︎ report
Is this Cladopora tabulate coral in limestone and how would you clean it? Found on Cayuga Lake shore, Ithaca, NY.
πŸ‘︎ 4
πŸ’¬︎
πŸ‘€︎ u/plantgrogu
πŸ“…︎ Jan 17 2022
🚨︎ report
How do I edit tables I create using tabulate?

Im using the tabluate library for python to make an inventory list but how do I edit the items within the table once added(for instance I dont want to store pencil in there anymore)

πŸ‘︎ 4
πŸ’¬︎
πŸ‘€︎ u/xhis25
πŸ“…︎ Jan 24 2022
🚨︎ report
The market has dropped -48% from its 90 day high and here I tabulate how many months it had took to recover from such an event. /r/CryptoCurrency/comment…
πŸ‘︎ 28
πŸ’¬︎
πŸ‘€︎ u/Rambo2307
πŸ“…︎ Jan 22 2022
🚨︎ report
The market has dropped -48% from its 90 day high and here I tabulate how many months it had took to recover from such an event. /r/CryptoCurrency/comment…
πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/Blockchain_Bully
πŸ“…︎ Jan 22 2022
🚨︎ report
Everyone's Favorite: Proc Tabulate

Hello,

I am trying to do a summation by Company, but it is only giving me the summation of all sales. Could someone help me learn what would I correct in the code below?? (I would prefer to keep the Total as well, but it's not necessary)

proc tabulate data=All_Sales;

Title "CC Fee Data";

class Company Month Payment;

var Shipped_Sales;

table (Company=''*Payment='') ALL='Total' ,(Shipped_Sales=''*sum=''*f=dollar12.)

/box='';

run;

πŸ‘︎ 7
πŸ’¬︎
πŸ‘€︎ u/PhillyGolfGuy
πŸ“…︎ Jan 04 2022
🚨︎ report
One of my favorite fossils I've found, a tabulate coral from NM
πŸ‘︎ 80
πŸ’¬︎
πŸ‘€︎ u/arkansas_rocks
πŸ“…︎ Nov 02 2021
🚨︎ report
Why does it take so long to tabulate RCV results?

Once the polls close and all of the ballets are scanned, we should all of the information required to tabulate the final winner, right? It would take a fairly simple computer program to crunch the numbers.

Why isn't this instantaneous? What am I missing?

πŸ‘︎ 26
πŸ’¬︎
πŸ‘€︎ u/DustUpDustOff
πŸ“…︎ Nov 03 2021
🚨︎ report
The market has dropped -48% from its 90 day high and here u/greenappletree tabulates how many months it took to recover from such events. /r/CryptoCurrency/comment…
πŸ‘︎ 4
πŸ’¬︎
πŸ‘€︎ u/sgt_happy
πŸ“…︎ Jan 23 2022
🚨︎ report
Upper Silurian tabulate coral biolithite/framestone
πŸ‘︎ 284
πŸ’¬︎
πŸ‘€︎ u/Voopnx
πŸ“…︎ Oct 07 2021
🚨︎ report
ロン tabulates encounter rate from 456 matches on Elite Smash, after his world record(?) win streak twitter.com/ron_yt0510/st…
πŸ‘︎ 34
πŸ’¬︎
πŸ‘€︎ u/adambrukirer
πŸ“…︎ Oct 17 2021
🚨︎ report
Donner would say, β€œShow me a fucking budget,” and they couldn’t, because writing down numbers on pieces of paper was to the Salkinds what a cross & holy water were to vampires. If you tried to tabulate where the money was coming from & where it was going, they would flinch & hiss, and turn to dust. superheroeseveryday.com/2…
πŸ‘︎ 19
πŸ’¬︎
πŸ‘€︎ u/scarecroe
πŸ“…︎ Oct 25 2021
🚨︎ report
LPT: Don't learn how to report, data tabulate, etc... on a MAC.

We have a new hire and I think I've spent my entire week teaching them how to use Microsoft applications.

Might also be inexperience. But still lol

πŸ‘︎ 79
πŸ’¬︎
πŸ‘€︎ u/Mkoy
πŸ“…︎ Sep 10 2021
🚨︎ report
Some kind of tabulate coral found in Southeast Tennessee, from some limestone riprap right next to the Chickamauga Dam. Trying to figure out the genus reddit.com/gallery/r34h3q
πŸ‘︎ 3
πŸ’¬︎
πŸ‘€︎ u/Don_Macaroons
πŸ“…︎ Nov 27 2021
🚨︎ report
Any way to Tabulate Indicator Values on Watched Stocks?

Hi, is there any way to generate a live table (perhaps in an offline Python script that queries TradingView) of the values of indicators for securities in watchlists? E.g. tabulating the RSI or some other indicator on an hourly/daily/whatever basis for all securities in a watchlist I've assembled.

I know that I could use alerts on just one indicator, firing the alert when the indicator (RSI or whatever) has entered the desired range and then another when it has left.

πŸ‘︎ 3
πŸ’¬︎
πŸ‘€︎ u/calebpetersenphd
πŸ“…︎ Dec 04 2021
🚨︎ report
My progress thus far on a tabulate coral preserved in quartz. Each little dot is where the polyps were hundreds of millions of years ago!
πŸ‘︎ 19
πŸ’¬︎
πŸ‘€︎ u/DemocraticSpider
πŸ“…︎ Dec 30 2021
🚨︎ report
New York Murder Rate Sharply Plummets After Guy Who Tabulates All The Homicides Is Shot thegloriousamerican.com/l…
πŸ‘︎ 53
πŸ’¬︎
πŸ“…︎ Nov 01 2021
🚨︎ report
A Google Sheets Template To Quickly Tabulate Your Coryat Score

The Master Template

I think you should be able to copy this template and edit your copy. LMK if you can't.

Basically, I made a template so I could quickly figure out my Coryat score without doing any math, because unlike Matt, I'm not smart irl (I just know random facts). Type in the categories. Then type "1" in the box corresponding any clue you answer correctly and in time. The spreadsheet will calculate your answer.

It's designed to be quick and easy to use, allowing you to focus on answering correctly.

Cheers!

πŸ‘︎ 15
πŸ’¬︎
πŸ‘€︎ u/ohalloranbooks
πŸ“…︎ Oct 13 2021
🚨︎ report
I need some help with Tabulate ad Find min functions.

My is_tie function is also off, but I assume it will be until the find min function is correct. I've been stumped on these two for a while now. I also attached check50's response for reference. Can anyone nudge me in the right direction? Thanks in advance! This community is so helpful

void tabulate(void)
{
    int j = 0;
    for (int i = 0; i < voter_count; i++)
    {
        int n = preferences[i][j];
        if (candidates[n].eliminated == false)
        {
            candidates[n].votes++;
        }
        else if (candidates[n].eliminated == true)
        {
            int m = preferences[i][j + 1];
            for (int k = 0; k < voter_count; k++)
                {
                    if (candidates[m].eliminated == false)
                     {
                        candidates[m].votes++;
                     }
         }      }
    }
}

int find_min(void)
{
    int min = voter_count;
    for (int i = 0; i < voter_count; i++)
    {
        if (candidates[i].eliminated == false)
        {
            if (candidates[i].votes < min)
            {
                min = candidates[i].votes;
            }
        }
    }
    return 0;
}

:) runoff.c exists
:) runoff compiles
:) vote returns true when given name of candidate
:) vote returns false when given name of invalid candidate
:) vote correctly sets first preference for first voter
:) vote correctly sets third preference for second voter
:) vote correctly sets all preferences for voter
:) tabulate counts votes when all candidates remain in election
:) tabulate counts votes when one candidate is eliminated
:( tabulate counts votes when multiple candidates are eliminated
    tabulate function did not produce correct vote totals
:( tabulate handles multiple rounds of preferences
    tabulate function did not produce correct vote totals
:) print_winner prints name when someone has a majority
:) print_winner returns true when someone has a majority
:) print_winner returns false when nobody has a majority
:) print_winner returns false when leader has exactly 50% of vote
:( find_min returns minimum number of votes for candidate
    find_min did not identify correct minimum
:( find_min returns minimum when all candidates are tied
    find_min did not iden
... keep reading on reddit ➑

πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/bobeena1513
πŸ“…︎ Nov 01 2021
🚨︎ report
python tabulate

Hey guys. i am coding a program for the pre release of 2019. I am trying to make a table using tabulate but it is not working. i have installed it on my computer but it is having errors which i dont know how to fix. Any help?

from tabulate import tabulate

category = ["phone","phone","phone","phone","phone","phone","tablet","tablet","tablet"]

itemcode = ["BPCM","BPSH","RPSS","RPLL","YPLS","YPLL","RTMS","RTLM","YTLM","YTLL"]

description = ["compact","clam shell","robophone-5inch screen and 64GB memory","robophone-6inc screen and 256GB memory","y-phone standard-6inch screen and 64GB memory","y-phone deluxe - 6inch screen and 256GB memory","robotab - 8inch screen and 64GB memory","robotab - 10inch screen and 128GB memory","y-tab standard - 10inch screen and 128GB memory","y-tab deluxe - 10inch screen and 256GB memory"]

price = ["29.99","49.99","199.99","499.99","549.99","649.99","149.99","299.99","499.99","599.99"]

def main():

printPTtable()

def printPTtable():

data =[]

for i in range(0,len(category)):

if category[i]=="phone" or category[i]=="tablet":

data.append(category[i],itemcode[i],description[i],price[i])

print(tabulate(data,headers=["TYPE","CODE","DESCRIPTION","COST",tablefmt =="fancy_grid",numalign=="right"]))

print("")

if __name__ == '__main__':

main()

that is the code

and here is what it gives

File "C:\Users\epici\OneDrive\Desktop\best prerelease.py", line 19, in <module>

main()

File "C:\Users\epici\OneDrive\Desktop\best prerelease.py", line 8, in main

printPTtable()

File "C:\Users\epici\OneDrive\Desktop\best prerelease.py", line 14, in printPTtable

data.append(category[i],itemcode[i],description[i],price[i])

TypeError: list.append() takes exactly one argument (4 given)

πŸ‘︎ 2
πŸ’¬︎
πŸ“…︎ Nov 23 2021
🚨︎ report
New York Murder Rate Sharply Plummets After Guy Who Tabulates All The Homicides Is Shot thegloriousamerican.com/l…
πŸ‘︎ 33
πŸ’¬︎
πŸ“…︎ Nov 01 2021
🚨︎ report
New York Murder Rate Sharply Plummets After Guy Who Tabulates All The Homicides Is Shot thegloriousamerican.com/l…
πŸ‘︎ 6
πŸ’¬︎
πŸ‘€︎ u/supersleeper454
πŸ“…︎ Nov 02 2021
🚨︎ report
Would someone be willing to tabulate how many shares we account for?

Would anyone be willing to do this? What’s the reason??? Let’s just say for arguments sake that all of WSB/Reddit accounted for 20 million shares...that’s useful info. That’s a big portion of the float.

Personally, I hold 73,000 shares and can verify it.

πŸ‘︎ 28
πŸ’¬︎
πŸ‘€︎ u/ccg_victor
πŸ“…︎ May 21 2021
🚨︎ report
Getting area from polygon(s) and rasters to match? Have tried clip, extract by mask, and tabulate area

Hello all. Hopefully someone here might know how to help with this issue. I am trying to use ModelBuilder to iterate through sets of polygons to overlay on top of two rasters and extract the total area of each value from each raster.

I have tried 1) clip (from Spatial Analyst toolbox for rasters), 2) extract by mask, and 3) tabulate area, but all give me the same results in terms of over- or underestimating the actual area of the polygon. I think because the cell size of the rasters is huge (~1500m), smaller polygons might have a more difficult time with it. I tried resampling the raster to a cell size of 500, but it only makes the area issue worse.

Any advice?

πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/batwoman779
πŸ“…︎ Nov 03 2021
🚨︎ report
I’m making an app that lets me tabulate the ups and downs of my day :) it’s helped me see my emotions as I get to track them holistically v.redd.it/gfcar4uppr171
πŸ‘︎ 265
πŸ’¬︎
πŸ‘€︎ u/gyummy
πŸ“…︎ May 28 2021
🚨︎ report
Can someone break this down/ tabulate this? Rope // Rosegold by Isaiah Rashad feat SiR youtu.be/2rGvAH7b4io
πŸ‘︎ 2
πŸ’¬︎
πŸ‘€︎ u/Chizzer34
πŸ“…︎ Nov 11 2021
🚨︎ report
Found this huge piece of tabulate coral in central indiana. What species is it?
πŸ‘︎ 24
πŸ’¬︎
πŸ‘€︎ u/bomba1749
πŸ“…︎ Jul 06 2021
🚨︎ report
How can we tabulate all the AMC shares?

When Canada and Europe cannot vote? I hold 6.8K AMC shares that cannot be added to Tim B's question.

πŸ‘︎ 12
πŸ’¬︎
πŸ‘€︎ u/Spudspazz1969
πŸ“…︎ Aug 03 2021
🚨︎ report
[Runoff] I am on the Tabulate function now and am fairly confident that I have got it right. However, it seems there's no way to test my function without completing the whole program. Is there a way?
πŸ‘︎ 4
πŸ’¬︎
πŸ‘€︎ u/monk-e7
πŸ“…︎ Jul 09 2021
🚨︎ report
To Tell the Truth β€œI enjoy ABC’s To Tell the Truth, but think they should make some changes: 1. Tabulate the audience’s choice, then count that as a vote. And 2. If no one gets it right, and the liars fool everyone, they should win extra cash for fooling the panel.
πŸ‘︎ 20
πŸ’¬︎
πŸ‘€︎ u/Wardyman70
πŸ“…︎ Jul 05 2021
🚨︎ report
Trump, shortly before he lost the 2020 election: "I think it's a terrible thing when people or states are allowed to tabulate ballots for a long period of time after the election is over." // Trump, 7 months after the lost the 2020 election: "MoaR aUDitS!!" npr.org/2020/11/01/930140…
πŸ‘︎ 210
πŸ’¬︎
πŸ‘€︎ u/imagepoem
πŸ“…︎ Jun 13 2021
🚨︎ report
Tabulate function in runoff doesn't produce correct vote total
void tabulate(void)
{
    for (int i = 0; i &lt; voter_count; i++)
    {  
       int j = 0;
       
       if (candidates[preferences[i][j]].eliminated == false)
       {
           candidates[preferences[i][j]].votes ++;
       }
       else 
       {   
           j++;
           if (candidates[preferences[i][j]].eliminated == false)
           {
               candidates[preferences[i][j]].votes ++;
           } 
       }
    }
        
    return;
}

I need help figuring out why my function doesn't calculate the correct vote values, I couldn't figure it out even after using a debugger.

πŸ‘︎ 2
πŸ’¬︎
πŸ“…︎ Oct 31 2021
🚨︎ report

Please note that this site uses cookies to personalise content and adverts, to provide social media features, and to analyse web traffic. Click here for more information.