Rabu, 02 Maret 2016

[smf_addin] Digest Number 3653

3 Messages

Digest #3653
1c
Re: ADVFN from outside the US by "Randy Harmelink" rharmelink

Messages

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

rafaelpin

Hi all,

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?

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

rafaelpin

Other info: =RCHGetElementNumber("GOOG",5336) gives me Error



I have reconfigured internet security settings to allow access across domains (or something along those lines).


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

"Randy Harmelink" rharmelink

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?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar