Yesterday's lowest price: =REF(L,1);
Yesterday's closing price: =REF(C,1);
Average price: (yesterday's highest price+yesterday's lowest price+yesterday's closing price)/3;
Ah: 2* average price+yesterday's highest price -2* yesterday's lowest price;
NH: average price+average price-yesterday's lowest price;
NL: average price+average price-the highest price yesterday;
AL:2* average price -2* yesterday's highest price+yesterday's lowest price;
So, you can understand. If you don't understand the algorithms and the relationship between them, you will be really helpless.