March 20, 2023

Investment

Featured Video Play Icon

Selling Well But Be Losing Money? 7 Variable Costs Are Impacting Your Online Store Profit Margin

February 7, 2023

Most of the online sellers ignore what variable costs would take place per transaction, and underestimate the impact of variable cost change in the profit margin, particularly as the variable cost increases with the sales going up.

So for the purpose to avoid selling more but be losing more. I’m going to talk about 7 types of online store selling variable cost that can impact the profit margin per transaction.

Featured Video Play Icon

Chapter 63 – Company Financial News Scraper for the Top-down Analysis Using Easy2Digital News API

January 28, 2023

Industry and company up-to-date news helps you keep pace with the stock company you invested. Nevertheless, it is time consuming if you check one by one out of your investment dashboard. I daresay you feel excited if your stock dashboard can automatically refresh the company news every day using a financial news scraper. As a result, you can make decision always along with top-down industry and company news.

In this article, I’m going to introduce Easy2Digital financial news API 1.0 with the API script sample. With this API, you can build a financial news scraper for your specific collection of company symbols and integrate it with your stock monitor.

easy2digital apis

Chapter 62 – Intrinsic Value Scraper for Comparing BVPS vs Price per Share Using Easy2Digital API

January 28, 2023

Discounted value of the cash that can be taken out of a business during its remaining life, is a well-known intrinsic value explanation offered by Warren Buffett. In fact, the intrinsic value calculator has a top-down and simple way out although the bottom-up and in-depth one requires more input. 

In this article, I’ll walk you through how to leverage Easy2Digital API data to build an intrinsic value scraper using Python. By the end of this piece, you can quickly scrape and consolidate 5 metrics in bulk, and find out if the symbol candidate from your list is a potential undervalued one to add to the investment queue by BVPS vs price per share. 

Chapter 61 – Financial Statement Scraper for Common-Sizing Comparison Using Easy2Digital APIs

January 28, 2023

Financial statements provide investors and marketers the raw data that can facilitate them to calculate, and compare the underlying value of companies. Moreover, notably revenue growth, capital expenses, and debt growth YoY do directly imply if a company is in a good shape or not, for example, market share is shrinking, or probably the cost of debt might rise, or it’s a potential one to invest because of current aggressive investment in new product development.

In this article, I’m going to work through how to build a financial statement bot using Easy2Digital API and Python. By the end of this piece, you can use the Python script and Easy2Digital API to obtain specific listed companies’ financial statement data, or leverage it to automate your dashboard update.

easy2digital apis

Chapter 60 – Stock Symbol Data Scraper for Financial Ratio Analysis

January 28, 2023

Along with interest rates rising against inflation, global stock markets have been bearish and obviously continue to drop as inflation kind of hovers over in a higher position and might last for a long period before pushing it down. 

From a standpoint of the cost of buying in the stock market, this is absolutely a good chance to observe the momentum and estimate the time bottoming out. It’s because this timing is easier for us to analyze and identify undervalued companies compared to the previous QE era, notably now companies are confronting the increasing cost of debt and economic recession challenges. Who can stay still, who is the ACE? 

If you are an investor in mutual funds, ETFs, trusts, Stock, and so on. This article can help you build a stock symbol data scraper for analyzing financial ratios in bulk using Python, FMP, and Easy2Digital API.

Chapter 38 – Build a CLV Calculator of SaaS, Subscription & Membership Plan Using Python, OOP

January 27, 2023

There is a saying “Starting a business is difficult and maintaining a business is even more difficult”. The truth is the competition indeed is getting more and more fierce along with more players joining the game and competing with you. New customer acquisition costs are definitely increasing, so the question is how to sustainably defend your business and maintain the customer loyal to your product and service. It’s for the purpose of maintaining business competition cutting-edge at the end and avoiding losing profit or even losing money. Understanding your customer lifetime value and calculating, getting a right number to refer is vital.

npv calculator

Chapter 36: Build an NPV Calculator in eCommerce Business Space Using Python

