How do I get stock quotes in Excel without text?
Hi,
I have been spending a bit of time recently designing a spreadsheet to monitor my investments in the stock market. In doing this I have come to use the Office Refference tool a lot for gettting up to date stock quotes. In doing this it occurred to me that I could automatically update my spreadsheet using this tool, however when I do "Insert Price" into a cell, it displays text and numbers, e.g. "AUS:JST 2.07" which obviously doesnt work with formulas. Is there a way to get the Refference tool to insert only the "2.07" into a cell? Thanks in advance, -Simon |
Hi,
Was just playing around with web queries and I think I've solved the problem! But if anyone does have any good suggestions (mine is a bit messy at the moment), I would love to hear from you. -Simon "m_man" wrote: Hi, I have been spending a bit of time recently designing a spreadsheet to monitor my investments in the stock market. In doing this I have come to use the Office Refference tool a lot for gettting up to date stock quotes. In doing this it occurred to me that I could automatically update my spreadsheet using this tool, however when I do "Insert Price" into a cell, it displays text and numbers, e.g. "AUS:JST 2.07" which obviously doesnt work with formulas. Is there a way to get the Refference tool to insert only the "2.07" into a cell? Thanks in advance, -Simon |
All times are GMT +1. The time now is 07:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com