Google Sheets Script Needed

$15-25 USD / hour

Completed

Posted

over 4 years ago

$15-25 USD / hour

I need four scripts that work in Google Sheets. On certain signals, I need data copied and pasted from one tab to another. I also need three macros. On the spreadsheet below, in column I, there appear four phrases Enter Long, Close Long, Enter Short, Close Short. I need script that keys off those entries -- for instance when it encounters "Go Long" in a particular column, it copies four cells, moves to the next TAB, pastes the copied cells there, then highlights the row or changes the font color so I can easily find all changes. There are four such commands or actions required. If you respond, please include “write four Google Sheets scripts” so I know you’ve read this. Please estimate time involved. The view-only link to the sheet I need help with: [login to view URL] See Project Notes Tab. Please respond if: • have an excellent rating on this platform or can provide client references • are available to discuss (not via Chat) the project and are fluent, easy to understand in English. • are available to work at least some Eastcoast US business hours My website [login to view URL]

Excel VBA

Matlab and Mathematica

Project ID: 23374333

About the project

11 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@MonisZafar

Write Four Google Sheets Script Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.

$15 USD in 40 days

5.0

(7 reviews)

3.3

11 freelancers are bidding on average $18 USD/hour for this job

@williams115

Hi there - My name is Phong. I’ve read your brief and I am very interested in this project because I have good knowledge and rich practical experience in these fields. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio. Regards.

$20 USD in 40 days

4.9

(32 reviews)

5.8

@zekovicm

Hi there,I am Google Sheets expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

$20 USD in 40 days

4.9

(2 reviews)

3.9

@writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps

$15 USD in 10 days

5.0

(8 reviews)

3.3

@VittorioLombardo

Hi there! I have read your description carefully and I am confident I can full fill your requirement. I provide my skills in hopes of working with you. I am a web scraper and have 5+years of ample experienced in web scraping. I can extract data on any website using python and PHP script(beautiful soup, selenium, scrapy, phantomJS) I can save data scraped into xlsx, CSV, MySQL and etc using CSV module and xlsxwriter please feel free to contact me if you want. I look forward to working back with you. Thank you

$20 USD in 40 days

4.2

(1 review)

2.0

@manuelmata3000

Hello, I can do Google Sheets script for exponential moving average. I have the necessary skills to carry out this task, but I submit for your consideration: • have an excellent rating on this platform or can provide client references ( Yes, but only 3) • are available to discuss (not via Chat) the project and are fluent, easy to understand in English. ( No, only via chat) • are available to work at least some Eastcoast US business hours ( Yes, I can adapt to your schedule ) I estimate that about 4 or 5 hours of work are necessary to finish this job and validate it in a satisfactory way. Feel free to contact me, regards

$20 USD in 40 days

5.0

(1 review)

1.6

@jsmnrwl

Hi there! I came across your post and found that my expertise is the best fit for this job. So, I’d like to work with you to produce the best result. Along with that, I can assure you that my rates are more than reasonable in the market. I believe I'm the best candidate for this project. Please give me a chance to prove my skills. So, please send me a message so that we can discuss more. Best regards, Sujan

$20 USD in 40 days

0.0

(0 reviews)

0.0

@RealmanY

Greetings! I have read your instruction and I know well about what you want. I made similar work as yours, and want to know the detailed requirement. Looking forward working with you. Best regards.

$20 USD in 40 days

0.0

(0 reviews)

0.0

@idragon712

Dear Client! I am sure that I can deliver perfect results , having read your description carefully. I understood what I have to do for you in this project, otherwise your strategy of business. Google app script/Google add on I see that you're based in USA, but I can work according to your timezone with full-time job. Thanks for taking your precious time, and Hope you're doing great. Best Regards.

$16 USD in 40 days