Python project – realtime stock price

About the Projects

Fetch the current share price of multiple companies​ using Python web scraping

This project describes a Python code, which fetches the current stock price for multiple listed companies. This script first reads the excel sheet to get the list of all companies for which CMP (Current Market Price) has to be calculated and then fire up the browser to open a website which has this information. The automation script enters the name of each stock, one by one, in the search bar which in turn load the page with particular information, from which the CMP is scraped and stored.

This continues until the lists items from the excel sheet get over. Parallelly, scripts also keep on calculating the total profit/loss for each share by comparing it against the Invested price and number of shares. In the end, profit and (or) loss is calculated for each share
and the information is written back to the excel sheet. Excel sheet does further calculation to build up the bar graph for representing the data in the best possible way. Look at the video to get complete information.

---

YouTube video

---

Python code

from selenium import webdriver
from selenium.webdriver.common.keys import Keys
import time
import openpyxl
from pathlib import Path

wait_imp = 10
excel_path = Path(r"D:\Learning\Practice\Selenium\Stock\stocks_data.xlsx")
wb = openpyxl.load_workbook(excel_path)
ws = wb["CMP"]

# Read company name from excelsheet
print ("Step 1 --> Reading Excel-sheet, Please wait....")
s_row     = 4
c_list    = []
avg_val   = []
qnty_list = []
while ws.cell(row = s_row, column= 2).value != None:
    c_name = ws.cell(row = s_row, column= 2).value
    val_1 = ws.cell(row = s_row, column= 4).value
    qnty = ws.cell(row = s_row, column= 5).value
    c_list.append(c_name)
    avg_val.append(val_1)
    qnty_list.append(qnty)
    s_row += 1    
print ("Company name available in Database")
[print('    ->',name) for name in c_list]
time.sleep(2)
print ('\n')
# create a webdriver object for chrome-option and configure
CO = webdriver.ChromeOptions()
CO.add_experimental_option('useAutomationExtension', False)
CO.add_argument('--ignore-certificate-errors')
CO.add_argument('--start-maximized')
wd = webdriver.Chrome(r'D:\Learning\Practice\Selenium\chromedriver.exe',options=CO)

print ("Step 2 --> Opening Finance website\n")
wd.implicitly_wait(wait_imp)
wd.get("https://www.moneycontrol.com")
time.sleep(5)
print ("******************************************************************************")
print ("                      Getting Live Stock Value !! Please wait ...\n")


for i in range(len(c_list)):
    src = wd.find_element_by_id ("search_str")
    src.send_keys(c_list[i])
    src.send_keys(Keys.RETURN)
    wd.implicitly_wait(wait_imp)
    s_v = wd.find_element_by_xpath("//*[@id='div_nse_livebox_wrap']/div[1]/div[1]/div/div[2]/span[1]")
    ws.cell(row=4+i, column= 3, value = s_v.text)
    
    diff = (avg_val[i] - float(s_v.text))* qnty_list[i]
    per_diff = (diff/(avg_val[i]*qnty_list[i]))*100
    print ("{:>23} -> CMP {:<7} Current P/L->[{:>8.2f}] %P/L -> {:>6.2f}%".format(c_list[i],s_v.text, diff, per_diff))

print ('\n')
print ("Step 3 --> Writing Latest Price into Excel-sheet ....\n")
time.sleep(1)
wb.save(excel_path)

print ("Step 4 --> Successfully Written  \n")
print ("Step 5 --> Closing browser !\n")
print (" ----------------------- FINISHED !! ------------------------")

time.sleep(1)
wd.close()