InvestorsHub Logo
icon url

Jammin1

09/09/13 11:58 PM

#98895 RE: growthstocks #98889

Thanks for the tip on the ihub historical prices. I'd always gotten complaints about needing to clear the cookies on my browser when I tried to use ihub tools, and never bothered to fix that, so I didn't know what their tools could do.

Anyway, with the data downloaded to spreadsheet, it was easy. I took the average of open, high, low, close for each day, multiplied by volume to get an estimate of dollar volume for each day, then divided 90 day dollar volume by 90 day volume to get a weighted average 90 day price of:

.0124

(barely needing roundoff, too, as it was .012399665)

By the way, the STRAIGHT (non-weighted) average of closes is .0114.
The straight average of open, high, low, close for the 90 days is .0113.