Anyone able to help me out here...I know how to pull the data to Excel using the "Get Data from Web" but other than that I am stuck.... I do not think it is merely just an act of averaging each column of HIGHs and LOWs then taking the differences of those two numbers. Any help is appreciated... Using the following URL of https://finance.yahoo.com/quote/GOOG/history?period1=1546214400&period2=1577664000&interval=1wk&filter=history&frequency=1wk , determine the difference between the average weekly high and low for shares of Google in 2019. Use the following parameters: Time Period: Dec 31, 2018 - Dec 30, 2019 Show: Historical Prices Frequency: Weekly (Round the answer to 2 decimal places.)

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Averaging Weekly HIGHS and LOWS of historic Data

Thread starter excelsior77
Start date Apr 20, 2020

excelsior77

New Member

Apr 20, 2020

Anyone able to help me out here...I know how to pull the data to Excel using the "Get Data from Web" but other than that I am stuck.... I do not think it is merely just an act of averaging each column of HIGHs and LOWs then taking the differences of those two numbers. Any help is appreciated...

Using the following URL of

Alphabet Inc. (GOOG) Stock Historical Prices & Data - Yahoo Finance

Discover historical prices for GOOG stock on Yahoo Finance. View daily, weekly or monthly format back to when Alphabet Inc. stock was issued.

finance.yahoo.com

, determine the difference between the average weekly high and low for shares of Google in 2019. Use the following parameters:

Time Period: Dec 31, 2018 - Dec 30, 2019

Show: Historical Prices

Frequency: Weekly

(Round the answer to 2 decimal places.)