Async Finance

Don't have time to leaf through a million 10Q reports? Good thing we can quickly get company financial statement data in python using the polygon.io API. GET 10% OFF YOUR 1ST YEAR SUBSCRIPTION FOR THE POLYGON API USE CODE "GETBAGS10" WHEN SIGNING UP FOR YOUR SUBSCRIPTION! https://polygon.io/?utm_source=affiliate&utm_campaign=getbags If you've never used the API, you can see how to get setup and access your API key in the video below. https://youtu.be/KPA0Bo3VVgw All the code from the video can be found here. https://github.com/AdamGetbags/polygonData/blob/main/polygonFundamentalData.py 0:20 open the docs 0:50 pip install polygon-api-client and import modules 1:10 create a client to connect to API 1:24 basic fundamental data request 1:34 assign ticker to get data for 1:57 list_stock_financials function 2:13 customizing function parameters 3:24 navigating the data 5:05 BLAMM AND JUST LIKE THAT - - -   Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology!    https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee!  https://www.buymeacoffee.com/adamgetbags    Keep up with me!  https://www.instagram.com/damgetbags  https://twitter.com/damgetbags - - -    Need some ideas for your project portfolio?   Check out how to get historical option price data in Python from the Polygon API.  https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - -    DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

In this first video of the series, we use Polygon.io API in python to get a list of all stock ticker symbols. This will be useful later when we take a look at getting price, dividend, and other fundamental data from the Polygon.io API. For those familiar with the API, skip to 5:35 to go full savage mode. GET 10% OFF YOUR 1ST YEAR SUBSCRIPTION FOR THE POLYGON API USE CODE "GETBAGS10" WHEN SIGNING UP FOR YOUR SUBSCRIPTION! https://polygon.io/?utm_source=affiliate&utm_campaign=getbags You can get all the code from the video on my Github below. https://github.com/AdamGetbags/polygonData/blob/main/polygonTickerList.py 0:28 create account at polygon.io 0:42 open the polygon and python docs 1:04 create API key 1:18 pip install polygon-api-client 1:42 create an API client and authenticate 2:29 the WRONG way to get tickers 4:14 the RIGHT way to get tickers 5:35 get a list of all stock ticker symbols - - -   Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology!    https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee!  https://www.buymeacoffee.com/adamgetbags    Keep up with me!  https://www.instagram.com/damgetbags  https://twitter.com/damgetbags - - -    Need some ideas for your project portfolio?   Check out how to get historical option price data in Python from the Polygon API.  https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - -    DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

If you love options and you love crypto, then you'll love Dopex - a decentralized crypto options exchange that can be used to trade crypto options. They have many crypto options and single staking options vaults available, but today I'll show you how to use the Dopex API to get data on their single staking options vaults (SSOVs), total value locked, token supply, and other token data. Dopex Website https://www.dopex.io/ Docs https://docs.dopex.io/ Github + Docs https://github.com/dopex-io/dopex-api/blob/master/docs/v1/ENDPOINTS.md All the code from the video can be found below https://github.com/AdamGetbags/dopexData/blob/main/DopexData.py 0:20 open the docs 1:00 get SSOV data // navigating the data 3:00 get SSOV APY data 3:42 get crypto options straddle data 4:35 get dopex farm data 4:49 get supported tokens for price quotes 5:09 get token price quotes 5:29 get token supply and market cap data - - -   Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology!    https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee!  https://www.buymeacoffee.com/adamgetbags    Keep up with me!  https://www.instagram.com/damgetbags  https://twitter.com/damgetbags - - -    Need some ideas for your project portfolio?   Check out how to get historical option price data in Python from the Polygon API.  https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - -    DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Here's how to create (super sus) AI art using the Dall-E 2 API in Python in just a few lines of code. You can sign up for a free account below https://openai.com/dall-e-2/ All the code from the video can be found here https://github.com/AdamGetbags/dalle2API/blob/main/createImages.pyhttps://github.com/AdamGetbags/dalle2API/blob/main/openaiSecrets.py 0:20 create an account with OpenAI 0:54 open the docs 1:03 pip install openai 1:25 code for importing modules and API authorization 1:54 create and assign organization and API key credentials 2:35 test API connection 2:47 generating AI art based on text 3:57 generating AI art based on an existing photo 4:56 PRETTY HORRIFYING NOT GUNNA LIE - - -   Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology!    https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee!  https://www.buymeacoffee.com/adamgetbags    Keep up with me!  https://www.instagram.com/damgetbags  https://twitter.com/damgetbags - - -    Need some ideas for your project portfolio?   Check out how to get historical option price data in Python from the Polygon API.  https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - -    DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

