After some trial and error, I was finally able to import, extract, and convert the quote into US dollars.In case anyone else has to do this in the future, I used the link I provided earlier and imported the three tables containing the stock information. I extracted the quote by using the following formula:"=MID(A133,FIND("price",A133)+5,FIND("(",A133)-FIND("price",A133)-5)"where A133 contains the stock embedded inside like so:"Recent price1215(14:59) -65 -5.07 %"
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar. Earnings Estimates, Analyst Ra