Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Data Analysis,Microsoft Excel,Report freelancer for Simple Intraday Stock Price Check going back 3 years for 3 stocks. job

Posted at - Feb 29, 2024

Toogit Instant Connect Enabled

I'm doing research on basic movement in stock prices for US stocks. I've been doing it manually, it's too time consuming that way for me. I'm looking to compare daily price movements at specific times once a week going back 3 years. I'm looking solely at Google [GOOG]. This shouldn't take you more than 20 minutes if you are skilled, but could take an hour or two if you plotting everything manually.

This is not a long term contract, but I will keep the contract open possibly for additional milestones for basic analysis. Typically, each milestone will be for $5, since they are simple calculations. But there is room for negotiation if/when they are more complicated. Current milestone would need to be completed within 5 days. Each additional milestone would be 3-4 days, but you would have the opportunity to decline the milestone before it is added.

The only skills you need are

A. How to find your own accurate data for stock prices (in this case Google, ticker symbol GOOG) at specific times (Thursday Noon Eastern, Thursday Close, Friday Open, Friday Noon Eastern) on your own from an online or other source (which I will check against my own source). Be sure the data shows the time, otherwise it's not helpful, and the prices are for US markets in US dollars.

B. Create a basic spread sheet with perhaps minor spread sheet analysis and graphs or tables. You can do this through an algorithm, manually, app, or a hybrid as long as I can get the desired output (a spread sheet with the data explained below) plus a graph (possibly).

All I need is a spreadsheet that list data in 9 columns and 156 rows. You will need to check the stock price at specific times [GOOG Price at Noon Eastern [Thursdays] column 1, GOOG Price Closing bell [Thursdays] column 2, GOOG Price at Noon Eastern Column 3, GOOG Price Opening bell [Friday's] Column 4. [Weeks where there is a holiday on Thursday and/or Friday will be excluded]

Leave column 5 blank; for columns 6-8, I'm looking for column 3 - column 1 (column 6); column 4 - column 1 (column 7); & column 4- column 2 (column 8). [Columns 6-8 are basically calculating the price change if I held GOOG for 1 day based on Thursday's purchase time (either noon to noon, or noon to opening bell, or closing to opening). Leave column 9 blank. Column 10 will be five simple cells; the first cell in column is the total number of times column 6 is $50 or greater, the second when column 7 is $50 or greater, third cell in column 10 when column 8 is $50 or greater, fourth cell the number of times when any value in 6-8 was $25 or greater [multiple times only count once for that week], and fifth cell the same as fourth except for $50 or greater instead of $25.

The purpose of this is to check underlying stock volatility for 1-day options trading on GOOG stock done weekly. You don't need to know how to trade stocks or options, but basic knowledge is helpful and could lead to additional periodic, irregular work.

About the recuiterMember since Sep 8, 2017 Moe Gomez
from Gibraltar, Gibraltar

Skills & Expertise Required

Data Analysis Microsoft Excel Report 

Open for hiringApply before - Feb 28, 2025

Work from Anywhere
40 hrs / week
Hourly Type
Remote Job

Offer to work on this project closes in 320 days!
Are you interested in this Opportunity?

Apply Now

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Apply on more work from home jobs posted in Data Mining And Management category.

Related Jobs

Latest In Data Analysis Jobs

Latest In Microsoft Excel Jobs

Latest In Report Jobs