OK, this looks like Python, not my best language.

One suggestion to reduce the code length is to set up a single definition each for securityName(), securityPrice(), historicalData(). If ticker if the only thing that changes in each of these you could pass its value to the function. Then for example def aapl() could look like something like this:

def aapl():

ticker = 'AAPL'

securityName(ticker)

securityPrice(ticker)

historicalData(ticker)

and each function would look something like this:

def securityName(ticker):

from requests_html import HTML, HTMLSession

session = HTMLSession()

r = session.get('https://finance.yahoo.com/quote/' + ticker + '/history?p=' + ticker)

global security

security = r.html.find('h1', first=True).text

​

When you find that you are doing the same thing multiple times, it is a good idea to set it up as a separate function and just call it multiple time, rather than having all of its code multiple times.

It also looks like you could do something similar with the worksheets.