"Last Price" is lower than "Low Price"

I'm finding this problem on the "Ratio" tab.

An example is for stock ITW, Illinois Tool Works

Year 1994

Last Price 6.16

High Price 11.38

Low Price 9.25

I'm not sure where you're getting the price data from, but I checked on Yahoo and your High and Low prices seen ti correspond to Yahoo's High and Low Prices but your "Close Price" corresponds to Yahoo's "Adjusted Close".

Maybe you should be using the Max and Min of "Adjusted Close" in order to calculate the High and Low prices.

Thanks

Jims

Upvoters
Status

In Review

Board

πŸ—‚οΈ Data Issue

Date

Over 1 year ago

Author

jim forrest

Subscribe to post

Get notified by email when there are changes.