Selasa, 24 Januari 2012

[smf_addin] Digest Number 2087

Messages In This Digest (9 Messages)

Messages

1a.

Re: Can't get the Add-in to install or work

Posted by: "srthwaytes" spencer.thwaytes@gmail.com   srthwaytes

Mon Jan 23, 2012 4:16 am (PST)



Bingo...thanks Randy.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Based on the garbage characters I'm seeing around MSFT, I would suspect
> you're not using proper double-quotes symbols to indicate it is a string
> literal. Since the function expects a string, that would cause a #VALUE!
> error.
>
> On Sat, Jan 21, 2012 at 10:08 AM, srthwaytes <spencer.thwaytes@...>wrote:
>
> > Thanks...that worked. I've extracted files to the folder correctly and
> > managed the Add-In options in Excel to include Stock Market Functions
> > Add-In. All good here.
> >
> > But now I'm testing the via the instructions with the following formula...
> > =RCHGetYahooHistory(â€Å"MSFT†) ...not by pressing enter but by pressing
> > CTRL-SHFT-ENT. Unfortunately, I only get #VALUE! as a result.
> >
> > Any idea what I'm doing incorrectly? I didn't see a tutorial about this
> > issue under Links...
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2a.

elements 547 - 550

Posted by: "Joel" joel.andrews@lpl.com   joelfp2000

Mon Jan 23, 2012 7:11 am (PST)



Randy,

These elements from MSN2 do not seem to work. They are for Technical Grade, Valuation Grade, Ownership Grade, and Fundamental Grade.

Thanks for your help.

Joel

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.

Re: elements 547 - 550

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jan 23, 2012 7:52 am (PST)



They were obsoleted last year when MSN dropped them from their web pages.
Have they added them back?

On Mon, Jan 23, 2012 at 8:11 AM, Joel <joel.andrews@lpl.com> wrote:

>
> These elements from MSN2 do not seem to work. They are for Technical
> Grade, Valuation Grade, Ownership Grade, and Fundamental Grade.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3.

Re: Auto Refresh

Posted by: "Randy H" rharmelink@gmail.com   rharmelink

Mon Jan 23, 2012 3:10 pm (PST)



You would need to write your own VBA routine to do that.

--- In smf_addin@yahoogroups.com, Bob Authur <bobauthur@...> wrote:
>
> New here. Read through many messages about "refresh" and didn't
> find one that addresses an auto refresh. Can I somehow have my
> spreadsheet automatically refresh on some cycle -- like every
> minute? I'm using the RCHGetYahooQuotes function with NOW().
>
> I'd like to use this to monitor trade candidates during the day
> -- as they approach buy and sell prices.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
4a.

how to retrieve Call option strikes for a stock

Posted by: "KailuaKid" Gary.Hartling@gmail.com   garyhartling

Mon Jan 23, 2012 7:49 pm (PST)



How would I retrieve all the Call strikes for WMT for the Feb, 2012 expiration?

Thx,
Gary

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4b.

Re: how to retrieve Call option strikes for a stock

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Mon Jan 23, 2012 7:55 pm (PST)



the short answer is to use:

smfGetOptionStrikes

See:
http://f1.grp.yahoofs.com/v1/sB4eT96ouvjNsbJ6iigySxRtDnIamTXvTjUSEkI_muBbl8S
2HAUKIZGVg9D0HUvdvFwWM0k8MBL03jIpk0eeRLh45Q05rs-4yg/Works-In-Progress/3.1x%2
0-%20smfGetOptionStrikes.html

Make sure to download the version of the add-in from the Works In Progress
folder too to get the latest version for options:
http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of KailuaKid
Sent: Monday, January 23, 2012 10:49 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] how to retrieve Call option strikes for a stock

How would I retrieve all the Call strikes for WMT for the Feb, 2012
expiration?

Thx,
Gary

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4c.

Re: how to retrieve Call option strikes for a stock

Posted by: "Randy H" rharmelink@gmail.com   rharmelink

Mon Jan 23, 2012 8:27 pm (PST)



Note that the "f1.grp..." URL for files is a temporary one generated by
Yahoo. Why they do that is beyond me.

The actual URL would be:

http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/\
3.1x%20-%20smfGetOptionStrikes.html

On Mon, Jan 23, 2012 at 8:56 PM, Mike McQuaid <mikemcq802@...> wrote:

the short answer is to use: smfGetOptionStrikes See:
http://f1.grp.yahoofs.com/v1/sB4eT96ouvjNsbJ6iigySxRtDnIamTXvTjUSEkI_muB\
bl8S2HAUKIZGVg9D0HUvdvFwWM0k8MBL03jIpk0eeRLh45Q05rs-4yg/Works-In-Progres\
s/3.1x%20-%20smfGetOptionStrikes.html
<http://f1.grp.yahoofs.com/v1/sB4eT96ouvjNsbJ6iigySxRtDnIamTXvTjUSEkI_mu\
Bbl8S2HAUKIZGVg9D0HUvdvFwWM0k8MBL03jIpk0eeRLh45Q05rs-4yg/Works-In-Progre\
ss/3.1x%20-%20smfGetOptionStrikes.html> Make sure to download the
version of the add-in from the Works In Progress folder too to get the
latest version for options:
http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/
<../../../../files/Works-In-Progress/>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4d.

Re: how to retrieve Call option strikes for a stock

Posted by: "KailuaKid" Gary.Hartling@gmail.com   garyhartling

Mon Jan 23, 2012 9:51 pm (PST)





Thanks! I didn't know this function existed. I guess the PDF that was put together recently with all the functions is already out of date. --gh

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> Note that the "f1.grp..." URL for files is a temporary one generated by
> Yahoo. Why they do that is beyond me.
>
> The actual URL would be:
>
> http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/\
> 3.1x%20-%20smfGetOptionStrikes.html
>
> On Mon, Jan 23, 2012 at 8:56 PM, Mike McQuaid <mikemcq802@> wrote:
>
> the short answer is to use: smfGetOptionStrikes See:
> http://f1.grp.yahoofs.com/v1/sB4eT96ouvjNsbJ6iigySxRtDnIamTXvTjUSEkI_muB\
> bl8S2HAUKIZGVg9D0HUvdvFwWM0k8MBL03jIpk0eeRLh45Q05rs-4yg/Works-In-Progres\
> s/3.1x%20-%20smfGetOptionStrikes.html
> <http://f1.grp.yahoofs.com/v1/sB4eT96ouvjNsbJ6iigySxRtDnIamTXvTjUSEkI_mu\
> Bbl8S2HAUKIZGVg9D0HUvdvFwWM0k8MBL03jIpk0eeRLh45Q05rs-4yg/Works-In-Progre\
> ss/3.1x%20-%20smfGetOptionStrikes.html> Make sure to download the
> version of the add-in from the Works In Progress folder too to get the
> latest version for options:
> http://finance.groups.yahoo.com/group/smf_addin/files/Works-In-Progress/
> <../../../../files/Works-In-Progress/>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
4e.

Re: how to retrieve Call option strikes for a stock

Posted by: "Randy H" rharmelink@gmail.com   rharmelink

Mon Jan 23, 2012 10:01 pm (PST)



That's because the function ONLY exists in the beta version of the
add-in from that same file folder.

On Mon, Jan 23, 2012 at 10:51 PM, KailuaKid <Gary.Hartling@gmail.com>
wrote:

Thanks! I didn't know this function existed. I guess the PDF that was
put together recently with all the functions is already out of date.
--gh

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
Recent Activity
Visit Your Group
Yahoo! News

Get it all here

Breaking news to

entertainment news

New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 02.48

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)