Rabu, 26 Agustus 2015

[smf_addin] Digest Number 3496

4 Messages

Digest #3496
1a
Re: smfGetOptionQuotes question by "Randy Harmelink" rharmelink
2a
Re: ADVFN Stockechange selection by "Randy Harmelink" rharmelink
2c
Re: ADVFN Stockechange selection by "Randy Harmelink" rharmelink

Messages

Tue Aug 25, 2015 3:46 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You just need to format the expiration date properly in your string
concatenations:

=smfGetOptionQuotes(A6&" "&TEXT(C1,"mm/dd yyyy")&" "&C6&" "&"Call","b",0,C3)

On Mon, Aug 24, 2015 at 11:44 PM, mknu@juno.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I'm trying to get the following smfGetOptionQuotes function to work:
>
> =smfGetOptionQuotes(A6&" "&C1&" "&C6&" "&"Call","b",0,C3)
>
> Where cell a6 is the symbol
>
> cell C1 is the expiration date
>
> cell C3 is source I'm trying to use G
>
> cell C6 is the strike
>
> This might not even be possible to use direct cell references like this,
> but if it is could you tell me how to format this to work?
>
>

Tue Aug 25, 2015 4:00 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

What version of the add-in are you using:

=RCHGetElementNumber("Version&quot;)

I made a change on 2015-03-21 that was supposed to allow the usage of
American stock exchange prefixes...

Here, I can use either IBM or NYSE:IBM and it works fine. But I can't
really test for being in a different region.

On Tue, Aug 25, 2015 at 12:09 AM, antonvanas1989@...wrote:

>
> I am having troubles with the correct stockmarket symbol for ADVFN data.
>
> If i search "IBM" in my sheet ADVFN will be empty as on there website it
> returns to "lse:ibm". Before i could enter "NYSE:IBM"; in my sheet and then
> it would receive data from IBM but it seems not to work anymore, i tried
> other symbols as: &, \, /, %3A
>
> But nothing works.
>
> How can i point my sheet to the correct data from ADVFN?
>

Tue Aug 25, 2015 1:01 pm (PDT) . Posted by:

salarkhor

I might have a similar issue. For some reason my sheets (based on ADVFN data) used to work perfectly, but now it only shows "error" in all cells.

For example, the formula =smfGetAdvFNElement("MMM";"A";1;">Year End Date<") returns "Error".



The version that I am using is Stock Market Functions add-in, Version 2.1.2015.03.05 (C:\SMF Add-In; uk; Local; 31). BTW, I live in the Netherlands.


Any help is highly appreciated!








Tue Aug 25, 2015 4:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not sure how AdvFN is handling non-US regions. If I go to:

http://uk.advfn.com/stock-market/NYSE/MMM/financials

...and click on the quarterly reports, it sends me to:

http://uk.advfn.com/p.php?pid=financials&btn=quarterly_reports&mode=company_data&symbol=NYSE%3AMMM

...but the US site sends me to:

http://www.advfn.com/stock-market/NYSE/MMM/financials?btn=quarterly_reports&mode=company_data

...so it looks like the UK site is still using their old URL structure. At
least for the quarterly and annual reports.

However, this web page does exist:

http://uk.advfn.com/stock-market/NYSE/MMM/financials?btn=quarterly_reports&mode=company_data

...so if you upgrade to a beta version of the add-in from 2.1.2010.03.21
forward (when I made an update to allow a ticker symbol like NYSE:MMM),
that *may* fix your problem. But I'm just hoping.

The big problem is that I have no way to test any of their non-US
processing.

On Tue, Aug 25, 2015 at 12:24 PM, salarkhor@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I might have a similar issue. For some reason my sheets (based on ADVFN
> data) used to work perfectly, but now it only shows "error" in all cells.
>
> For example, the formula =smfGetAdvFNElement("MMM";"A";1;">Year End
> Date<") returns "Error".
>
> The version that I am using is Stock Market Functions add-in, Version
> 2.1.2015.03.05 (C:\SMF Add-In; uk; Local; 31). BTW, I live in the
> Netherlands.
>
> Any help is highly appreciated!
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar