Posts

Showing posts with the label python

Working On Finance Dataset || KPMG || Python

Image
Here I have a dataset on which we can practice our python and finance skills, I got this dataset from a website that provides virtual internship One of them is KPMG Virtual Internship which is through  InsideSherpa . The KPMG Internship gives you the dataset and they ask you to : Data Quality Assessment Data insight Data Insight and Presentation But here I'm going to work on data quality Assessment through python. So let's Start! Now in this Virtual Internship, they will provide a Data Set, you can download the data set directly from the InsideSherpa KPMG Virtual Internship Portal . Here you'll get 5 sheets in this data set,  first one is only the instruction sheet you can read that for the do's and don't, the rest 4 sheets contain data that we have to assist. The first thing you have to do is open this xlsx file in your python environment, I'm using Google Colab.  I've open the dataset in my environment like this. This is how I've successfully uploaded ...

Automation for Calculating Beta || Python

Image
 So, if I have to state in very simple words what beta is? Then I will say it like " Beta is a measure of stock's volatility in relation to the overall market "  Beta is a concept that measures the expected move in the stock relative to movements in the overall market. The higher the beta is the stock will be more volatile, the lower the beta will be the stock will be less volatile. The formula for calculating beta is the covariance of the return of an asset with the return of the benchmark divided by the variance of the return of the benchmark over a certain period. Where: Covariance = measure of a stock's return relative to that of the market. Variance = Measure of how the market moves relative to its mean Now after all this detailed theory about beta here I will show you how you can calculate it using python and automation. import  pandas  as  pd import  numpy  as  np import  os import  yfinance  as  yf from  pandas_dat...

Portfolio Analysis #1

Image
(Description)   I am a student of B.com H Financial Markets (BSE) and in my academics, I’ve been taught how to invest in stock markets and analysis. I’m a third-year student and by the time I have a good knowledge of stocks and Mutual funds. Me and one of my friends have decided to invest some of our funds in the market but we don’t want an existing portfolio to invest in instead, we want to create our own portfolio and do the same, for we have decided that I will do all the analysis stuff and he will allocate the funds. I am using Python for the analysis part. How I did the analysis and stock selection will be described in this document.          I have to create my own portfolio so for that I have to select some stocks and I’m going to select only large cap stocks because large cap stocks are stable and mature investments, large cap stocks have lower volatility, greater analyst coverage, and perhaps a steady dividend stream.   I have selected stock...