J
joev7777
I am writing macros to do Web Queries using Excel 2003 and downloading the
information from Anumati.com
When you type in a stock symbol at Anumati.com, you are given a new web page
to select what type of reports you want to see, Quarterly or Annually. After
you make your selection, it displays the requested report in the following
format:
http://www.anumati.com/DynamicRepor...3;28/06/2003;29/03/2003;31/12/2002;28/09/2002
It uses specific dates at the end of the URL for the Quarterly Report of
each company.
I originally thought that once I figured out what Year End a company was
using, I could assume Quarterly ending periods. ie. YrEnd = Dec. 31,2004 -->
QtrEnd = March 31, June 30, Sept 30, Dec. 30. But as you can see from the
example above, Quarter ends don't necessarily mean last day of the month for
each 3 month period.
I built a macro that uses these dates to build a string with the correct
URL to download. But my logic breaks down when a company has non-standard
quarter or annual ending dates, ie
A2 = http://www.anumati.com/DynamicReport.aspx?id=TR&report=
A3 = Report requested (IS-Q - Income Statement Quarterly)
A4 = &dates=
A5 = quarter ending dates as determined by finding the correct year ending
date
A1 = A2&A3&A4&A5
A1 is the string that I use in the macro as the URL to download.
Is there an easier way to accomplish the same task without building a text
string to use as the URL? As I mentioned the dates can change depending on
what company you select.
I would appreciate any help.
Thanks
information from Anumati.com
When you type in a stock symbol at Anumati.com, you are given a new web page
to select what type of reports you want to see, Quarterly or Annually. After
you make your selection, it displays the requested report in the following
format:
http://www.anumati.com/DynamicRepor...3;28/06/2003;29/03/2003;31/12/2002;28/09/2002
It uses specific dates at the end of the URL for the Quarterly Report of
each company.
I originally thought that once I figured out what Year End a company was
using, I could assume Quarterly ending periods. ie. YrEnd = Dec. 31,2004 -->
QtrEnd = March 31, June 30, Sept 30, Dec. 30. But as you can see from the
example above, Quarter ends don't necessarily mean last day of the month for
each 3 month period.
I built a macro that uses these dates to build a string with the correct
URL to download. But my logic breaks down when a company has non-standard
quarter or annual ending dates, ie
A2 = http://www.anumati.com/DynamicReport.aspx?id=TR&report=
A3 = Report requested (IS-Q - Income Statement Quarterly)
A4 = &dates=
A5 = quarter ending dates as determined by finding the correct year ending
date
A1 = A2&A3&A4&A5
A1 is the string that I use in the macro as the URL to download.
Is there an easier way to accomplish the same task without building a text
string to use as the URL? As I mentioned the dates can change depending on
what company you select.
I would appreciate any help.
Thanks