Financial Markets VBA or Google Sheets Analysis
Budget: $15 – $25 USD
The following is the scope of the project we would pull if possible data from the web yahoo finance or another:
The scope of the Project:To analyse data based upon a specific strategy which is the following:
Strategy:
0) Previous trading sessions closing time XXX1) Analysis of the 1st. 5 minute candlestick (opening price)
2) The previous day's closing price - the opening price= GAP then GAP plus 2 ticks or points then divided by 2 gives the final figure the minimum gap should be XXXXXXX 2a) The previous day's closing price - the opening price= GAP then GAP plus 2 ticks or points3) if the price of 1) is above the closing price 0) we short/sell. If the price of 1) is below the closing price of 0) we long/buy4) The entry should be the opening price.5) The exit should be the same distance is the final figure of 2 find this out on one minute figures the same for 2a6) The take profit should be the same profit as the final figure in 2 find this out on one minute figures the same for 2a
Consultancy to use your skills to adjust and or provide suggestions on optimisation to extract the most profit from the market.
VBA/Excel Capabilities:
The above strategy will be used for 2 stocks links to info TBA the data set will be provided and it will be webscarped to be kept upto date:
Regression Analysis:
Out of regression analysis is to show the following:The closing of orderThe percentage difference in the closing price and entry price Profit/Loss in Points or TicksThe days that are the most profitableThe ability to specify a time range for analysis aboveTo provide an optimisation tool for the ability to make a profitan Output would be is the optimal profit factor following Percentage difference in
The spread sheet should be able to update itself with the following information daily drawing on data from outside:
The profit and lossThe entry and exitAdditional Requirements to TBC and Discussed:The spread sheet should be flexible that any data can be loaded easily that uses the same strategies and gives an output.The spread sheet should be adjustable for time frames.
Ok let me know what you think and the hours it might take
The scope of the Project:To analyse data based upon a specific strategy which is the following:
Strategy:
0) Previous trading sessions closing time XXX1) Analysis of the 1st. 5 minute candlestick (opening price)
2) The previous day's closing price - the opening price= GAP then GAP plus 2 ticks or points then divided by 2 gives the final figure the minimum gap should be XXXXXXX 2a) The previous day's closing price - the opening price= GAP then GAP plus 2 ticks or points3) if the price of 1) is above the closing price 0) we short/sell. If the price of 1) is below the closing price of 0) we long/buy4) The entry should be the opening price.5) The exit should be the same distance is the final figure of 2 find this out on one minute figures the same for 2a6) The take profit should be the same profit as the final figure in 2 find this out on one minute figures the same for 2a
Consultancy to use your skills to adjust and or provide suggestions on optimisation to extract the most profit from the market.
VBA/Excel Capabilities:
The above strategy will be used for 2 stocks links to info TBA the data set will be provided and it will be webscarped to be kept upto date:
Regression Analysis:
Out of regression analysis is to show the following:The closing of orderThe percentage difference in the closing price and entry price Profit/Loss in Points or TicksThe days that are the most profitableThe ability to specify a time range for analysis aboveTo provide an optimisation tool for the ability to make a profitan Output would be is the optimal profit factor following Percentage difference in
The spread sheet should be able to update itself with the following information daily drawing on data from outside:
The profit and lossThe entry and exitAdditional Requirements to TBC and Discussed:The spread sheet should be flexible that any data can be loaded easily that uses the same strategies and gives an output.The spread sheet should be adjustable for time frames.
Ok let me know what you think and the hours it might take