January 27, 2023

Global stock market is just like a roller coaster now, and if you are the passenger in the game, you might have a true feeling how exciting it is. Definitely we have alternatives out there, such as cryptocurrency, gold, etc. And private equity investment must be one of the options and eCommerce is a hot spotlight space. You can calculate the gold price by observing the historical trend and worldwide political, economic events. For the eCommerce business valuation, you can also have a calculator.

Chapter 33: Build an eCommerce Profit Margin Calculator Using OOP

January 27, 2023

Business is essentially a calculation. Based on the calculations that integrate with external and internal factors, people can stand on a giant shoulder and evaluate the current status and predict a more precise future. It’s not 100% correct, as the change is beyond the plan. However, it ensures you are indeed on the way to the goal instead of going the wrong way. The goal here is profitable whatever strategies you are implementing. And in the eCommerce space, SKU profit margin calculation is applicable as well.

Featured Video Play Icon

Chapter 29 – Build an Indiegogo Bot for Scraping Most Crowdfunded Projects

January 27, 2023

Indiegogo is an online crowdfunding platform that brings Users together to support crowdfunding campaigns featuring innovative products, creative design, and inspired ventures. It allows brands to launch and seek to raise funds for their own Campaigns and to contribute to the Campaigns of others. Campaign Owners can offer Perks to Contributors in thanks for the Contributors’ donation of funds.So do you want to consolidate all most funded projects in different sectors and categories by just spending 10 seconds. This is why this article is about today.

