Dear 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.
Thank you very much.
You have not provided much detail. How much of this question is specific to Excel ("I know how to identify resistance (and/or support) by using [unspecified] algorithm/method, but I don't know how to implement that algorithm/method in Excel.") and how much not ("I don't know how anyone using any programming language identifies resistance (and/or support).")
I don't do financials so I don't know the second answer. Most sites my internet search comes up with show generic, manual, graphical approaches. (example: http://www.swing-trade-stocks.com/su...esistance.html ). This one mentions a "Fibonacci retracement" algorithm, but gives no details: https://www.investopedia.com/trading...stance-basics/ I (and maybe others here as well) will need to you to explain the algorithm/methodology you want to use for this analysis before we can help you implement that algorithm/methodology in Excel.
Here's how I would expect to develop this:
1) Research algorithms/methods for performing the analysis.
2) Implement the analysis for a single stock data set.
3) Expand analysis to "filter" a larger list and perform the analysis.
Which part do you need help on?
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks