ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to retrieve current market gold prices for use in excel (https://www.excelbanter.com/excel-discussion-misc-queries/164091-how-retrieve-current-market-gold-prices-use-excel.html)

Greg

how to retrieve current market gold prices for use in excel
 
How do you retrieve current market gold prices for use in caluclations in an
Excel calculation?

www.exciter.gr: Custom Excel Applications!

how to retrieve current market gold prices for use in excel
 
The easiest way is to open a website that has a table with desired
values in internet explorer, right click on the data table on page and
select 'export to excel' command. A new workbook will open and it will
be connected to that specific table on page. If you right click on
excel data at any time and select 'refresh' you will get the new
values. You can also set that data to autoupdate at a time interval.


www.exciter.gr
Custom Excel Applications and Functions!

On Oct 30, 7:27 pm, Greg wrote:
How do you retrieve current market gold prices for use in caluclations in an
Excel calculation?





All times are GMT +1. The time now is 07:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com