Excel data analysis
- or -
Post a project like this- Posted:
- Proposals: 9
- Remote
- #1175670
- PRE-FUNDED
- Awarded
Description
The data is in an Excel file with 26 tabs, each represents a date.
The raw data in each tab comprises in the first row a Confirmation of either a Short or a Long. Following this first line is then a further series of Impulses which will be in the opposite direction to the Confirmation. In other words, if the Confirmation is a Short, the following Impulses with then be Buy.
Each row has:
i. Date in the M/DD/YYYY format
ii. Time expressed in the 24 hour clock format hh:mm:ss
iii. An entry price which can be a whole number to one decimal place which is either Zero or point five (0.5). (It should be in the range of 8,000 to 16,000 – although this is not so important, but can be used for data validation purposes – i.e. not 99,980 for example).
iv. The following field is then either “Confirmation of Short (or Long) OR “Buy” or “Sell” – the rule is that if the Confirmation is Short, the following Impulses will be Buy, and vice versa.
The raw data then needs to be re-organised as per the data in the tab 20_Apr_2016, which is in the workbook. Each worksheet(tab) is up to column R (18) and can be up to 600 rows.
I have attached an example of the raw data from one of the tabs.
Charles W.
0% (0)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
yes, please attach reorganized data to the project. Thanks
-
Hi Charles - would you please explain more the goal of the analysis, because in your job description only describe the attachment files, I'll help you soonest - thanks, Adrian
-
Hi Charles - I've take a look at your file, would you explain more the expectation of the analysis, because I only find the description of the attachment in your job post... I'll help you soonest, thanks - Adrian
-
Hello.
It seems that the tab "20_Apr_2016" is missing from the XLS file you uploaded, so it isn't quite clear what is the exact "re-organisation" you require. -
Would it be possible to see a screen shot (or maybe even an example file) of tab 20_Apr_2016?
At the moment I can download the raw data example but I can't see the format that data should be in.