SushiSwap is a decentralized exchange where users can trade crypto and transact with tokens on the same chain and across different chains. Kick back and I'll show you how to get real time crypto swap rate data from SushiSwap using python and selenium. If it's your first time working with selenium, check out this video below to learn how to download google chrome driver and install selenium. https://youtu.be/jUS64V2jDiY All the code from this video can be found on my github. https://github.com/AdamGetbags/sushiSwapScraper/blob/main/sushiSwapScraper.py 0:22 open selenium docs 0:43 open SushiSwap url 1:17 import modules, assign url, create class for our scraper 1:40 optional make browser headless 1:55 open url, find element by XPATH, click element 2:39 how to locate elements // selenium docs 4:12 find element by ID, send keys 5:59 parse through multiple elements using find_elements() 6:28 finding parent elements of given element 7:18 finding element by FULL XPATH 8:35 testing the bot - - -   Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology!    https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee!  https://www.buymeacoffee.com/adamgetbags    Keep up with me!  https://www.instagram.com/damgetbags  https://twitter.com/damgetbags - - -    Need some ideas for your project portfolio?   Check out how to get historical option price data in Python from the Polygon API.  https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - -    DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Only a few quick steps until you can send push notifications in python directly to your Android or IOS device! The Pushover API allows you to do just that. They offer a free 30 day trial to the API. After that, they charge $5/per device for a lifetime subscription. 0:22 go to pushover.net 0:29 download pushover app on your device 0:42 login to your account on the web app to get user token 0:53 create an api token 1:26 open the pushover api docs and python example 1:45 import modules and credentials 2:03 create a connection to api 2:06 set post request parameters 2:24 SEND PUSH NOTIFICATION Here is all the code from the video https://github.com/AdamGetbags/pushoverApp/blob/main/pushoverTest.py Here is a link to the Pushover API Documentation. https://pushover.net/api - - -   Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology!    https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee!  https://www.buymeacoffee.com/adamgetbags    Keep up with me!  https://www.instagram.com/damgetbags  https://twitter.com/damgetbags - - -    Need some ideas for your project portfolio?   Check out how to get historical option price data in Python from the Polygon API.  https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - -    DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Excel files and CSV files are some of the most common inputs to python programs, so it's important to understand how to get this data into your python environment. Also, since Excel and CSVs are so popular, it's handy to know how to export data from python in a way that makes the data easy to access. The pandas library in python makes it super simple to begin importing and exporting this data - let's get started! All the code from the video can be found below. https://github.com/AdamGetbags/dataProcessing/blob/main/readWriteFlatFiles.py0:30 open the docs 1:03 import modules and check working directory 1:26 read CSV file into python 1:41 read Excel file into python 2:02 export python data to CSV 2:27 export python data to Excel - - -   Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology!    https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee!  https://www.buymeacoffee.com/adamgetbags    Keep up with me!  https://www.instagram.com/damgetbags  https://twitter.com/damgetbag - - -    Need some ideas for your project portfolio?   Check out how to get historical option price data in Python from the Polygon API.  https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - -    DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

