Good day,
I have created a spreadsheet that has cells linked to a financial services provider of real time stock quotes. These links utilize URL formulae such as:
symbol)
This command line I enter into the menu item Data\Get external data\New web query.
It returns a data streamline containing salient information on the selected stock all into a specific cell.
Then I again access the menu item Data\Text to columns to undeliminate the data stream into another designated group of cells.
Finally, I selected the cell containing the deliminated data stream, and select the External Data toolbar Refresh control (2nd icon from the left), and select a refresh rate at the fastest available which is 1 minute intervals.
With the underlying stock quote provider program running, this then updates the deliminated data stream cell data every minute, BUT IN TURN DOES NOT UPDATE THE UNDELIMINATED DATA IN THE ROW OF CELLS CREATED IN THE TEXT TO COLUMNS UNDELIMINATION PROCESS.
This is my dilemma. How do I get Excel to automatically update the final data line ?
Additionally, I would prefer to automatically update more frequently than 1 minute. Is that possible and if so how ? Ideally I would have a continuously and constantly updating stock grid of real time data.
Thanks in advance for any suggestions.
PS: I'm using W98 2nd edition on a PIII and WXP on a PIV machine.
I have created a spreadsheet that has cells linked to a financial services provider of real time stock quotes. These links utilize URL formulae such as:
symbol)
This command line I enter into the menu item Data\Get external data\New web query.
It returns a data streamline containing salient information on the selected stock all into a specific cell.
Then I again access the menu item Data\Text to columns to undeliminate the data stream into another designated group of cells.
Finally, I selected the cell containing the deliminated data stream, and select the External Data toolbar Refresh control (2nd icon from the left), and select a refresh rate at the fastest available which is 1 minute intervals.
With the underlying stock quote provider program running, this then updates the deliminated data stream cell data every minute, BUT IN TURN DOES NOT UPDATE THE UNDELIMINATED DATA IN THE ROW OF CELLS CREATED IN THE TEXT TO COLUMNS UNDELIMINATION PROCESS.
This is my dilemma. How do I get Excel to automatically update the final data line ?
Additionally, I would prefer to automatically update more frequently than 1 minute. Is that possible and if so how ? Ideally I would have a continuously and constantly updating stock grid of real time data.
Thanks in advance for any suggestions.
PS: I'm using W98 2nd edition on a PIII and WXP on a PIV machine.
Ireland is beautiful - when the sun's out (perhaps about twice a year as I recall....) Rain is why I left the UK - I'm very much a sun worshipper. 