3 Messages
Digest #3653
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?
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.
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).
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?
>
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.
> 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:
Posting Komentar