You've already got a ton of data in Python. Let's dive in with MySQL and get started making a database for your next app! 0:39 install MySQL Community Server // MySQL Workbench 1:43 SECURITY WARNING 2:13 setup root user 3:19 clean up and create a MySQL connection 3:45 open connection menu 4:00 setup new user 4:12 create a new SQL database 4:35 pip install SQLAlchemy and mysqlclient 5:20 open python script and import modules 5:50 create sample pandas dataframe 6:08 assign variables with credential details from database config 6:39 create engine object using SQL Alchemy 8:28 create table from pandas dataframe 9:10 committing changes to a database in SQL Alchemy 9:30 get column names 9:43 print data from table 10:04 drop table and drop database You can find all the code from the video on my Github below. https://github.com/AdamGetbags/pythonToMySQL/blob/main/createDatabaseMySQL.py - - -   Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology!    https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee!  https://www.buymeacoffee.com/adamgetbags    Keep up with me!  https://www.instagram.com/damgetbags  https://twitter.com/damgetbags - - -    Need some ideas for your project portfolio?   Check out how to get historical option price data in Python from the Polygon API.  https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - -    DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Free futures price data is not readily available, so here's how you can quickly get access to historical futures contract price data from Yahoo Finance in python using the yahoo_fin library. You can find all the code from the video below. https://github.com/AdamGetbags/yahooFuturesData/blob/main/yahooFuturesData.py 0:31 open the docs 0:56 pip install yahoo_fin 1:28 import modules 1:32 find and assign futures contract ticker 2:13 request futures price data 2:32 review the data 2:44 plot the price data 2:56 continuous contract data WARNING 3:15 request futures price for specific settlement date 3:39 review the data 4:14 LET'S GET THESE BAGS - - -   Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology!    https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee!  https://www.buymeacoffee.com/adamgetbags    Keep up with me!  https://www.instagram.com/damgetbags  https://twitter.com/damgetbags - - -    Need some ideas for your project portfolio?   Check out how to get historical option price data in Python from the Polygon API.  https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - -    DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Want to create a database for your Python app in just a few lines of code? Here's how to quickly make a SQL database from a pandas dataframe by using SQL Alchemy.   You can get all the code from the video on my github below. https://github.com/AdamGetbags/dataframeToSQL  0:23 open the docs 0:46 pip install SLQAlchemy 1:07 import modules 1:41 confirm working directory 2:00 create pandas dataframe 2:25 create engine object in SQL Alchemy 3:34 create SQL table using pandas.df.to_sql() 4:24 working with SQL commands 5:46 get all column names from SQL table 6:12 select all data from SQL table and print   6:27 drop SQL table and dispose of engine object - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

It's only right that a website dedicated to tracking reddit trader's mentions and upvotes on popular stock, option, and crypto related subreddits is called APE WISDOM.  They offer a free API which is easily accessible, through the use of get requests, to request data on the most popular stocks.    All the code from this video can be found below.  https://github.com/AdamGetbags/apeWisdomData/blob/main/apeWisdomAPI.py  Here's how we can use python to programmatically access the data.   0:30 open the docs 1:35 import modules 1:50 set filter name and page number 2:11 build url   2:24 make initial get request   3:07 make remaining get requests 4:28 get results into new dataframe and format 5:25 create plotly treemap to visualize data 6:03 closing remarks - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Are you ready to become a master of the blockchain?   Good, because here's a full tutorial on how to access free crypto data from the Glassnode API in Python.   0:14 overview 0:35 open the docs (and get code from github) 1:07 import modules 1:29 get your Glassnode API key 2:00 request to get ALL endpoint data 2:57 view columns for endpoint data 3:20 view specific row of endpoint data 3:30 view tier of endpoint 3:44 view endpoints for specific tiers in the studio 4:13 view endpoint for specific tiers 4:27 view row by endpoint path 5:23 view assets available to endpoint 6:00 view data granularity available to endpoint 6:28 get candlestick data 8:11 im the king of the blockchain 8:15 get total addresses that hold a specific crypto 9:16 get spent output profit ratio 9:43 get supply last active over a year ago 10:15 get pi cycle top indicator data 11:16 now you're the master of the blockchain   All you need is to have your python environment set up and to get a free API key from Glassnode; now you are ready to go!   You can find all the code from the video below.  https://github.com/AdamGetbags/glassnodeData  Here's a link to the Glassnode API docs.  https://docs.glassnode.com/basic-api/api - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Here's a fast and free way to get crypto price data in from the Glassnode API.  In this video, we will make a candlestick chart, but you can use the data for analysis, sending signals, etc.    There is a ton of other functionality in this API, which I will cover in another video, but let's dive right in by requesting price data.  You can find all the code from the video below.   https://github.com/AdamGetbags/glassnodeData  Here's the link to the Glassnode API documentation   https://docs.glassnode.com/basic-api/api  0:30 open the docs   1:18 sign up and get API key  1:41 get endpoint URL  3:06 make request to API  3:18 formatting the response  4:34 create a candlestick chart   If you need WAY MORE crypto data, check out the CoinGecko API video below - There's a TON of data available!   https://youtu.be/4-CC3u4i73k - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

