How To Extract Historical And Upcoming Earnings Date And Time From ThinkOrSwim
Instructions & Code Available For Download Here:
Temporarily private as I switch from Etsy to a private website. If you are interested in purchasing, please reach out to the email in my profile or leave a comment below and I will get back to you quickly.
Note: Installation requires knowledge around how to install items like Python and their dependencies. You may get errors as you go through setup that you will have to troubleshoot. The purchase is for the instructions only and not setup. If you would like setup, please reach out. The minimum price for instructions plus setup is $200.
This video walks through how to extract historical and upcoming earnings data from ThinkOrSwim. We will then take the data, format it, and store it in SQLITE databases. It also walks through how to set up windows task scheduler to pull the upcoming earnings data from the .xlsx file type on a regular basis. The net result will be that we will only have to download the upcoming earnings calendar once every week or so to maintain an accurate and up to date database of the earnings date and time for any ticker we'd like.
#thinkorswim #earnings
0:00 Beginning
0:06 Installation Requirements
0:11 Setting Up File Structure
1:00 Obtaining Historical Earnings Data From ThinkOrSwim
2:24 Formatting Historical Excel
4:09 Creating Python Script and SQLITE Databases.
6:03 Repeat For Other Desired Tickers
6:48 Obtaining Upcoming Earnings Data From ThinkOrSwim
7:41 Formatting Upcoming Data in Excel
8:20 Appending Upcoming Data To Existing SQLITE Databases
9:49 Scheduling Python Script to Run Using Windows Task Scheduler
13:29 How to Test Task Scheduler
15:00 Need To Regularly Export Updated Upcoming Earnings Data From ThinkOrSwim and Convert to .xlsx FIle Type