Put the latest stock prices, global stock indexes, exchange rates, Bitcoin even weather details automatically into Excel, Word and PowerPoint.
- 19 sample documents, ready to use, included with full explanation in the text.
- Full Color
- over 231 pages
- Stock prices and indexes from exchanges around the globe
- Latest ‘real-time’ and past stock price data.
- Excel 365 for Windows or Mac aka Excel with Office 365 subscription.
- Excel 2019, 2016 & 2013 for Windows
- 3rd edition
- Fast find, table of contents with links
- PDF format compatible with Windows, Mac, Apple and Android tablets and pretty much anything else including, of course, iPads!
There’s no need to retype details from a web site or (shock!) a newspaper when Office can do the job in the blink of an eye.
Real-Time Excel shows how to get ‘live’ or real-time data automatically into your Office documents.
- Stock Prices, fund values, indexes etc.
- Latest ‘real-time’ prices
- Historical price data
- Global exchanges in the USA, UK, Europe, Asia and elsewhere
- Stock Indexes (NASDAQ, Dow Jones etc).
- Currency Exchange Rates
- Bitcoin and other virtual currencies
- Geographical information and statistics.
Getting those details into Excel, Word and PowerPoint is possible and now easier than before.
Stock prices direct
Includes the new Stock data type for Office 365 subscribers (Excel 365 Windows or Mac) which easily adds global stock prices and company data right into your worksheets.
A whole chapter on the new Linked data types, how they work, the practical details to handle and a look ‘under the hood’ at how it works.
Ready to Use
Not only do we show you how to do it, we’ll give you the worksheet, document and presentation files. Open them up and start right away.
In recent years, Microsoft has made great improvements to Office around data importing. A lot of this has been obscured by changed branding (‘Power Query’ is now ‘Get and Transform’) and the marketing geek speak that the company loves so much.
Real-Time Excel blows past all the marketing nonsense, acronyms and tech speak to show how new features can work for individuals and small businesses.
We’ll show how to use the most common data exchange formats used by public web sites:
- CSV (comma delimited)
- Web pages (‘scraping’)
- Live updates in Google Sheets and link it into Excel automatically.
You can use the same techniques to grab information from other sources and sites.
Uniquely, we’ll also give you the sample documents used to make this book. Open them up in Office and tweak to suit your needs.
Beyond the basics
Real-Time Excel is a practical book using real data feeds that you can use today – most of them are free.
There are tips on the practicalities of getting live data streams like viewing the ‘raw’ data, getting API keys, security options and Internet privacy.
Word and PowerPoint too
We’ll show how to drop fresh information into Word documents or PowerPoint slides.
Yes, there are example Word and PowerPoint documents included so you can see for yourself how it’s done.
Some of the tricks we’ll show you aren’t the usual method that Microsoft demonstrates. We tell you what works best.
Easier and faster
If you thought that importing data was too hard or have VBA code to make it happen, check out Real-Time Excel. Chances are that Microsoft has caught up with your needs with a simpler and faster solution of Power Query/Get & Transform.
The ‘bottom line’, as they say, is this: you now have a lot more powerful, yet easier, options for getting data from other sources, arranging it and adding to Excel. From there you can work with the data in a standard worksheet, PivotTable, PivotChart etc. The data links can be ‘one-off’ imports or automatically updateable.
We’ll show you how to do it, step-by-step, so you can make your own connections to similar data that best suits your needs.
- Excel 2016 for Windows with Office 365 subscription (aka Excel 365).
- Excel 2019, 2016 & 2013 for Windows.
- We’ve not forgotten about the Macintosh but Microsoft hasn’t added the necessary features to Office for Mac.
- Easier and faster
- Stock prices right now and the past
- Word and PowerPoint
- Sample Worksheets and documents
- Make your own data feed
- Ebook power
- About the author
- Table of Contents
Real Time Excel
- Data Explorer begat PowerQuery begat Get & Transform
- PowerQuery or Get & Transform?
- What is a data feed?
- Web pages
- Secure it
- Testing a data feed
- About the example files
Linked Data Types
- Getting Started
- Data Card
- Refresh and auto refresh
- Time field conversion
- Metric conversion
- Currency symbol formatting for different currencies
- Exchange rates / stock price conversion
- Making web links
- Reporting Bad Data
- Under the Hood
- The Future
Stock Prices and more
- Finding a source
- Stock Data Type
- Google Finance
Historical Stock Data
- Data from a folder
- Adding more information
- Data Sources
Currency Exchange Rates
- Get External Data
- Power Query
- Lookup a rate
- Using in your spreadsheets
- Get a single value
Bitcoin and beyond
- Other Crypto Currency feeds
- Power Query limitation
- Setup Weather link
- Adding Query
- Formatting and conversion
Word: Adding live data
- Link single cells
- Under the hood
- About the example files
PowerPoint: Adding Live data
- Excel data source
- Change Excel Formatting
- One with the lot
Make your own data feed
- Web Tables
- XML from Excel
- Ebook power
- Get the Examples
- Your Office Watch e-books
- How we made this e-book
- Revision History
- Copyright Notice