I have included this free template available for download in the Google Drive below.  Here's a fast and easy run down of how to create an optimized resume so you can have success when applying to jobs!  https://docs.google.com/document/d/1NFz9IEt0QM7dK4-wKtiS8-Rvzr0b9goJ/edit?usp=sharing&ouid=103226467527617776061&rtpof=true&sd=true  Customize it to your ideal position, and use this the format as a starting place before creating targeted resumes that are tailored to the exact position you are applying to. - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Tired of stale price data? Here's how you can get live forex price data streaming directly into your computer - to the second - with the TD Ameritrade API in Python.    0:37 open the docs 1:11 import modules 1:39 create client and authenticate to connect to TD API 1:59 create a queue class to store data 2:21 instantiate queue 2:26 review read_stream() function and message handlers 3:38 pick a forex pair to subscribe to 3:59 subscribe to data stream 4:06 unsubscribing to data stream 4:22 analyzing messages from stream   In this example, we stream live bid and ask prices for USD/JPY.  First step is to create a client and authenticate to connect to the API. Then, pick the currency pair to receive quotes for. Lastly, connect to the stream and get all the price data you could ever need.   All the code from the video can be found below  https://github.com/AdamGetbags/streamingQuotesTDA/blob/main/streamingForexQuotesTDA.py  TDA API Docs  https://tda-api.readthedocs.io/en/latest/  TD Ameritrade Forex Pairs  https://www.tdameritrade.com/investment-products/forex-trading.html - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Can short exempt volume indicate future buying pressure on a stock? Can this data be used to predict short squeezes? You'll never know unless you look into the data!   Today we're learning how to access short exempt volume and short sale volume data from the FINRA API for equities and ETFs FOR FREE in python.  Go to 2:56 to skip straight to the code!   All the code from the video can be found below  https://github.com/AdamGetbags/shortExemptVolumeFINRA/blob/main/dailyShortSaleVolumeFINRA.py  0:33 open the docs 1:01 quick review of FINRA API 2:56 import modules and assign variables for URL building 3:23 select ticker, build URL, and create headers 3:39 create custom filter for POST request 5:14 make a POST request to get FINRA data 5:38 format data into a dataframe 6:05 reformat date (a string) into a datetime object 6:21 specify aggregate functions for groupby operation 6:54 rename index and column names 7:13 get volume data from yahoo and add to FINRA data 8:20 create volume ratios and plot results - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Here's how to quickly get real time streaming quotes for future options from the TD Ameritrade API in Python.   0:38 open the docs 1:07 import modules 1:26 authenticate and connect to TD API 1:50 create a queue to store data from stream 2:13 instantiate the queue 2:21 overview of read_stream() function 2:45 create a handler for the data 3:06 add handler   3:37 add level one futures options sub   3:43 add future option contract name to sub/unsub function 4:18 review close_stream() function 4:47 subscribe to future options data stream 5:00 unsubscribe from stream   After you've successfully set up your connection to the API, the most particular part is getting the correct contract name. If you've seen the futures real time streaming video, you'll notice that the future option contract name is very different than the futures contract name.    For the futures contract, you might see a name like "/ESU22" but for a futures option contract you might see a name like "./EW1U22C3950"   Note,  the name begins with a period.   Here's all the code from the video  https://github.com/AdamGetbags/streamingQuotesTDA/blob/main/streamingFuturesOptionsQuotesTDA.py https://github.com/AdamGetbags/streamingQuotesTDA/blob/main/secretsTDA.py  TDA API Documentation   https://tda-api.readthedocs.io/en/latest/streaming.html  TD for Developers  https://developer.tdameritrade.com/ - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Let's take a look at how to stream real time futures price data for exchange traded futures contracts using the TD Ameritrade API in Python.    0:37 open the documentation, futures product list, and TD ThinkOrSwim (links below!)  2:06 import modules 2:35 authenticate streaming client  3:07 create a queue class to store data from stream  3:43 overview of read_stream() function  4:04 defining a "handler" function to handle stream messages  4:18 adding a handler  4:34 subscribe to futures product stream  4:40 get futures contract name to use when subscribing to stream  5:53 add futures contract name to sub/unsubscribe functions  6:01 review unsubscribe function  6:18 subscribe to the data stream  6:39 unsubscribe from the data stream  6:50 inspect the data in the queue   There are a bit of specifics in choosing the futures contract name when streaming futures price data, so be sure to specify the exact contract name you are looking for. It's fairly straight forward to find the contract name using the CME products list and the search function in ThinkOrSwim.   The set up of the code is similar to the equity/option real time streaming with the TD Ameritrade API; however, in the body of the read_stream function, you just have to swap in StreamClient.level_one_futures_subs(...) and StreamClient.add_level_one_futures_handler(...)   Easy business, finance family.  Here's all the code from the video  https://github.com/AdamGetbags/streamingQuotesTDA/blob/main/streamingFuturesQuotesTDA.py https://github.com/AdamGetbags/streamingQuotesTDA/blob/main/secretsTDA.py  TDA API Documentation   https://tda-api.readthedocs.io/en/latest/streaming.html  TD for Developers https://developer.tdameritrade.com/  CME Futures Product Slate  https://www.cmegroup.com/markets/products.html - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Here's a fast and free way to get historical option price data; it's easy to get all the option data you might need in Python from the Polygon.io API.    Here's all the code from the video   https://github.com/AdamGetbags/polygonData/blob/main/historicalOptionDataPolygon.py https://github.com/AdamGetbags/polygonData/blob/main/polygonAPIkey.py  0:32 open the docs  0:50 create a Polygon.io account and subscribe to free basic plan  1:25 pip install polygon-api-client  1:34 import modules  1:46 get API key from Polygon.io into python  2:19 authenticate your client with API key  2:34 request contract data for every available option by underlying  3:35 BEWARE of the rate limit  3:49 extract the individual contract data  4:17 assign option ticker to variable using individual contract data  4:30 create a request for OHLC option data   5:07 define frequency and periodicity of bars  5:30 get historical option price data   5:37 format to dataframe, reformat timestamp, and set index  6:24 plot a candlestick chart   The Polygon.io API features a ton of useful methods for getting stock, option, cryptocurrency, and forex data in a bunch of different programming languages. - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.

