Subject: Re: Retrieving Historical price Data

Elan

When the retrieving site went down a few months ago I contacted Jason at J S <strimp101@gmail.com and he immediately fixed it. I have recently sent a note again but no response yet.

As for Wisesheets

If you don't want to bother in the short term, you can send me a list of stocks and the period when you want pricing, and I can return a csv file.

If you want to set up Wisesheets, here is a link.

https://www.wisesheets.io/?gad...

It is $60/year, but I found a $15 coupon fairly quickly. The free version is not sufficient for pricing data.

It is an add on that you have to go through the Microsoft store, if you have 365, or through google if you use googlesheets. Once you have the add on, it is quite easy to use. Put a list of tickers in a column A2 downwards, put the command =WISEPRICE(A2:A387, "AdjClose",350)in cell B1. A 387 is the last cell for my ticker list, use what is the last for you. 350 is the number of calendar days I want retrieved. It only retrieves trading days so there are no blanks to worry about.

There are various prices that can be retrieved. High, low, close and other data.

As mentioned, I think adjusted close is not correct as it is missing an adjustment for the most recent dividend.

I have communicated with the help desk a few times. Not real responsive but I did get answers, or a reply that they would check with their vendor.

Aussi