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