Question: how to find alpha and beta in excel?
Answer: Download historical security prices for the asset whose beta you want to measure. Download historical security prices for the comparison benchmark. Calculate the percent change period to period for both the asset and the benchmark. ...  Find the Variance of the asset using =VAR.