
Google Sheets Expert
- or -
Post a project like this1145
£28(approx. $38)
- Posted:
- Proposals: 6
- Remote
- #3655703
- Awarded
Excel | Google Sheets | Dashboards | Google Apps Script | VBA Macro | Automation

DATA ENTRY EXPERT |WEB SCRAPPING | PYTHON SCRAPPING | BEAUTIFUL SOAP|ADMIN ASSISTANT

Quick Graphic Designer + Animator + Video Editor + Photo Editor + Logo Designer + Autocad Designer

Data Consultant (Expert in Excel, VBA/Macros, Google Sheets, Fillable Pdf services, Data Entry)
536505030753106476906552447666081737026817





Description
Experience Level: Entry
I'm looking for someone to help me write a couple formulas.
For the sheet below:
https://docs.google.com/spreadsheets/d/1px03UiFEcTUWQ5JEqDZT31fFUyFpuAWkAGKtJQwwdoo/edit?usp=sharing
I'm hoping someone can help me integrate the following equations into column P:
Calculate a momentum score for each of the 16 ETFs. The authors of the strategy use a “13612W” score – a bit of a mouthful, but here’s how you work it out:
13612W = (12 (p0 / p1 – 1)) + (4 (p0 / p3 – 1)) + (2 * (p0 / p6 – 1)) + (p0 / p12 – 1)
Where p0 = the ETF’s price today, p1 = the ETF’s price one month ago, p3 = the ETF’s price three months ago, and so on.
The first term – (p0 / p1 – 1) – is the ETF’s percentage price change over the past month, and the second term – (p0 / p3 – 1) – is the ETF’s percentage price change over the past three months. You get the idea. Also, notice how the 13612W score overweights the most recent returns: the ETF’s one-month performance is multiplied by 12, its three-month performance is multiplied by a third of that (four), and so on. This gives more recent returns a greater impact on the strategy than older ones.
And for the second sheet I need to query the email addresses in 1 tab
And then populate those emails into another tab where the names on tab 2 and tab 1 match
Else return blank cell
For the sheet below:
https://docs.google.com/spreadsheets/d/1px03UiFEcTUWQ5JEqDZT31fFUyFpuAWkAGKtJQwwdoo/edit?usp=sharing
I'm hoping someone can help me integrate the following equations into column P:
Calculate a momentum score for each of the 16 ETFs. The authors of the strategy use a “13612W” score – a bit of a mouthful, but here’s how you work it out:
13612W = (12 (p0 / p1 – 1)) + (4 (p0 / p3 – 1)) + (2 * (p0 / p6 – 1)) + (p0 / p12 – 1)
Where p0 = the ETF’s price today, p1 = the ETF’s price one month ago, p3 = the ETF’s price three months ago, and so on.
The first term – (p0 / p1 – 1) – is the ETF’s percentage price change over the past month, and the second term – (p0 / p3 – 1) – is the ETF’s percentage price change over the past three months. You get the idea. Also, notice how the 13612W score overweights the most recent returns: the ETF’s one-month performance is multiplied by 12, its three-month performance is multiplied by a third of that (four), and so on. This gives more recent returns a greater impact on the strategy than older ones.
And for the second sheet I need to query the email addresses in 1 tab
And then populate those emails into another tab where the names on tab 2 and tab 1 match
Else return blank cell

Beyond The Beat T.
100% (33)Projects Completed
26
Freelancers worked with
22
Projects awarded
39%
Last project
4 Apr 2025
United Kingdom
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.
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