Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
web query and changing URL's
Sorry Don,
With each of my earlier posts, I received a netscape error that said there was a problem with the data I sent, so I tried again, and again, and .... "Don Guillett" wrote: BTW. I discovered your earlier posts. This is NOT the way to win friends and influence people around here. Post and wait..... -- Don Guillett SalesAid Software "joev7777" wrote in message ... I am writing macros that perform web queries to download stock data from Anumati.com the anumati.com format is like this: http://www.anumati.com/DynamicReport...R&report=IS-Q& dates _ =03/07/2004;03/04/2004;31/12/2003;27/09/2003;28/06/2003; _ 29/03/2003;31/12/2002;28/09/2002 The dates change depending on the stock symbol you input (TR) in this case. The way I have written the macro currently is to determine the year end that the company is using, then assume quarterly ending dates based on the year. ie. if the year end is Dec. 31, 2004, quarterly ending date would be March 31, June 30, Sept. 30, Dec. 31. I have accomodated year ends for each month and the corresponding quarters (3 month periods - last day of month) based on the year. I am using string formulas to create a URL as follows: A2 = http://www.anumati.com/DynamicReport.aspx?id= A3 = Stock Symbol you entered (TR in the example above) A4 = &report= A5 = the report you requested (IS-Q = Income Stmt - Quarterly) A6 = & dates= A7 = The dates I have calculated using the determined year end A1 = A2&A3&A4&A5&A6&A7 A1 is the string I use in the web query macro as the URL to download As you can see from the URL above, the quarter end dates are not necessarily the end of the month, and it is not necessarily 3 month periods. That is where my logic breaks down. Is there an easier to develop dynamic web queries (by that I mean tell Anumati to show me the quarter data, regardless of what those periods actually are). The string method I am using works great for most of the companies, but there are always those that don't fit the mold. Thanks. any help would be appreciated! Joe V. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help comparing data from different URL's. | Excel Worksheet Functions | |||
how do i get all url's in a column to highlight? | New Users to Excel | |||
Web Query & changing URL's | Excel Programming | |||
web query & changing URL's | Excel Programming | |||
web query and changing URL's | Excel Programming |