Dividend Growth Forum › Dividend Growth Investing › Dividend Growth Investing v
Spreadsheets

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Spreadsheets
rayray Offline
Founding Member
*****
Posts: 1,002
Threads: 85
Joined: Apr 2015
Reputation: 16
#10
08-09-2015, 06:35 PM
(08-09-2015, 06:16 PM)earthtodan Wrote: One more thing, just as a last ditch try. Change the cell format to %.


Okay this worked but I had to replace all the "


=REGEXextract(REGEXreplace(index (importhtml(“http://finance.yahoo.com/q?s=”&A2&”&ql=1″, “table”, 3), 8, 2); “[()]”; “”) ; “([^/]*) “)


Found on this web page:

http://www.allaboutinterest.com/2014/05/...folio.html

This absolutely drove me crazy!! lol
Find
Reply


Messages In This Thread
Spreadsheets - by rayray - 08-09-2015, 10:14 AM
RE: Spreadsheets - by cannew - 08-09-2015, 10:35 AM
RE: Spreadsheets - by EricL - 08-09-2015, 11:41 AM
RE: Spreadsheets - by earthtodan - 08-09-2015, 12:39 PM
RE: Spreadsheets - by rayray - 08-09-2015, 02:05 PM
RE: Spreadsheets - by Caversham - 08-09-2015, 02:56 PM
RE: Spreadsheets - by earthtodan - 08-09-2015, 02:17 PM
RE: Spreadsheets - by rayray - 08-09-2015, 05:15 PM
RE: Spreadsheets - by earthtodan - 08-09-2015, 06:16 PM
RE: Spreadsheets - by rayray - 08-09-2015, 06:35 PM
RE: Spreadsheets - by Roadmap2Retire - 08-09-2015, 09:03 PM
RE: Spreadsheets - by Rasec - 08-10-2015, 11:00 AM
RE: Spreadsheets - by rapidacid - 08-10-2015, 12:19 PM
RE: Spreadsheets - by Rasec - 08-10-2015, 04:59 PM
RE: Spreadsheets - by earthtodan - 08-10-2015, 04:57 PM



Users browsing this thread: 9 Guest(s)