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.
Steve B.100% (3)
Create an account now and send a proposal now to get this project.Sign up
Clarification 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 2017
Great 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 & AICJoaquin M.04 Dec 2017
Solar 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.