Comparable company analysis is one of the most popular approaches to evaluating potential stock investment opportunities. It’s a well-known approach to evaluating private equity investment as well. Data is critical for CCA. I’m not saying the fragmented and dot-by-dot pattern of data. But I am saying that big data, data can continuously flow in. In this article, I will walk you through what FMP and FMP API are, and how you leverage them to build a bot scraping financial data. By the end of this Python Tutorial, you can learn what ingredients you need to create the Python script of the FMP bot, and how to find the symbol used in the script. What Is Financial Modeling Prep or FMP API What is the source of the financials data - SEC Stock Market Data and Financial Data you need to scrape for the Comparable Company Analysis Must-have Python Libraries Revenue CAGR for the private eCommerce business valuation Full Python Script of CCA and FMP Bot Comparable Company Analysis Bot - What Is Financial Modeling Prep or FMP API? Financial Modeling Prep is a platform that offers you the best and most real-time information about stock markets. That includes news, currencies, stock prices, and the symbol financials. It’s a great data source platform to get the valuable data you need. For example, you can get discounted cash flow statements of companies to see if they are undervalued, overvalued, or simply at par value. Or you can get the market data and financial side data for your CCA. It’s feasible for you to find all financial models and valuation techniques, data that are used in corporate finance to get companies intrinsic valuation. For the financial modeling prep or FMP API, it offers you a fast lane to grab the data using python and push it to your data management interface. If you are working on the list of company NPVs to see the IRR, it takes you only a few seconds to grab all the comparable data. The company data comes from income statements over the past 5 years in a similar industry and product categories. So you can use the industrial revenue CAGR to forecast the revenue and gross profit. What is the source of the FMP financials data - SEC The U.S. Securities and Exchange Commission or SEC is an independent federal government regulatory agency responsible for protecting investors, maintaining fair and orderly functioning of the securities markets, and facilitating capital formation. U.S. Congress founded it in 1934 as the first federal regulator of the securities markets. The SEC promotes full public disclosure, protects investors against fraudulent and manipulative practices in the market, and monitors corporate takeover actions in the United States. It also approves registration statements for bookrunners among underwriting firms. Therefore, you can grab all up-to-date and reliable listed company financial datasets by using FMP API. All data is from the SEC and endorsed by the government. Python Tutorial - Stock Market Data & Financial Data you need to scrape for CCA In the article regarding the stock valuation using comparable company analysis, I walk through 3 primary sections of data to analyze the potential investment opportunities. For more details, please check out this article. Essentially for generating the multiples such as EV/Sales, EV/EBITDA, EV/EBIT, you would need the market data and financial data. Regarding the marketing data, it needs three data metrics, which are price per share, market cap, and TEV. What’s more, you also need financial data, such as sales or revenue, EBITDA, EBIT, and earnings. FMP API provides the company's financial income statement data. So you can utilize this API endpoint to grab the data For the API key token, you need to sign up an FMP account first and copy the API key that existed in your account setting. FMP account sign-up is totally free. It just takes you a few mins to create an account. It’s very easy and convenient. Comparable Company Analysis Bot - Must-have Python Libraries and Ingredients Basically, you can generate the data using requests calling the FMP API. Meanwhile, as the FMP is the JSON data format. You need the JSON library as well in the script. import requests import json import csv import pandas as pd import gspread import time from oauth2client.service_account import ServiceAccountCredentials For the data formatting, I would recommend you use Pandas. And If you like to update the data to Google Sheets automatically, you can select gspread. The main ingredient the script needs is the comparable company list, which requires adding the symbols. The symbol represents the specific listed company. For example, the Apple symbol is AAPL. I would recommend two ways for you to grab the list of symbols. One is you can utilize the Finviz platform. This is the platform I walked you through on how to find comparable company symbols in this article. You can immediately get a list of potential companies by filtering the criteria. For the Finviz bot, I would specifically walk you through how to create using python in the other article. The other way is you can just google it or search for them in yahoo finance. Normally it would come up in SERP with the most relevant and popular symbols in the industry and similar product categories. For example, here are the best smart home listed companies in the public market. Revenue CAGR using FMP API for the private eCommerce business valuation FMP API is very powerful which is not only suitable for stock valuation and CCA. It can also be applied to private equity investment. FMP company financial income statement provides the fiscal year revenue number over the past 5 years. The data is from the SEC, which is reliable to use as an anchor. For the CAGR calculation, you can use the Google Sheet functions - power, to calculate. Take the smart home for example. FMP API can give you the past 5 years of sales of the listed company. So you can take the 1st year and the 5th year sale number to calculate the CAGR. For getting a more convincing revenue CAGR, you can select all similar listed companies and use the media CAGR. That in a way represents this industry in the past 5 years. For the potential private company in the comparable industry, you of course can easily have the product average order value and monthly traffic online. So you can calculate the 1st year GMV. Plus the industrial revenue CAGR, you can also forecast the 2nd, 3rd, 4th, and 5th year’s GMV. Full Python Script of CCA and FMP Bot If you would like to have the full version of the Python Script of Comparable Company Analysis Bot, please subscribe to our newsletter by adding the message Python Tutorial 28. We would send you the script immediately to your mailbox. I hope you enjoy reading Python Tutorial 28 - Create the Comparable Company Analysis Bot, FMP Bot Using FMP API. If you did, please support us by doing one of the things listed below, because it always helps out our channel. Support my channel through PayPal (paypal.me/Easy2digital) Subscribe to my channel and turn on the notification bell Easy2Digital Youtube channel. Follow and like my page Easy2Digital Facebook page Share the article on your social network with the hashtag #easy2digital Buy products with Easy2Digital 10% OFF Discount code (Easy2DigitalNewBuyers2021) You sign up for our weekly newsletter to receive Easy2Digital latest articles, videos, and discount code Subscribe to our monthly membership through Patreon to enjoy exclusive benefits (www.patreon.com/louisludigital)

Chapter 28 – Build the Comparable Company Analysis Bot Using Easy2Digital APIs

January 27, 2023

Data intelligence is not a term to show off how you are good at using data to make right decisions. I believe nobody can say we have a right stock investment decision with 100% correct prediction. Data intelligence is like an advisor giving you a way to see the big picture and inspire you with new ideas, and be along with you in the critical thinking and analysis journey. The question is how to scably and automatically collect and update the data for CCA. This is what the article is about today – FMP Bot using FMP API