Fix my Google spreadsheet to pull in current stock exchange information
- or -
Post a project like this2319
$$
- Posted:
- Proposals: 7
- Remote
- #1812123
- Awarded
Description
Experience Level: Intermediate
General information for the business: Personal stock portfolio Google spreadsheet help
Description of support work: Create formulas to post current data to existing Google spreadsheet. Data like "52 Week Year High" , "52 Week Year Low" "Yesterday Closing Price" & "Current Price" for two stocks
I have formulas for most of my individual stocks but Google is not able to pull the information for certain stocks. The empty GREEN cells need help. Using my existing formulas does not work. Maybe the data can be pulled from Yahoo Finance or another website.
Once we agreed on the project I can give you access to my spreadsheet if you give me your email address and name.
Extra notes:
Description of support work: Create formulas to post current data to existing Google spreadsheet. Data like "52 Week Year High" , "52 Week Year Low" "Yesterday Closing Price" & "Current Price" for two stocks
I have formulas for most of my individual stocks but Google is not able to pull the information for certain stocks. The empty GREEN cells need help. Using my existing formulas does not work. Maybe the data can be pulled from Yahoo Finance or another website.
Once we agreed on the project I can give you access to my spreadsheet if you give me your email address and name.
Extra notes:
Steve B.
100% (3)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
27 Apr 2018
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Dear Steve i sorted out all the tickers you need and how to code it. Please let me know if you still need the job and my quotation was in line with your budget. Best regards
-
Could you tell me what stocks are the ones having problems?
Steve B.04 Dec 2017Great question. The regular stocks work fine. The extrange debt issues don't work with the normal Google scripts. Here's a list - SLRA, MDLX, THGA, ABRN, MVCB, GBLIZ, NSS & AIC
Joaquin M.04 Dec 2017Solar Capital Ltd. (SLRA)? i can work a way around to get that instead of google finance which seems like they dont track or report those ticker.
551932550842
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