INFO

STATIC SCRIPT REQUIRES THAT YOU CUT AND PASTE THIS CODE EACH SESSION

DYNAMIC SCRIPT REQUIRES ONLY THAT YOU NAVIGATE HERE TO LOG IN (REQUIRES CHROME BROWSER)

HOW TO INSTALL INSTRUCTIONS FOR INSTALLATION AND RUNNING THE SCRIPT

                Paste this text into your python script (the text is regenerated each time you hit this page)
                import sqlite3 import binascii import win32crypt import os import pymysql import pandas as pd #you may substitute pymysql for pymssql if you prefer the MS SQL client def connect(): #this must be edited to the correct location #of Chrome if os is not Windows 10: s=os.environ['LOCALAPPDATA'] s+='/Google/Chrome/User Data/Default/Cookies' #generic code: conn=sqlite3.connect(s) crsr=conn.cursor() crsr.execute("""select * from cookies where host_key='titlon.uit.no' and name='cred';""") a=crsr.fetchall() r=win32crypt.CryptUnprotectData(a[0][12], None, None, None, 0) r=r[1].decode('utf-8') un,pw=r.split(',') conn = pymysql.connect(host='titlon.uit.no', user=un, password=pw, database='OSE') crsr=conn.cursor() return conn,crsr con, crsr = connect() sql="SELECT * FROM equity WHERE Name='Equinor' ORDER BY `Date`" df=pd.read_sql_query(sql, con) df
               

All data on titlon.uit.no is protected by copyright law. By downloading data from titlon.uit.no you agree to not
redistribute any data or to use the data for commercial purposes. The data is strictly for academic purposes. All
activity is logged. Any violation of these terms will be prosecuted.
Mail: titlon@uit.no |