Further Excel work - extrapolate trading ideas from Weekly FX data
- or -
Post a project like this2523
$$
- Posted:
- Proposals: 4
- Remote
- #1518194
- Awarded
Description
Experience Level: Intermediate
Hi Ignas,
Overview
Simple job,to analyse some Foreign Exchange trading prices and extraploate potential trading ideas.
In attachment you will find an xls file with weekly data. Inside the file the columns contain data with date, open, high,low and close.
I am looking for you to help analyse this data and further my own research.
Introduction
Each row in the xls represents one weeks trading FX – EURO/USD
I need some simple stats based on looking at the previous weeks trading results, then seeing what happens this week based on the previous weeks activity.
Tasks
1. Look at each week’s trading and establish if the open price of the week starts within the top or bottom 20% of the trading.
2. Look at each weeks trading and establish if the close price of the week starts within the top or bottom 20% of the trading.
3. The 20% figure quoted in 1 and 2 should be a variable which can I set so instead of 20% I might want 10%.
4. Create a column to show if the week was an UP or DOWN week.
5. Using the information gained in 1 and 2 look at the previous weeks trading and for UP weeks note if the open of the previous week was within the bottom 20% of the range(figure available from 1) AND look to see if the Close of the weeks trading ended in the top 20% of the range. If YES to this then in a fresh column set the previous weeks value for this equation to Y otherwise set it to N.
6. Using the information gained in 1 and 2 look at the previous weeks trading and for DOWN weeks, note if the open of the previous week was within the top 20% of the range(figure available from 1 AND look to see if the close of the weeks trading was in the bottom 20% of the range. If YES to this then in a fresh column set the previous weeks value for this equation to Y else N.
We have now established which weeks have set up according to our criteria.
The next step is to see what happens in the following weeks trading .
7 For UP previous weeks with equation result = Y look at the current weeks trading results and see if price breached the HIGH of the previous week, if yes then create a new coumn with Y, (High Breached) otherwise N.(High Not Breached)
8 Where the result of 7 was Y then the next step is to see if the CLOSE price of the week was higher or lower than the HIGH price of the previous week. Create a new column with Y or N based on the result to this question.
9 Total the results in terms of the number Y/N generated by 8. That is to say if we had 50 Y/Ns then produce that total, compared to the and the percentage Y and percentage N.
10. Do the reverse steps 7 to 10 for DOWN days.
The initial analysis has been completed. Now we need to look at how far prices broke the high on UP days where prices ultimately closed below the previous weeks close. We use the results of 7 to do this.
We also need to do the reverse for DOWN days.
11.So where the value was a Y in 7 we measure the pips travelled above the high and we measure the percentage travelled when compared to the previous weeks trading range. New columns can show this.
12 Reverse for DOWN days.
13. We also need a global total of how many travelled 10% above, 20% above , 30%, above, 40% , 50% above before breaking back down below to close
14 Reverse for UP days.
15. Finally we also need to measure the percentage of weeks where the previous week had a Y in 7 then the current week closed below the previous week HIGH.
16 Reverse for DOWN days and we use the LOW as the break point.
If there are questions please do not hesitate to ask.
Overview
Simple job,to analyse some Foreign Exchange trading prices and extraploate potential trading ideas.
In attachment you will find an xls file with weekly data. Inside the file the columns contain data with date, open, high,low and close.
I am looking for you to help analyse this data and further my own research.
Introduction
Each row in the xls represents one weeks trading FX – EURO/USD
I need some simple stats based on looking at the previous weeks trading results, then seeing what happens this week based on the previous weeks activity.
Tasks
1. Look at each week’s trading and establish if the open price of the week starts within the top or bottom 20% of the trading.
2. Look at each weeks trading and establish if the close price of the week starts within the top or bottom 20% of the trading.
3. The 20% figure quoted in 1 and 2 should be a variable which can I set so instead of 20% I might want 10%.
4. Create a column to show if the week was an UP or DOWN week.
5. Using the information gained in 1 and 2 look at the previous weeks trading and for UP weeks note if the open of the previous week was within the bottom 20% of the range(figure available from 1) AND look to see if the Close of the weeks trading ended in the top 20% of the range. If YES to this then in a fresh column set the previous weeks value for this equation to Y otherwise set it to N.
6. Using the information gained in 1 and 2 look at the previous weeks trading and for DOWN weeks, note if the open of the previous week was within the top 20% of the range(figure available from 1 AND look to see if the close of the weeks trading was in the bottom 20% of the range. If YES to this then in a fresh column set the previous weeks value for this equation to Y else N.
We have now established which weeks have set up according to our criteria.
The next step is to see what happens in the following weeks trading .
7 For UP previous weeks with equation result = Y look at the current weeks trading results and see if price breached the HIGH of the previous week, if yes then create a new coumn with Y, (High Breached) otherwise N.(High Not Breached)
8 Where the result of 7 was Y then the next step is to see if the CLOSE price of the week was higher or lower than the HIGH price of the previous week. Create a new column with Y or N based on the result to this question.
9 Total the results in terms of the number Y/N generated by 8. That is to say if we had 50 Y/Ns then produce that total, compared to the and the percentage Y and percentage N.
10. Do the reverse steps 7 to 10 for DOWN days.
The initial analysis has been completed. Now we need to look at how far prices broke the high on UP days where prices ultimately closed below the previous weeks close. We use the results of 7 to do this.
We also need to do the reverse for DOWN days.
11.So where the value was a Y in 7 we measure the pips travelled above the high and we measure the percentage travelled when compared to the previous weeks trading range. New columns can show this.
12 Reverse for DOWN days.
13. We also need a global total of how many travelled 10% above, 20% above , 30%, above, 40% , 50% above before breaking back down below to close
14 Reverse for UP days.
15. Finally we also need to measure the percentage of weeks where the previous week had a Y in 7 then the current week closed below the previous week HIGH.
16 Reverse for DOWN days and we use the LOW as the break point.
If there are questions please do not hesitate to ask.
Paul L.
100% (20)Projects Completed
21
Freelancers worked with
16
Projects awarded
69%
Last project
24 Feb 2019
Belgium
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Paul,
Thanks for your invitation, It seems to be the attachment is missing can you please attach the file or send me the file. so that I can have better clarity on your requirement.
Regards,
HarshaPaul L.21 Apr 2017Hi, Sorry I will add the attachment later today when I am in my office. Kind regards Paul
-
Hi Paul,
Thank you for the invitation. However, I don't see any file attached here.
Can you please attach your data again or send it directly to me, so I can have a better understanding of your requirements.
Thanks
Kris
Paul L.21 Apr 2017Hi, Sorry I will add this later today. Kind regards
Paul
396087395872
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies