
Seven tips to get the most out of course, guiding you to review the overview, prerequisites, explore content, use the AI assistant, participate in Q&A, and practice with materials.
Acquire the skills to import finance data from four free web sources into Python. Learn to register accounts, obtain API keys, install Python and pandas, and import data for analysis.
Download historical stock prices from Yahoo Finance and import them into Python using pandas read_csv, set the date as index, convert to datetime, and focus on daily close prices.
Import free finance data from Yahoo! Finance using the Python package to download stocks, indexes, currencies, funds, and crypto currencies, plus financials, with notes on reliability and alternatives.
Install the finance library in Python using Anaconda to fetch data from Yahoo! Finance, verify Python 3.4+, pandas 0.23.1+, and requests, then install with pip and run in Jupyter Notebook.
Import historical price and volume data for GE from Yahoo Finance using yfinance, pandas, and the finance library, and set multi-level index to false for a simple single-ticker dataframe.
Learn to import finance data with Python from free web sources by selecting custom time periods using start and end parameters or a period option, for historical stock price data.
Explore intraday frequency options in finance data with Python, from one minute to hourly, and set the frequency in the downloads method using the finance library.
Explore how dividends and stock splits affect historical prices and when to use close versus adjusted close for total return. Learn to download dividends and splits with the actions parameter.
Export financial data from pandas to CSV or Excel, using to_csv and to_excel, and handle file paths and timezone issues by making datetimes timezone unaware before writing to Excel.
Import and analyze closing prices for multiple stocks using the download method, group by options, select the last five years, and visualize the results with a line plot.
Fetch Dow Jones data from Yahoo Finance, extract close prices, and normalize to a base of 100 for index comparison, including price versus total return considerations and data completeness.
Import currency exchange rate data from Yahoo! Finance using Python, learn euro–usd and usd–eur tickers, and interpret one euro or one dollar in the respective units.
Learn to fetch cryptocurrency data from Yahoo Finance using a ticker for Bitcoin and etherial in US dollars, download five years of close prices, and compare trends.
Import Yahoo Finance historical data for mutual funds and ETFs, using tickers like iShares 20+ year treasury bond ETF, and review five-year open, high, low, close, adjusted prices, and dividends.
Fetch and compare U.S. treasury yields from Yahoo! Finance using Python, focusing on the 5-year and 10-year yields, and visualize how the yield curve informs risk-free rates and asset pricing.
Create a finance ticker object to import historical prices and fundamental data, then compare history and download methods, noting auto adjust defaults and recommending the download method for prices.
Navigate March 2023 Yahoo Finance updates by upgrading the finance package or using the Yahoo Query wrapper. Access key statistics and financial data for Disney, Microsoft, and Meta.
Learn to download and import stock fundamentals, metadata, and performance metrics from Yahoo! Finance using Python, and convert the data into pandas series and dataframes.
Import and download balance sheets, P&L, and cash flow statements from Yahoo Finance with a ticker object, then export each file to CSV in a local finance folder.
Learn to fetch put and call option data for Disney from Yahoo! Finance using the option chain, producing call and put data frames with strike, maturity, and price.
Stream real-time euro/US dollar data from Yahoo Finance, updating every minute via a while loop and printing the latest timestamp and close price.
Discover Alpha Vantage's free API for real-time and historical stock, forex, and cryptocurrency data with 50+ technical indicators, and learn to obtain an API key and use a Python wrapper.
Install and use the alpha advantage python wrapper for the alpha vantage api to simplify importing finance data into python, via conda or pip, in a jupyter notebook.
Import daily stock price data for GE from Alpha Vantage using a pandas-based time series object, retrieving open, high, low, close, and volume in a pandas dataframe.
Learn to customize free finance data imports with Python using Alpha Vantage time series to fetch daily stock prices, choosing compact or full output, and inspect the resulting data frame.
Compare unadjusted, split-adjusted, and dividends-adjusted stock prices from Alpha Advantage and Yahoo! Finance, and learn how a three-for-one split and dividends affect data.
Convert a string-based dataframe index to a pandas datetime index to unlock full functionality for finance data, enabling precise date-range selection from free web sources like Alpha Vantage.
Adjust frequency settings to fetch historic reprices and intraday data using a time series object, comparing monthly, weekly, daily, and intraday methods across Alpha Bandit and by finance.
Learn to fetch stock technical indicators from Alpha Vantage, including simple moving averages, Bollinger bands, and MACD, with Python to analyze price and volume data.
Learn to fetch forex data with the Alpha Vantage forex module, retrieving daily and intraday EUR/USD rates and exporting open, high, low, and close values.
Learn to fetch Bitcoin prices (BTC) daily using a cryptocurrency module, with an API key and pandas output, retrieving data for over 500 assets in USD and EUR.
Register a free demo Daymo account and obtain your API token, then use the Python wrapper to fetch free finance data from the online trading platform into Python.
Install the ACM API python package to import data from the s.m trading platform into Python, using conda or pip, and verify the installation with conda list.
Connect to the trading platform API using a demo account and token, then retrieve historical price data and list available instruments across currencies, stock indices, commodities, and cryptocurrencies, finally disconnect.
Connect to the CME data server, fetch available instruments, and retrieve euro–usd historical exchange rates with the get candles method, exposing open, high, low, close, bid/ask prices, volume, and spread.
Change data frequency for intraday data import by setting the period parameter, select minutes to daily, weekly, or monthly data, retrieve recent candles from the CME euro US dollar feed.
Learn to fetch historic euro–u.s. dollar exchange rates with the get candles method and customize time periods by candle count or start–end dates, including hourly and minutely data.
Connect to the data server to fetch historical daily prices for major stock indexes, including bid/ask, using the cat candles method for S&P 500, Dow, Nasdaq, DAX, and more.
Learn to download and analyze historical commodity prices—oil, gold, silver, copper, wheat and corn futures—using Python, including bid/ask, daily data, and futures versus spot considerations.
Retrieve historical cryptocurrency prices for Bitcoin and Ethereum using the get candles method to fetch daily and minutely data with open, high, low, close, and bid/ask prices.
Learn to stream real-time market data for the euro/usd pair with Python by subscribing, accessing last and ask prices, timestamps, and automating updates before unsubscribing and disconnecting.
Connect to the server and stream real-time euro/usd market data by subscribing to market data with a user-defined print data function, then monitor live price ticks and timestamps.
Identify an alternative source for high frequency realtime data and learn the demo account signup for access, including personal information and login details, while noting CFD risks.
Update conda and install the three required packages in the correct sequence using conda install commands, demonstrated in the Anaconda prompt or terminal with copy‑paste steps.
Get your api token and configure your account id and access token in a config file to connect to the UN server and retrieve instruments and historical data.
Learn to fetch historical price data with python from free web sources. Retrieve instrument lists and daily bid, ask, and close prices for indices, currencies, and commodities.
Explore how to adjust data frequency and access high-frequency intraday euro/usd data using a granularity parameter, from five seconds to one minute, five minutes, or 30 minutes.
Build a real-time, high-frequency lifestream with Alanda to stream tick data for open markets and instruments like euro-dollar exchange rate, with stop after a number of ticks or interrupt.
Explore a comprehensive data source offering free data for historical and real-time stock, crypto, and currency data across 60+ exchanges, and learn how to register and obtain an api key.
Learn to access a historical data API, obtain an API token, and download end-of-day Apple stock data (AAPL) as CSV, then import it into pandas in a notebook.
Create a simple user defined function to fetch historical stock prices and volume by ticker, start date, end date, and frequency. Compare with by finance data for Microsoft.
Learn to fetch historical dividends and stock splits for a ticker and integrate prices with corporate actions into a single data frame, with prices adjusted for splits and dividends.
Fetch historical data for financial indexes using ticker symbols. Explore the complete list of 328 indexes, including the S&P 500 and Dow Jones, with daily or weekly open-high-low-close-volume data.
Import exchange rates from currency data via currency pass, explore 900+ currencies, and fetch euro to usd daily data from 2000 to today, noting base currency behavior.
Import cryptocurrency prices from free web data feeds using Python and pandas in a Jupyter notebook, retrieving btc and eth daily and weekly data and converting to euros.
Fetch historical commodity prices with Python using DRL data and explore the documentation for the full list of supported commodities, including gold and crude oil.
Learn to fetch historical prices for mutual funds and ETFs with python, including stock splits and dividends, from sources listing over 6,000 ETFs.
Pull U.S. treasury yields treated as indexes, including the 10-, 5-, 2-, and 30-year yields with Tenex. Build a treasury yields function to fetch daily data across the period.
Explore stock fundamentals and performance metrics using free web sources, covering market cap, earnings, valuation ratios, shares, moving averages, dividends, and earnings trends.
Learn to import and download balance sheets, cash flow statements, and profit and loss data from free web sources using Python, and reorganize data frames for consistent historical financials.
Explore fundamentals and performance metrics for funds and ETFs using free web data, including general info, technicals, asset allocation, and top holdings.
Import pandas and requests to fetch bond data by CUSIP or ISO, define a bond metadata function, and inspect coupon, price, yield, maturity, and issue data for United Continental Holdings.
Learn how to fetch current corporate bond ratings using Python, pandas, and requests, interpreting Moody's and S&P ratings to assess default risk and influence prices and yields.
Fetch historical prices, yields, and trading volume for corporate bonds from free web sources using Python with pandas and requests, importing data via ISIN identifiers and a start date.
Learn to bulk download ticker symbols for entire exchanges using free web sources, exploring Yadi's exchange codes and virtual exchanges for stocks, crypto, indexes, and commodities in Python.
Explore bulk downloads of stock prices, dividends, and stock splits across multiple exchanges using Python and pandas, with open, high, low, close, adjusted close, and volume on a given date.
Install Python and the data science ecosystem with Anaconda to get a complete environment with pre-installed packages and dependency management. Choose the Windows, Mac, or Linux installer.
Open and launch Jupyter notebook via Anaconda Navigator or terminal, create and run coding cells with Shift-Enter or Alt-Enter, and manage notebooks and environments.
Explore the interactive Jupyter notebook environment, mastering edit and command modes, code and markdown cells, headers, images, and keyboard shortcuts to run, save, and manage errors.
download and use templates stored in notebooks to reproduce code for data import, unzip them, and insert your personal key token for Yahoo Finance and other sources.
Learn to work with tabular data using pandas data frames, a two-dimensional structure where each row is an observation and each column a feature, with labeled index.
Open a Jupyter notebook and import pandas as PD to create your first pandas dataframe from a csv file, such as Titanic.csv, in the same folder using PD.read_csv.
Explore pandas display options to inspect data frames efficiently with head() and tail(), adjust max_rows and min_rows, and compare notebook display versus print output for Titanic data.
Perform the first data inspection on the Titanic data frame (891 rows, 9 columns) to plan cleaning, using pandas info and describe methods for insights.
Explore how pandas data frames use built-in functions, attributes, and methods to analyze data, demonstrating method chaining from mean to sort_values and head.
Boost pandas coding efficiency with tab completion and tooltips for read_csv and sort_values. Learn to use shift+tab to view parameter details like by, axis, and ascending.
Learn to select one or more columns in pandas with the index operator; one column yields a series, multiple columns yield data frame when you pass a list of labels.
Learn how to select a single column in pandas using dot notation or square brackets, including equivalence and the equals test, with tips on when to use each.
Learn position based indexing in pandas data frames by using zero based and negative indexing to access specific rows, columns, and elements via row and column index positions.
Select rows efficiently using iloc (position-based indexing) in pandas, exploring a Summer Olympic Games dataset, demonstrating zero-based indexing, slicing, and negative indexing.
Explore position-based indexing with iloc to select specific elements, rows, and columns in a pandas DataFrame, including single values, row slices, and full columns like country.
Apply label based indexing with the log operator to select rows by label, compare it with position based indexing, and retrieve all rows for Michael Phelps.
Master label-based indexing with loc to select rows and columns by label, including single labels, lists, and slices, while non-unique indices complicate slicing and a range index is safer.
Learn pandas best practices for importing and inspecting finance data with Python, including single indexing with the log operator. Explore data frames, series, and index objects.
Learn pandas series as a one-dimensional labeled array, selecting a single column with square brackets or the data attributes notation, and converting to a data frame.
Import time series data from csv files using pandas read_csv, parse_dates, and a date time index to analyze hourly temperatures for New York and Los Angeles from 2013–2016.
Learn how to convert string dates to DateTime with pandas to_datetime, then set the column as the dataframe index, while handling multiple formats and invalid entries with coerce.
Inspect the temperature time series for Los Angeles and New York using pandas, check missing values with info and describe data, and visualize trends with line plots and shared y-axis.
Index and slice time series with a date time index using the log operator. Use Pandas to_datetime to convert timestamps and fetch specific hours or date ranges.
Import S&P 500 data from an Excel file into a pandas data frame, set a date time index, select specific columns, and export to csv and Excel for reuse.
What can be the most critical and most expensive part when working with financial data?
Pandas coding? Creating some advanced Algorithms to analyse and optimize portfolios? Building solutions for Algorithmic Trading and Robo Advising? Maybe! But very often it is … getting the Data!
Financial Data is scarce and Premium Data Providers typically charge $20,000 p.a. and more!
However, in 95% of all cases where Finance Professionals or Researchers require Financial Data, it can actually be obtained from Free or low-priced web sources. Some of them provide powerful APIs and Python wrapper packages, which makes it easy and comfortable to import the data with and into Python.
+++ This course shows you how to get massive amounts of Financial Data from the web and provides downloadable Python coding templates (Jupyter Notebooks) for your convenience! +++
This course covers four different data sources and explains in detail how to install required Libraries and how to download and import the data with few lines of Python Code. You will have access to
60+ Exchanges all around the world
120,000+ Symbols/Instruments
Historical Price and Volume Data for thousands of Stocks, Indexes, Mutual Funds and ETFs
Foreign Exchange (FOREX): 150+ Physical Currencies / Currency Pairs
500+ Digital- / Cryptocurrencies
Fundamentals, Ratings, Historical Prices and Yields for Corporate Bonds
Commodities (Crude Oil, Gold, Silver, etc.)
Stock Options for 4,500 US Stocks
Fundamentals, Metrics and Ratios for thousands of Stocks, Indexes, Mutual Funds and ETFs
Balance Sheets
Profit and Loss Statements (P&L)
Cashflow Statements
50+ Technical Indicators (e.g. SMA, Bollinger Bands)
Real-time and Historical Data (back to 1960s)
Streaming high-frequency real-time Data
Stock Splits and Dividends and how these are reflected in Stock Prices
Learn how Stock Prices are adjusted for Stock Splits and Dividends...
… and use appropriately adjusted data for your tasks! (avoid the Pitfalls!)
Build your own Financial Databases...
… And save thousands of USDs!
What are you waiting for? As always, I provide a 30-Days-Money-Back Guarantee. So, there is no risk for you!
Looking forward to seeing you in the course!