Название: Using Microsoft Excel 365, Stocks Data Type, Power Query, Pivot Charts, REST Web Services and JSON To Web Scrape Market, Financial and Economic Data
Автор: John Lee
Издательство: Amazon.com Services LLC
Год: 2020
Страниц: 285
Язык: английский
Формат: pdf, epub
Размер: 109.1 MB

It used to be very expensive in both time, money, and energy to get market, economic and financial data. People would get stock prices from CRSP tapes, read the paper version of the Wall Street Journal, buy the paper version of Value Line financial research. This all changed with the start of the Internet in the 1990s. The Internet removed the middlemen in delivering information and data to the user. Another big contributing factor in reducing the cost of getting data is with the evolution of Microsoft Excel embracing the Internet. Usually, users use web browsers like Microsoft Explorer, Firefox, and Google Chrome to access the internet. Excel and other applications can now also access the web.

One big overarching theme of the Internet is “FREE.” With web browsers and Microsoft Excel 365, we can quickly and often at no cost promptly get data to get an excellent general understanding of the current economic, financial, and market conditions. If we want a deeper sense of economic and market conditions, we can pay for more valuable data for a reasonable fee.

We will demonstrate Microsoft Excel’s Stocks data type feature to retrieve many different types of market data. We will also use Excel’s Power Query feature to complement Excel’s Stocks data type feature. Power Query can retrieve data from the internet that is not available to the Stocks data type feature. We will use Power Query to set up the process of automating the retrieval of market data from the Internet. Power Query can read many, but not all websites like a web browser. After reading the website, Power Query can format data and put it into Excel. We will retrieve market data from Finance.Yahoo.com, CNBC.com, Nasdaq.com, Fidelity.com, and many other financial websites.