This month at Sentieo’s New York office, our Head of Research, Nick Mazing, hosted a two-hour “Ask Us Anything” live webinar. Nick answered questions from Sentieo’s current and prospective users, covering the many functionalities of the platform. In this post, we will share a few FAQ’s about Sentieo’s Table Explorer and Plotter features.
Table Explorer FAQs
How do I save time when handling 6, 9, and 12-month cumulative reported numbers (such as Cash Flow Statements) using Table Explorer’s “Quarterize” function?
Unsurprisingly, this was the first question that came in. Table Explorer is a very popular feature that we released earlier this year. It identifies and chains similar tables for fast collection of “as reported” financials in an easily auditable and workable format. One of the challenges with using reported financials is adjusting cumulative cash flow line items; it is not hard, but it takes time. Here, we show how to do this in literally two clicks. Add a Q4 column and Quarterize.
How do I analyze reported KPIs?
Table Explorer will chain all “similar” tables in the filings going back years. So as long as the company has been reporting KPIs in a somewhat consistent format, Sentieo Table Explorer will chain them going back 10+ years. You can then export the tables to Plotter and add other data series (ie. rolling valuation, or alternative data such as search trends, or macro indicators).
How do I explore an idea from macro to micro?
To answer this question, we started with a transcript search searching for wage inflation, identified the restaurant industry as an industry that talks a lot about wage inflation, showed the search statistics in Plotter, overlaid with a macro indicator. We then used the search statistics to identify The Cheesecake Factory as a company that talks about the topic a lot. So we located the labor expense line with one query that saved us time digging through filings and tables. Once there, we used Sentieo’s Table Explorer to chain that table going back for a few years. We quickly visualized the trends in labor expenses and in operating income, as a percentage of revenue, to get an idea of what is going on.
How do I use Table Explorer to chain and visualize line items and KPIs from reported financials?
We dig into Royal Caribbean (RCL) and visualize many reported expenses to get insights on what has been going on with the business. We utilize our easy switch to Common Size and YoY% growth for all line items to see the full picture.
Can you show financials in Plotter?
Sentieo’s Plotter is our versatile data visualization tool. In addition to choosing from a wide menu of available data sets, users can also do a variety of calculations using these data sets. In this example, we pulled the past and estimated quarterly revenues for Home Depot and Lowe’s, and ran a correlation between these two data sets in three clicks.
Does Plotter integrate FRED macro data?
Our clients welcomed the recently expanded FRED macro data integration in Sentieo Plotter. We went over a quick example how to combine macro data with price data for a sector ETF.
How do I chart multiple datasets in Plotter?
Sentieo’s Plotter offers many data sets, from financials to macro series, to alternative data, to your own uploaded data sets. We show how to bring up KPIs in the tool for three casual dining stocks, and how to calculate a “mini-index” KPI average.
Missed the part of the webinar about DocSearch? Get updated here.