March 20, 2023

Month: January 2023

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

Chapter 27: Build a Kickstarter Bot to Fetch Top and Trending Crowdfunding Product Data

January 27, 2023

Innovation and creativity ahead often are driven by capital. So as an eCommerce player in your space, it’s helpful and useful to notice the capital flow or projects paid attention to by the investors. There are many crowdfunding platforms out there, and frankly, there are many future stars that you might not be able to find on Amazon. But this is something we might be more interested in, for spotting a potentially profitable project. The question is how to automate collecting intelligent insights. So this is why this piece.

python tutorial

Chapter 26: Create a Shopify Bot Web Application Using Flask and Heroku

January 27, 2023

1.75 million merchants sell using the Shopify platform. And the company until now has a market cap of US$212.08 Billion. This makes Shopify become the most valuable company by market cap worldwide. Your competitor is using Shopify and you are curious what their activities are on-going, that includes pricing of course. Shopify Bot can be put in a more friendly and shareable format, instead of only using a raw script like Python Tutorial 10. So this is why Flask and Heroku today.

python tutorial

Chapter 25: Build a Python GUI App with Tkinter

January 27, 2023

UI and UX Marketing integrates the sales, order, and reporting processes in a single user interface. This straightforward interface makes the complicated simple by using Python GUI App. This concept and mindset are not only applied to customer communication and engagement. But also UI and UX marketing is not only for customers. Before marketing things launch, one of the most important sections is intelligent research and setting up an automation process. Don’t torture yourself by only using a raw script. You and your fellows can have a better Python graphic user interface.

Chapter 23: Douyin Bot & Content Scraper to Fetch Top Ranking Videos & China KOL Profiles

January 27, 2023

Douyin, which is the Chinese version of Tiktok, announced that users’ time under the age of 14 will be capped to use the app for a maximum of 40 minutes a day, and only between 6 a.m. and 10 p.m. The question is how does the system realise the signed-up users are under 14? Apparently the new policy is relying on their parents. Being said that, Douyin has averaged around 600 million daily active users, in which is accumulating many creative video content and top performing KOLs. A way to scrape scalably in bulk definitely can inspire your product development and marketing creativity.

Chapter 22: Tmall & Taobao Product Scraper Using Keywords to Fetch Item Data

January 27, 2023

The COVID-19 virus hit China first and hard, but China is the fastest recovering country worldwide. Evergrand and electricity events are still creating a blurry frontpath in China. But it’s a fact that China’s economy grew by a blistering 18.3% in the first quarter of 2021 compared to 2020. A country with more than 450 million middle class citizens, Tmall and Taobao product data insight basically have become a lighthouse for sellers who are doing business in China, or are going to enter and capture some percentages of this pie.

Featured Video Play Icon

Chapter 21: Amazon Best Selling Product Scraper to Find Niche Products, Monitor Competitors, and Identify Potential Clients

January 27, 2023

Amazon, the eCommerce giant globally, is the important lighthouse of product trend and direction to millions of sellers and hundreds of brands worldwide. Most of them are keeping eyes on the popularity of product selling and momentum of trends on Amazon. No brainer to ask a question where to find the trend? Amazon best selling products and brands is the place you should often drop by. It makes more sense if you are asking how to implement more efficiently in an automatic format. If you do, this piece can be helpful to you.

python tutorial

Chapter 19: Automate Refreshing SEO Keywords Performance in Google Sheets Using Google Search Console and Easy2Digital APIs

January 27, 2023

SEO keyword insight is pretty valuable for any webmasters. The existing ranked keywords’ avg position performance month by month let you understand how’s going of your content marketing strategy. What is more, new keywords popping up in the search console inspire you with the new content perspective and long-tail keywords to utilize. It’s kind of a no-brainer, but the thing is how to organize the process and automate the process which grabs the SEO insight. This is the value you can gain from this piece.