Stock Quotes CalCPA Article

Jeff Lenning|July 15, 2019||, , ,

Microsoft recently updated the built-in tools for retrieving stock quotes into Excel. If you’re typing closing prices into Excel manually, my recent California CPA Magazine article may be able to help you get it done faster. Specifically, it talks about how the Stock data type retrieves current quotes and related information, and how Power Query can retrieve historical stock quotes.

To read the full article, just click below … hope it helps!

http://www.excel-university.com/articles/cal-cpa/get-current-and-historical-stock-prices-into-excel/

Posted in , ,

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Free Roadmap

Want to learn Excel?

Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.

Training Info

Leave a Comment





For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.

Training Programs
Free Resources

Learn by Email

Subscribe to Blog (free)
!
!
Subscribe
Something went wrong. Please check your entries and try again.

Topics

Battle Breakout Chart CHOOSE CONCATENATE Conditional Formatting Data Model Data Validation Dynamic Arrays EOMONTH External Data FILTER FlashFill Format Gamification Get & Transform Hacks Hyperlink IFERROR Impossible PivotTables INDEX INDIRECT Macro Map MATCH MAX Named Ranges Named References Names PivotTable Power Pivot Power Query QAT Sort Spill SUBTOTAL SUMIFS Tables TEXT TEXTJOIN UNIQUE VLOOKUP Web Data Web Query XLOOKUP

Categories