Excel Web Query for Stock Values or Exchange Rates

by excelisfun · 7 videos

Total watch time

48m 33s

at 1× speed · exactly 48 minutes, 33 seconds at 1×

custom

1×	48m 33s
1.25×	38m 50s
1.5×	32m 22s
1.75×	27m 45s
2×	24m 17s

Average video6m 56s

Longest10m 16s

Shortest4m 21s

Compare Open on YouTube JSON

Plan to finish

About 1 day at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

At one hour a day, every day, this playlist takes about 1 day. Turn on JavaScript to plan around your week.

Videos (7)

48m 33s in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.


1	Excel 2010 Business Math 35: Stock Value Percentage Change & Web Query For Current Stock Values	7:15	2011-10-23
2	Excel Magic Trick #108: Exchange Rate Table From Web Query	10:15	2008-10-10
3	Excel Magic Trick #104: National Debt Web Query	10:16	2008-09-30
4	Excel Magic Trick #94: VLOOKUP Into Web Query	5:18	2008-07-01
5	Excel Magic Trick 410: VLOOKUP: Convert Web Query Result 78.9k to 78,900	5:53	2009-10-14
6	Excel Dynamic Chart #14: Progress Chart Linked to Stock Market (Stock Prices Vs. Target Sell Price)	5:15	2009-12-16
7	Excel Dynamic Chart #13: Web Query Stock Percent of Target Chart	4:21	2009-12-16

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Markdown

[![Watch time: 48m 33s · 7 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nc-a-Kn1nDCWgBA1xyE7VO.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0nc-a-Kn1nDCWgBA1xyE7VO)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0nc-a-Kn1nDCWgBA1xyE7VO"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nc-a-Kn1nDCWgBA1xyE7VO.svg" alt="Watch time: 48m 33s · 7 videos" width="202" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0nc-a-Kn1nDCWgBA1xyE7VO returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.