Messages

1a

Tue Mar 1, 2016 2:41 pm (PST) . Posted by:

=RCHGetElementNumber("NASDAQ:GOOG",5336) (the URL I get when browsing is: http://br.advfn.com/bolsa-de-valores/nasdaq/GOOG/balanco)

But nothing outside the US works, even though the URLs are consistent, i.e.:

I can access http://br.advfn.com/bolsa-de-valores/lse/TLY/balanco ok, but =RCHGetElementNumber("LSE:TLY",5336) gives me Error.

Same thing with brazilian stock, which gives a slightly different URL (i.e. http://br.advfn.com/bolsa-de-valores/bovespa/cemig-CMIG4/balanco) but I get nothing from any combination of RCHGetElementNumber on that stock (BOV:CMIG4, BOVESPA:CMIG4, BOV:cemig-CMIG4 and so on).

It seems like a simple issue but I haven't found a solution around here yet. I have tried using the smf-AdvFN-Prefix.txt file to force different domains, but I can still only retrieve american stock exchanges.

1c

Tue Mar 1, 2016 3:18 pm (PST) . Posted by:

I'm surprised you get anything with NASDAQ:GOOG, since the URL is drastically different than what the add-in uses, because of language differences.

However, I'm not surprised you don't get anything for the other ticker symbols. I don't see any quarterly or annual financial statements data on the site for them, so there's nothing for the add-in to retrieve.

On Tue, Mar 1, 2016 at 3:41 PM, lemieszek@... wrote:

> > I can successfully retrieve data from ADVFN using, for instance: > > =RCHGetElementNumber("NASDAQ:GOOG",5336) > (the URL I get when browsing is: > http://br.advfn.com/bolsa-de-valores/nasdaq/GOOG/balanco) > > But nothing outside the US works, even though the URLs are consistent, > i.e.: > > I can access http://br.advfn.com/bolsa-de-valores/lse/TLY/balanco ok, but > =RCHGetElementNumber("LSE:TLY",5336) gives me Error. > > Same thing with brazilian stock, which gives a slightly different URL > (i.e. http://br.advfn.com/bolsa-de-valores/bovespa/cemig-CMIG4/balanco) > but I get nothing from any combination of RCHGetElementNumber on that stock > (BOV:CMIG4, BOVESPA:CMIG4, BOV:cemig-CMIG4 and so on). > > It seems like a simple issue but I haven't found a solution around here > yet. I have tried using the smf-AdvFN-Prefix.txt file to force different > domains, but I can still only retrieve american stock exchanges. > > Any tips? >