find out RESISTANCE LINES or values in stock data by VBA

[Isaacliu]

Dear all expert

i am the beginner of excel user, but i want to find out the RESISTANCE LINES or values in stock data, these are price levels that consistently reject attempts to exceed above (resistance), means the price frequency alwasy up to this pice level and back again, how can i use excel to do this. and there are many stock number here, please see attachments.

the method is here, https://www.stockinfinities.com/arti...sistance-level
the website provide the excel, https://www.dropbox.com/s/fwhsjw0cib...lator.xls?dl=0 , but i dont know how to combine to my excel, please help.



Thank you very much.

[MrShorty]

It seems so simple, that I wonder if I am missing something.

1) According to stockinfinities, the first step is to calculate the pivot point, which is just the average over the day. In I1, I might enter "pivot". In I2, I might enter =AVERAGE(C2:E2) (their formula 1) or =AVERAGE(B2:E2) (their formula 2). Copy formula down.
2) They give three formulas for resistance, based on each day's open-high-low-close data and the pivot point calculated in step 1. It's not clear to me which one you want to use, but they are simple enough. If I choose formula 1 for resistance, I might enter =2*I2-D2 into J2 (I enter "resistance" in J1). Copy formula down. Similar for support in column K.

Is it as simple as that, or is there something I am missing?