Stock Price Analysis - SIP
Hi, Thank you for checking out my application. Please find the features of this app below. I recommend watching the video below to have a better idea about this application. - **Choice of Input**: - Your own input: - This option can be checked to upload your own csv file with all the data in it. It is advisable to download the files from the Official website of yahoo finance. - The application has been built on yahoo's historical data template and will automatically pick up the start and end dates from the given csv file. - For data from other sources, Please make sure that the following column names are followed: [date, high, close, low, open, volume]. Please note that the column names are not case sensitive and can be in any order. - Select ticker from dropdown: - Another option is to use the dropdown in the sidebar to select your favourite ticker. - The list of tickers is fetched at runtime from the yahoo finance API. - Unfortunately, there are only 30 tickers of NSEI (National Stock Exchange of India) for which data is provided by the API. Anyways, Please Feel free to play around with the available ones. - **Peek into the data**: - View the prices of tickers in different charts such as Line, Bar and Candle Sticks. - Choose your own time period for analysis and visualization. - An option is also given to view the raw data in the form of a table along with the chart. - **Find dates of occurrence of monthly minimums**: - This is my favourite part and core of the application. - View the dates of occurrence of minimum value of the selected ticker every month throughout the selected period. - This will answer whether there is any pattern to the price movement and if the stock is cheapest at or around any particular date every month. - **Find SIP Value**: - Simulate your SIP returns over the last twenty years. - Calculates and compares SIP executed on same day of every month throughout the period and generates graphs and the table with relevant data.