derive formulas for correct calculation of Schaff Trend Cycle indicator
Budget: $30 – $250 USD
I have an excel sheet to construct with working formulas. The outline is provided (attached). It must be created with all formulas inserted correctly utilizing 4 editable input variables. Formulas created should be based only from one of the code examples from a reference list (also attached).
You will be recreating this sheet with the actual formulas inserted into columns I thru S so that it is correct for the Schaff Trend Cycle calculation which you will need to research how to complete yourself. I will not be able to help with how to calculate the STC. The references are there for you to figure it out. This is what the project is all about. You can take the code from the references and figure out how to make each column’s calculation. The Schaff Trend Cycle calculation oscillates between 0 and 100. Our developer will code your formulas into our DLL.
On the sheet provided, you will use the column entitled “Close” for all the calculations, and the variables that we must be able to change are found in cells: V8 thru V11. Assume that cell V12 is always “Yes”. The tricky part may be how to begin each of the calculations. The calculations must begin with the minimum number of rows for the first calculation.
"Almost" is NOT good enough. I will hold you to a very high standard, please understand this. Also, please only use any of the links within the reference list of 4 code examples as your resource to derive the column formulas. I will know if another source is used and project will NOT be accepted if another source is used. I will know if you have created your own formulas (required)!
I may not always be available but will respond within 24 hours. I need this completed by end of this week (Friday) in the US.
You will be recreating this sheet with the actual formulas inserted into columns I thru S so that it is correct for the Schaff Trend Cycle calculation which you will need to research how to complete yourself. I will not be able to help with how to calculate the STC. The references are there for you to figure it out. This is what the project is all about. You can take the code from the references and figure out how to make each column’s calculation. The Schaff Trend Cycle calculation oscillates between 0 and 100. Our developer will code your formulas into our DLL.
On the sheet provided, you will use the column entitled “Close” for all the calculations, and the variables that we must be able to change are found in cells: V8 thru V11. Assume that cell V12 is always “Yes”. The tricky part may be how to begin each of the calculations. The calculations must begin with the minimum number of rows for the first calculation.
"Almost" is NOT good enough. I will hold you to a very high standard, please understand this. Also, please only use any of the links within the reference list of 4 code examples as your resource to derive the column formulas. I will know if another source is used and project will NOT be accepted if another source is used. I will know if you have created your own formulas (required)!
I may not always be available but will respond within 24 hours. I need this completed by end of this week (Friday) in the US.