Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Getting Yahoo Stock Quotes by a USer Defined Function
Hi,
Is there a user defined function in excel which can get the share quotes over the internet from Yahoo Finance website? Thanks Mukesh |
#2
|
|||
|
|||
Someone has almost certainly written a UDF that does that. But I find it
much simpler to use a sub rather than a UDF, along these lines: 1. I've established an external data range with a query of the website 2. I call, once only, a subroutine named PickUpData that includes this statement: ThisWorkbook.Sheets("QuerySheet").QueryTables(1).R efresh BackgroundQuery:=False and later on in that sub, I call this sub: Sub DoItAgain() Application.OnTime Now + TimeValue("00:59:00"), "PickUpData" End Sub In this way, I can just walk away and let Excel refresh the external data range, in turn refresh a pivot table based on that range, save the workbook and thus the pivot table, and wait almost another hour before it Does It Again -- that is, before it calls PickUpData and brings new data into the external data range. There's almost surely a more elegant method, but this was quick and dirty and it works for me. -- C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 "MS Office" wrote in message ... Hi, Is there a user defined function in excel which can get the share quotes over the internet from Yahoo Finance website? Thanks Mukesh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Yahoo Stock Quotes by a USer Defined Function | Excel Discussion (Misc queries) | |||
Add or delete symbols Stock Quotes | Excel Discussion (Misc queries) | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
User defined charts- font size too small | Charts and Charting in Excel | |||
Stock Quotes in Excel 2003 | Excel Discussion (Misc queries) |