Quick and easy excel job - please only bid if you can do this today.
- Posted:
- Proposals: 3
- Remote
- #1776344
- Awarded
have already sent a proposal. Description
Experience Level: Intermediate
In attachment you will find an excel file of 1 minute FX EURO prices.
Column A= date
Column B = Time
Column C = Closing price
I need you to perform two steps using this file:
1. Plot the closing 15 minute price on a line chart. This can be done by taking the price for cell C15 then cell C30 then cell C45 etc etc and plotting them. Easy
2. Now I want you to take each bunch of 15 one minute observations so cells C1 to C15, C16-C30, C31 add up each of those cell blocks and divide by fifteen. Meaning get the average closing price of the each of those cell blocks. These results should be plotted on the same graph.
That's it. Quick and easy. Thx
Column A= date
Column B = Time
Column C = Closing price
I need you to perform two steps using this file:
1. Plot the closing 15 minute price on a line chart. This can be done by taking the price for cell C15 then cell C30 then cell C45 etc etc and plotting them. Easy
2. Now I want you to take each bunch of 15 one minute observations so cells C1 to C15, C16-C30, C31 add up each of those cell blocks and divide by fifteen. Meaning get the average closing price of the each of those cell blocks. These results should be plotted on the same graph.
That's it. Quick and easy. Thx
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.