If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link for Stock Market info
Is ther any way to link a cell to get info from a Stock Market site that
provides a quote for particular stock? i.e. Plug Stock XYZ price from Yahoo Finance (or any other site) into a cell. Thank you. |
#2
|
|||
|
|||
Link for Stock Market info
Hatter
You might want to check out Dataexternal dataNew web query, navigate to the site and select the data to enter in (Look under options on this dialogue for formatting options) and this will refresh whenever you want -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk web: www.excelusergroup.org "Hatter" wrote in message ... Is ther any way to link a cell to get info from a Stock Market site that provides a quote for particular stock? i.e. Plug Stock XYZ price from Yahoo Finance (or any other site) into a cell. Thank you. |
#3
|
|||
|
|||
Link for Stock Market info
Thank you very much Nick.
I've never seen anything like that before. I thought there would have to be all kinds of VBA code to work with. This is exactly what I want. Now let see how I can incorporate it into what I want to do. Thanks again....this is great! "Nick Hodge" wrote in message ... Hatter You might want to check out Dataexternal dataNew web query, navigate to the site and select the data to enter in (Look under options on this dialogue for formatting options) and this will refresh whenever you want -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk web: www.excelusergroup.org "Hatter" wrote in message ... Is ther any way to link a cell to get info from a Stock Market site that provides a quote for particular stock? i.e. Plug Stock XYZ price from Yahoo Finance (or any other site) into a cell. Thank you. |
#4
|
|||
|
|||
Link for Stock Market info
Sometimes there is no need to re-invent the wheel ;-)
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk web: www.excelusergroup.org "Hatter" wrote in message ... Thank you very much Nick. I've never seen anything like that before. I thought there would have to be all kinds of VBA code to work with. This is exactly what I want. Now let see how I can incorporate it into what I want to do. Thanks again....this is great! "Nick Hodge" wrote in message ... Hatter You might want to check out Dataexternal dataNew web query, navigate to the site and select the data to enter in (Look under options on this dialogue for formatting options) and this will refresh whenever you want -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk web: www.excelusergroup.org "Hatter" wrote in message ... Is ther any way to link a cell to get info from a Stock Market site that provides a quote for particular stock? i.e. Plug Stock XYZ price from Yahoo Finance (or any other site) into a cell. Thank you. |
Thread Tools | |
Display Modes | |
|
|