Btukfyl

I want to scrape data from yahoo finance with a python program and based on that scrape the data from yahoo finance.

More precisely:

1. The program should ask the user which ticker, start date, end date.


2. The program should check if this ticker (inserted by the user) is in a certain text file.


3. If this ticker is in the text file, it should scrape the data from yahoo finance.


4. If not, it should print some string

The relevant lines in my code are the following:
(I am quite new to python so my code might not be pretty)

Importing stuff (some of it will be necessary later)

import pandas as pd

import datetime as dt

import pandas_datareader.data as web

from datetime import datetime

In the companies.txt file is a list with all NASDAQ listed companies

companies = 'companies.txt'



with open(companies) as c_obj:

    usernames = c_obj.read()



symbol = input("Stock symbol: ");



print("Please enter the Start date of your database")

start_date_str = input("Start date (mm/dd/yyyy): ");



print("Please enter the End date of your database")

end_date_str = input("End date (mm/dd/yyyy): ");



start_date = datetime.strptime(start_date_str,"%m/%d/%Y");

end_date = datetime.strptime(end_date_str,"%m/%d/%Y");

I want my program to look if the, from the user inserted ticker is in the file companies.txt. If yes, it should scrape the data of this company from yahoo finance, if not, it should print the line at the bottom.

if symbol in usernames:

    df = web.DataReader(symbol, 'yahoo', start_date, end_date);

else:

    print("Company name incorrect or company not listed on NASDAQ. To brows all NSADAQ listed companies please visit: https://www.nasdaq.com/screening/company-list.aspx")