2 Messages

Digest #4443

Historical Calendar High Low prices for stocks by farris_justin

Re: Historical Calendar High Low prices for stocks by "Randy Harmelink" rharmelink

Messages

1a

Historical Calendar High Low prices for stocks

Thu Dec 20, 2018 12:50 pm (PST) . Posted by:

farris_justin

Is there any way quick and easy formula to find the high and low stock prices for each year? Example.. JPM 2014,2015,2016,2017,2018 High and low for those years?

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Historical Calendar High Low prices for stocks

Thu Dec 20, 2018 2:19 pm (PST) . Posted by:

You could try using stooq.com:

=INDEX(smfGetCSVFile("
https://stooq.com/q/d/l/?s=mmm.us&i=y&d1=20140101&d2=20181231",,10,10),6,3)

The last two numbers would vary as needed. In this case, it picked up the
6th row and 3rd column from this array:

*Date* *Open* *High* *Low* *Close* *Volume*
2014-12-31 $121.75 $151.87 $108.99 $148.41 711899341
2015-12-31 $148.77 $154.95 $123.42 $139.63 679125572
2016-12-30 $137.24 $171.81 $124.82 $169.96 553653512
2017-12-29 $170.21 $237.92 $165.19 $229.28 479950031
2018-12-31 $229.69 $253.06 $180.75 $189.96 640640935

On Thu, Dec 20, 2018 at 1:50 PM farris_justin@... wrote:

> Is there any way quick and easy formula to find the high and low stock
> prices for each year? Example.. JPM 2014,2015,2016,2017,2018 High and low
> for those years?
>
>