4 Messages
Digest #3496
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?
>
>
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
>
> 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")
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?
>
=RCHGetElementNumbe
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@
>
> 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"
> 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!
For example, the formula =smfGetAdvFNElement
The version that I am using is Stock Market Functions add-in, Version 2.1.2015.03.
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!
>
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
> Date<"
>
> The version that I am using is Stock Market Functions add-in, Version
> 2.1.2015.03.
> Netherlands.
>
> Any help is highly appreciated!
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar