[smf_addin] Digest Number 3633

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #3633

1a

Can't get smfgetoptionquotes data beyond 4/1/16 by pete_cook2001

1b

Re: Can't get smfgetoptionquotes data beyond 4/1/16 by "Randy Harmelink" rharmelink

2a

Brazilian Data by rdbarreto77

2b

Re: Brazilian Data by "Randy Harmelink" rharmelink

2c

RES: [smf_addin] Brazilian Data by "Rodrigo Barreto" rdbarreto77

Messages

1a

Can't get smfgetoptionquotes data beyond 4/1/16

Thu Feb 11, 2016 9:32 am (PST) . Posted by:

pete_cook2001

Weird - I'm using


=smfGetOptionQuotes(N8:N32,"lbaiv",,"OX2";),


where the N column contains the specially formatted ticker symbol. It was working fine when I used it about a month or so ago. Now I get an error if the expiration date is later than 4/1/16. I've tried using both OX and OX2 as the data sources. Any ideas?

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Can't get smfgetoptionquotes data beyond 4/1/16

Thu Feb 11, 2016 12:00 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I just tried this and it works fine for me:

=smfGetOptionQuotes("MMM 7/15 2016 $150 Call","b",,"OX2")

On Thu, Feb 11, 2016 at 10:31 AM, peterscottcook@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Weird - I'm using
>
> =smfGetOptionQuotes(N8:N32,"lbaiv",,"OX2";),
>
> where the N column contains the specially formatted ticker symbol. It was
> working fine when I used it about a month or so ago. Now I get an error if
> the expiration date is later than 4/1/16. I've tried using both OX and OX2
> as the data sources. Any ideas?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2a

Brazilian Data

Thu Feb 11, 2016 5:47 pm (PST) . Posted by:

rdbarreto77

Hi - how can I get quotes from the Brazilian market? (BOVESPA - Sao Paulo)?


Thanks, Rod

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2b

Re: Brazilian Data

Thu Feb 11, 2016 5:52 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Not sure, but wouldn't it just be a matter of using the right ticker
symbols? For example:

=RCHGetYahooQuotes("SUZB5.SA","l1")

On Thu, Feb 11, 2016 at 6:44 PM, rodrigodbarreto@live.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi - how can I get quotes from the Brazilian market? (BOVESPA - Sao Paulo)?
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2c

RES: [smf_addin] Brazilian Data

Thu Feb 11, 2016 5:53 pm (PST) . Posted by:

"Rodrigo Barreto" rdbarreto77

That's right, it worked. I forgot to use the ".SA" at the end of the code.

Thanks sir!

Att, Rodrigo Barreto

De: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Enviada em: Thursday, February 11, 2016 11:52 PM
Para: smf_addin@yahoogroups.com
Assunto: Re: [smf_addin] Brazilian Data

Not sure, but wouldn't it just be a matter of using the right ticker symbols? For example:

=RCHGetYahooQuotes("SUZB5.SA <http://SUZB5.SA> ","l1")

On Thu, Feb 11, 2016 at 6:44 PM, rodrigodbarreto@live.com <mailto:rodrigodbarreto@live.com> [smf_addin] <smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> > wrote:

Hi - how can I get quotes from the Brazilian market? (BOVESPA - Sao Paulo)?

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 26

• Privacy • Unsubscribe • Terms of Use