<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Hachi Kawamura on Medium]]></title>
        <description><![CDATA[Stories by Hachi Kawamura on Medium]]></description>
        <link>https://medium.com/@Furtman?source=rss-27e76292389d------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*UJW7OMQDD4Ns6uUArwem-w.png</url>
            <title>Stories by Hachi Kawamura on Medium</title>
            <link>https://medium.com/@Furtman?source=rss-27e76292389d------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 09:07:55 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@Furtman/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[RDDT Pre-Earnings Analysis — Through a Data Science Lens]]></title>
            <link>https://medium.com/dollar-harvest/rddt-pre-earnings-analysis-through-a-data-science-lens-bbea36d7ce9f?source=rss-27e76292389d------2</link>
            <guid isPermaLink="false">https://medium.com/p/bbea36d7ce9f</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[reddit]]></category>
            <category><![CDATA[stock-market]]></category>
            <category><![CDATA[data-mining]]></category>
            <category><![CDATA[stock-trading]]></category>
            <dc:creator><![CDATA[Hachi Kawamura]]></dc:creator>
            <pubDate>Thu, 06 Feb 2025 13:26:18 GMT</pubDate>
            <atom:updated>2025-08-16T19:34:09.891Z</atom:updated>
            <content:encoded><![CDATA[<h3>RDDT Pre-Earnings Analysis — Through a Data Science Lens</h3><blockquote>This post is a fun financial analysis written by two friends who aren’t financial gurus. Co-author: <a href="https://medium.com/@ubik.202?source=user_popover">Ubik 202</a> . Not a financial advice.</blockquote><blockquote>Updating with some edits after feedback from several Redditers.</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*234XdkB1jHVkkxFk.png" /></figure><p>So, we are data scientists and our real jobs are something completely unrelated — but can trading dummies like us take on the super-volatile RDDT stock analysis pre-earnings?! Guess we will see!</p><p>If you follow the stock market, you see that RDDT sounds SUPER over-valued and has high implied volatility all the time since IPO and especially now, pre-earnings (<strong>earnings released after hour 2/12</strong>). I’m not into finance but my understanding is that except for the maybe 10 to 20% revenue this quarter (Q4&#39; 24) from selling their data to Google, RDDT’s majority income is from their ads. You can fact check me by visiting their official SEC filing (10q).<br><a href="https://www.sec.gov/ix?doc=/Archives/edgar/data/1713445/000171344524000102/rddt-20240930.htm">https://www.sec.gov/ix?doc=/Archives/edgar/data/1713445/000171344524000102/rddt-20240930.htm</a></p><p>So what will be their EPS &amp; revenue for Q4&#39; 24? well we did the work for everyone using Calude.ai and various sources for data inputs such as:<br>-the Reddit developer’s API <br>-<a href="https://subredditstats.com/">https://subredditstats.com/</a><br>-some <a href="https://www.sec.gov/edgar/browse/?CIK=1713445&amp;owner=exclude">SEC data</a><br>-some<a href="https://finance.yahoo.com/quote/RDDT/financials/"> yahoo finance data</a><br>-some <a href="https://finviz.com/quote.ashx?t=RDDT&amp;p=d">finviz data</a> (some data requires premium subscription which we cannot copy paste)</p><h3># Step 1 Understand what drives Reddit’s ads revenue</h3><p>Long story short, Reddit’s main source of revenue is from advertising, and the amount of revenue can thus be deduced from<strong> Daily Active Users (DAU).</strong></p><p>DAU correlates well to revenue according to Claude.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/867/1*R0XZg51SVAOvFFFDqSwyJw.png" /><figcaption>Generated by Claude.ai</figcaption></figure><blockquote>What happened at Q1&#39; 24?</blockquote><p>This is when they IPO’ed so don’t worry about the dip too much.</p><blockquote>Edits:</blockquote><p><em>We should divide 2021–2023 numbers by 4 to estimate quarterly revenue.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/886/1*7dhOEiCCzn05ET8tkqLl9w.png" /><figcaption>Revised plot by Claude</figcaption></figure><p>Claude told me EPS is also corelated with <strong>DAU</strong>. But h<strong>ow can I know the DAU today since it’s not public data?</strong> I went ahead and mined sub reddit subscriber # data from: <a href="https://subredditstats.com/">https://subredditstats.com/</a>. <br>Turned out the AskReddit subscriber # correlates pretty well with the DAU. So here’s the trend:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/900/1*XbGJeZgtenIcwww1PU1vfg.png" /><figcaption>Subscriber data updated using Reddit API post 2023 and <a href="https://subredditstats.com/">https://subredditstats.com/</a> up to 2023 Dec.</figcaption></figure><h3># Step 2 Perform Data Science Magic to Predict EPS and Revenue</h3><p>Using only the input variables <strong>DAU and # of AskReddit subscribers</strong>, linear regression models for Revenue and EPS prediction were developed respectively. <br><strong><em>Is this a perfect fit?! <br>(</em></strong>Disclaimer: I did impute some DAU values using the subscriber # to fill the data gap. Model updated based on Redditters feedback.)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*C0eMIEyBLcg6gURHUyebgg.png" /></figure><blockquote>Edits: I have updated the models and predictions based on the updated data treatment. Some folks pointed out that I confused quarterly for annual revenues and hence the updates.</blockquote><p>I dumped the revenue data prior to 2024 since they are pre-IPO and the balance sheet may not be accurate… EPS is more normalized so I decided to keep that data prior to 2024.</p><p>Ok, so now we can use the models to predict EPS and Revenue (keep reading to know how this can help you place pre-earnings trade). Here’s the result and some stats of the models:</p><h4>Q4&#39;24 Predictions — <br>Revenue: $347M (updated and still missing revenue from selling data to Google, which is 60/4=15 M; according Redditors, we’re missing SEMrush data here to fully account for Q4 revenue.)<br>EPS: $0.18</h4><h4>Model Performance — <br>Revenue R²: 0.97 (updated)<br>EPS R²: 0.99 (updated)</h4><h3># Step 3 Reality Check with Wallstreet Experts</h3><blockquote>I think we are good at this.</blockquote><p>Yahoo finance showed me the following expert estimates:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/531/1*3q_mrKp--kg_0nfvB1gyiw.png" /><figcaption>Pretty close!</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/551/1*6qWJUz-phlyd6AET0NOlKQ.png" /><figcaption>Pretty close !</figcaption></figure><p>Adding Google’s contract will bring the revenue estimates to 362M, and this is not accounting for the web traffic that is often captured in SEMrush data which we don’t have access to. Seems like we have pretty good estimates here using publicly available data that’s easy to access.</p><h3>What about the financial side of things?</h3><p>Apparently, Reddit doesn’t have debts and has good cashflow based on their balance sheet. A large amount of their shares being sold by insiders are routine sales occurring monthly. Long term growth wise, Reddit may hit a ceiling once they achieved saturation in terms of expanding their userbase. But, till then, I’m neutral to bullish.</p><h3>Trading opportunities pre-earnings</h3><p>We’d suggest bullish strategies whether it’s buying the stocks (maybe a little too late) or selling puts at lower strikes, given the juicy premium.</p><p>That said, Bureau of Labor will release unemployment rate on Feb 7th which may have macro effects so watch out for that when timing your entry!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bbea36d7ce9f" width="1" height="1" alt=""><hr><p><a href="https://medium.com/dollar-harvest/rddt-pre-earnings-analysis-through-a-data-science-lens-bbea36d7ce9f">RDDT Pre-Earnings Analysis — Through a Data Science Lens</a> was originally published in <a href="https://medium.com/dollar-harvest">Dollar Harvest</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>