Unlike traditional stocks, futures, and options markets, crypto markets trade 24/7.  Therefore, it's necessary to adjust your crypto price data to match the data from exchange traded securities when doing certain equity time series analysis.  For this video, I use the Yahoo_fin library to get historical equity price data and the CoinGecko API to get historical crypto price data.   Here's the code from the video  https://github.com/AdamGetbags/cleaningCryptoTimeSeries/blob/main/adjustingCryptoData.py  1:17 get equity data from yahoo_fin  1:34 get crypto data from CoinGecko API  2:00 reformat dates datatype, set index, other reformatting  3:57 join equity and crypto data together on the index  5:50 calculate log returns    Let me explain. Say you wanted to know if there was a relationship between NYSE/NASDAQ/AMEX exchange traded financial asset and an asset in the crypto market. For example, what is the beta of Riot Blockchain with respect to Bitcoin price.  It will be helpful to adjust your crypto price data by removing the weekends and US market holidays from your time series.    It all depends on the analytical task, but for linear regression, correlation, machine learning, and other statistical analysis techniques, this adjustment can be useful.  In regards to the crypto data, there are some dangerous assumptions to be made about removing ~2/7th of all your observations.  So, be mindful about the specific task you are doing. - - - Follow the podcast and join our larger community on Youtube to receive value on all things finance and technology! https://www.youtube.com/c/adamgetbags If you love the content, buy me a coffee! https://www.buymeacoffee.com/adamgetbags Keep up with me! https://www.instagram.com/damgetbags https://twitter.com/damgetbags - - - Need some ideas for your project portfolio? Check out how to get historical option price data in Python from the Polygon API. https://youtu.be/87O9qxfMJ-g Here's how to quickly get crypto data in Python from the CoinGecko API https://youtu.be/4-CC3u4i73k Here's how to create a SQL database from a Pandas DataFrame in Python https://youtu.be/9IPlc-nKD1k - - - DISCLAIMER: The Information on Async Finance is provided for education and informational purposes only, without any express or implied warranty of any kind, including warranties of accuracy, completeness, or fitness for any particular purpose. The Information contained in or provided from or through Async Finance is not intended to be and does not constitute financial advice, investment recommendations, investment advice, trading advice, or any other advice. The Information on Async Finance is general in nature and is not specific to you the User or anyone else. You should not make any decision, financial, investment, trading, or otherwise, based on any of The Information presented on Async Finance without undertaking independent due diligence and consultation with a professional broker or financial advisory.