Messages In This Digest (3 Messages)

1.: Form to select element number and execute RCHGetElementNumber From: Michael Sergi

2a.: Wikinvest 10 year financials From: dustinkw@ymail.com
2b.: Re: Wikinvest 10 year financials From: Randy Harmelink

View All Topics | Create New Topic

Messages

1.: Form to select element number and execute RCHGetElementNumber

Posted by: "Michael Sergi" phradeus@hotmail.com phradeus

Wed Jan 11, 2012 2:12 pm (PST)

[Attachment(s) from Michael Sergi included below]

I wrote this form awhile back, and thought it might be useful for the group. I use it quite a bit.

Copy the two attachments to the same directory somewhere. Start Visual Basic. Under RCH_Stock_Market_Functions.xla do Import File and point to the directory where the attachments are. Select GetStockData. Hit OK.

Then just add a module under the RCH_Stock_Market_Functions. Place this code in it;

Sub GetStockDatafromInternet()

Load GetStockData
GetStockData.show vbModeless

End Sub

You can then run GetStockDatafromInternet as a macro.

Attachment(s) from Michael Sergi

2 of 2 File(s)

GetStockData.frx

GetStockData.frm

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

2a.: Wikinvest 10 year financials

Posted by: "dustinkw@ymail.com" dustinkw@ymail.com dustinkw@ymail.com

Wed Jan 11, 2012 9:18 pm (PST)

I would like to pull financial data from the Wikinvest site, using the the RCHGetTableCell function. However, on this website the data for the quarterly and annual reports, as well as data more than 5 years/quarters old, are displayed by clicking a tab within the table. The problem is this doesn't change the actual website address. This means I am unsure how to tell the function how to pull data from the annual reports since the quarterly reports are shown first when the website is first loaded.

I noticed that the data on the Google Finance page is displayed similarly-you navigate between quarterly and annual reports from the same web address- and yet data can be pulled from Google's tables with the RCHGetElementNumber function.

Any help would be appreciated.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.: Re: Wikinvest 10 year financials

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Jan 11, 2012 9:38 pm (PST)

Sorry, but it appears the pages are being generated dynamically, so there
is nothing in the source code of the web page for the add-in to extract.

On Wed, Jan 11, 2012 at 10:18 PM, dustinkw@ymail.com <dustinkw@ymail.com>wrote:

> I would like to pull financial data from the Wikinvest site, using the the
> RCHGetTableCell function. However, on this website the data for the
> quarterly and annual reports, as well as data more than 5 years/quarters
> old, are displayed by clicking a tab within the table. The problem is
> this doesn't change the actual website address. This means I am unsure
> how to tell the function how to pull data from the annual reports since the
> quarterly reports are shown first when the website is first loaded.
>
> I noticed that the data on the Google Finance page is displayed
> similarly-you navigate between quarterly and annual reports from the same
> web address- and yet data can be pulled from Google's tables with the
> RCHGetElementNumber function.
>
> Any help would be appreciated.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)