In this article, I will demonstrate how to get financial data without coding skills or with little coding skills. I will simulate getting financial data from Finhub, a data provider that offers various financial data. To execute the examples shown by Finhub, I will use Google Colab, a Jupyter hub environment that allows you to run Python code without any local installations.
To get started, we first need to define the problem we want to solve. For example, we can get the data for companies or IPOs from 2022 and analyze the performance of these companies. We can then rank them based on their current performance from the IPO date to today.
To get the financial data from Finhub, we need to obtain an API key. After obtaining the API key, we can use Google Colab to install the Finhub Python client package, which allows us to interact with the Finhub API. We can then use the API key to retrieve the IPO calendar data for the desired period.
Once we have the IPO calendar data, we can format it into a table using the pandas library. We can extract the symbols of the companies and use the symbols to get the current stock prices using the Finhub API. We can calculate the return from the IPO date to today’s date and rank the companies based on their performance.
In order to calculate the return, we need to define a function that retrieves the current stock price for a given symbol. We can then apply this function to each symbol in the IPO calendar data. We can store the current stock prices in a new column and calculate the return using the formula: (current price - IPO price) / IPO price * 100.
After calculating the returns, we can drop any rows with missing data and assign the updated data to the variable. Finally, we can print the companies and their corresponding returns.
In conclusion, by following the steps outlined in this article, you can easily retrieve financial data without coding skills or with little coding skills. Google Colab and the Finhub API provide a convenient way to access and analyze financial data for various purposes.
