Jumat, 16 November 2012

[smf_addin] Digest Number 2402

15 New Messages

Digest #2402
1.1
Re: element numbers by "Kermit W. Prather" kermitpra
1.2
Re: element numbers by "Randy Harmelink" rharmelink
1.3
Re: element numbers by "Kermit W. Prather" kermitpra
2
Re: element numbers-Documentation by "Ron Spruell" hashky
3a
problem logging in by "Steven Charest" cardiaccharest
3b
Re: problem logging in by "Randy Harmelink" rharmelink
4a
help getting started by "bsmth12" bsmth12
4b
Re: help getting started by "Randy Harmelink" rharmelink
4c
Re: help getting started by "Michael McIntyre" michaelmcintyre2000
5a
Re: FINRA Website by "Steven" stevenletzer
5b
Re: FINRA Website by "Randy Harmelink" rharmelink
5c
Re: FINRA Website by "Steven" stevenletzer
5d
Re: FINRA Website by "Steven" stevenletzer
5e
Re: FINRA Website by "Randy Harmelink" rharmelink
5f
Re: FINRA Website by "Steven" stevenletzer

Messages

Fri Nov 16, 2012 6:54 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

For what it is worth, I just tried the 3 element numbers =RCHGetElementNumber(966) and I got a return of "Error" on each one of them.

All other functions work for me.

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, November 15, 2012 5:04 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] element numbers


It's an operating system setting...

If you're not located outside the U.S., it's probably not an issue.
On Thu, Nov 15, 2012 at 2:34 PM, Dave Charlaff <davecharlaff@hotmail.com> wrote:

US Regional settings? I am unfamiliar with this.

Is that a setting in IE? Or Yahoo specific?

Fri Nov 16, 2012 6:59 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Well, you need to give it a ticker symbol first, before the element
number...

On Fri, Nov 16, 2012 at 7:54 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> For what it is worth, I just tried the 3 element numbers =
> RCHGetElementNumber(966) and I got a return of "Error" on each one of
> them.****
>
> ** **
>
> All other functions work for me.
>

Fri Nov 16, 2012 7:01 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Ignore my previous post. The 3 elements worked just fine once I put ticker symbol in the formula.

What can I say other than I need to read the documentation before butting into the conversation.

=RCHGetElementNumber("IBM", 966) returned 33670000


Sorry,
Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, November 15, 2012 5:04 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] element numbers


It's an operating system setting...

If you're not located outside the U.S., it's probably not an issue.
On Thu, Nov 15, 2012 at 2:34 PM, Dave Charlaff <davecharlaff@hotmail.com> wrote:

US Regional settings? I am unfamiliar with this.

Is that a setting in IE? Or Yahoo specific?

Fri Nov 16, 2012 9:12 am (PST) . Posted by:

"Ron Spruell" hashky

Reading the documentation is critical.  I printed it out and put it in a 3 ring binder.  It sure does save a lot of time - not to mention Randy's time that he gives so freely . . .  for FREE.

http://tinyurl.com/d345zhh

>________________________________
> From: Kermit W. Prather <kermitp@tampabay.rr.com>
>To: smf_addin@yahoogroups.com
>Sent: Friday, November 16, 2012 9:01 AM
>Subject: RE: [smf_addin] element numbers
>
>

>Ignore my previous post. The 3 elements worked just fine once I put ticker symbol in the formula.

>What can I say other than I need to read the documentation before butting into the conversation.

>=RCHGetElementNumber("IBM", 966) returned 33670000


>Sorry,
>Kermit

>From:smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
>Sent: Thursday, November 15, 2012 5:04 PM
>To: smf_addin@yahoogroups.com
>Subject: Re: [smf_addin] element numbers

>
>
>It's an
operating system setting...
>
>If you're not located outside the U.S., it's probably not an issue.
>On Thu, Nov 15, 2012 at 2:34 PM, Dave Charlaff <davecharlaff@hotmail.com> wrote:

>US Regional settings? I am unfamiliar with this.

>Is that a setting  in IE? Or Yahoo specific?
>
>
>
>
>
>
>
>

Fri Nov 16, 2012 12:18 pm (PST) . Posted by:

"Steven Charest" cardiaccharest

Randy, I'm having a bit of trouble accessing the group.

Yahoo reports I'm signed in but I can't access the members only
section. Is this yahoo or the group?

--
Best,

Steve

__________________________________

Fri Nov 16, 2012 12:56 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I sometimes get that, not being able to access area of a group even though
I appear to be signed in -- I just sign out and sign in. It has always
fixed it.

On Fri, Nov 16, 2012 at 1:18 PM, Steven Charest <cardiaccharest@gmail.com>wrote:

> Randy, I'm having a bit of trouble accessing the group.
>
> Yahoo reports I'm signed in but I can't access the members only
> section. Is this yahoo or the group?
>

Fri Nov 16, 2012 1:01 pm (PST) . Posted by:

"bsmth12" bsmth12

Does anyone have a template for this, or something close:
____

I want to open a spreadsheet, enter stock symbols (up to 200?)

Hit a "download data" button, and it grabs stock and Options data from either yahoo or google feed, does simple calculations and displays updated data in cells.

I'm looking to input Call and Put prices into the spreadsheet, within a certain range of the current share price, at all the available expiration months. I'll use that data as inputs into formulas contained in other cells, and the results of the calculation gets displayed in another cell.

___

I tried to figure it out but I couldn't get far, I'm looking through the documentation and it seems to be aimed at people who already know what they're doing and just need the specifics. I'm at a basic level, what do I read up on to be able to make a sheet like that, is this "excel programming" ?

Thanks,

Fri Nov 16, 2012 1:11 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Take a look at the documentation for RCHGetYahooQuotes() and
smfGetOptionQuotes(). They'll have most of what you're asking about.

These messages in the archives may be of help:

http://finance.groups.yahoo.com/group/smf_addin/message/124
http://finance.groups.yahoo.com/group/smf_addin/message/17234

The first is a step-by-step example of using RCHGetYahooQuotes(). The
second contains a number of examples of using the various option functions
that are available, in addition to smfGetOptionQuotes().

Note that the LINKS area of the group has pointers to some FAQs and tips...

However, getting a lot of options data on 200 stocks could make for a slow
spreadsheet.

On Fri, Nov 16, 2012 at 1:59 PM, bsmth12 <bsmth12@yahoo.com> wrote:

> Does anyone have a template for this, or something close:
> ____
>
> I want to open a spreadsheet, enter stock symbols (up to 200?)
>
> Hit a "download data" button, and it grabs stock and Options data from
> either yahoo or google feed, does simple calculations and displays updated
> data in cells.
>
> I'm looking to input Call and Put prices into the spreadsheet, within a
> certain range of the current share price, at all the available expiration
> months. I'll use that data as inputs into formulas contained in other
> cells, and the results of the calculation gets displayed in another cell.
>
> ___
>
> I tried to figure it out but I couldn't get far, I'm looking through the
> documentation and it seems to be aimed at people who already know what
> they're doing and just need the specifics. I'm at a basic level, what do I
> read up on to be able to make a sheet like that, is this "excel
> programming" ?
>

Fri Nov 16, 2012 4:19 pm (PST) . Posted by:

"Michael McIntyre" michaelmcintyre2000

In addition, take a look in the Files section for:
 
Message-2281-Yahoo-Options-Calls-and-Puts.xls
Message-2281-Yahoo-Options.xls
 
Also, you'll need to know the strike increments in each case (or use the ITM/OTM parameters.)

 
But as Randy mentioned, pulling 200 quotes with multiple option data will require quite a bit of patience.

________________________________
From: bsmth12 <bsmth12@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Friday, November 16, 2012 12:59 PM
Subject: [smf_addin] help getting started

 
Does anyone have a template for this, or something close:
____

I want to open a spreadsheet, enter stock symbols (up to 200?)

Hit a "download data" button, and it grabs stock and Options data from either yahoo or google feed, does simple calculations and displays updated data in cells.

I'm looking to input Call and Put prices into the spreadsheet, within a certain range of the current share price, at all the available expiration months. I'll use that data as inputs into formulas contained in other cells, and the results of the calculation gets displayed in another cell.

___

I tried to figure it out but I couldn't get far, I'm looking through the documentation and it seems to be aimed at people who already know what they're doing and just need the specifics. I'm at a basic level, what do I read up on to be able to make a sheet like that, is this "excel programming" ?

Thanks,

Fri Nov 16, 2012 1:10 pm (PST) . Posted by:

"Steven" stevenletzer

Thank you.
I am trying to capture this information at the FINRA web site.
Bond Detail
GS3928918 / CUSIP: 38141EJ59

http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MzgxNDFFSjU5

I am tyring to capture the symbol GS3928918, and the CUSIP 38141EJ59.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You need to do additional search strings to get to the correct date:
>
> =RCHGetTableCell("
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MTY3NTkzSkEx",1,">Last
> Sale","Date:")
>
> On Mon, Nov 12, 2012 at 2:30 PM, Steven <stevenletzer@...> wrote:
>
> > The FINRA website maintains price, description and transation data:
> > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/Default.aspx
> > I am trying to extract Composite Trade Information. For example: CUSIP
> > 167593JA1, the Bond Detail page is at this adddress:
> > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MTY3NTkzSkEx.
> > The last 12 characters (MTY3NTkzSkEx)are an internal coding system,
> > assigned by FINRA. Since I have not found a way to determine this code, I
> > have created an Excel table with the CUSIP and the FINRA code copied in
> > (any suggestions for finding the FINRA code would be appreciated].
> >
> > The Bond Detail page display both fixed description information and
> > variable price/yield information. At the bottom of the page in the section
> > Composite Trade Information, I want to extract in the last 3 lines on the
> > left of the table: Date, Price and Yield.
> >
> > I created an Excel table with these fields:
> > CUSIP: 167593JA1
> >
> > Short Name: CHICAGO IL B 3.75 010128
> >
> > Bond Detail Page address:
> > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MTY3NTkzSkEx
> >
> > FINRA ID: MTY3NTkzSkEx [extracted from the page address]
> >
> > Price: =RCHGetTableCell("
> > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID="&$H2,1,"Price:")[the
> > Last Sale Price returned is correct].
> >
> > Date: RCHGetTableCell("
> > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID="&$H2,1,"Date:")*1
> > --- This returns the wrong date. The date should be they Last Sale Date
> >
> > Any ideas?
> >
>

Fri Nov 16, 2012 1:15 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

How about:

=smfStrExtr(smfGetTagContent("
http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MzgxNDFFSjU5","h1",-1,"BondDetail1_BondTickerLabel"),">","
")

=smfStrExtr(smfGetTagContent("
http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MzgxNDFFSjU5","h1",-1,"BondDetail1_BondTickerLabel"),"CUSIP:
","<")

On Fri, Nov 16, 2012 at 2:10 PM, Steven <stevenletzer@yahoo.com> wrote:

> I am trying to capture this information at the FINRA web site.
> Bond Detail
> GS3928918 / CUSIP: 38141EJ59
>
>
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MzgxNDFFSjU5
>
> I am tyring to capture the symbol GS3928918, and the CUSIP 38141EJ59.
>

Fri Nov 16, 2012 1:23 pm (PST) . Posted by:

"Steven" stevenletzer

Thank you

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> How about:
>
> =smfStrExtr(smfGetTagContent("
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MzgxNDFFSjU5","h1",-1,"BondDetail1_BondTickerLabel"),">","
> ")
>
> =smfStrExtr(smfGetTagContent("
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MzgxNDFFSjU5","h1",-1,"BondDetail1_BondTickerLabel"),"CUSIP:
> ","<")
>
> On Fri, Nov 16, 2012 at 2:10 PM, Steven <stevenletzer@...> wrote:
>
> > I am trying to capture this information at the FINRA web site.
> > Bond Detail
> > GS3928918 / CUSIP: 38141EJ59
> >
> >
> > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MzgxNDFFSjU5
> >
> > I am tyring to capture the symbol GS3928918, and the CUSIP 38141EJ59.
> >
>

Fri Nov 16, 2012 1:26 pm (PST) . Posted by:

"Steven" stevenletzer

Any idea of how to bring the price chart in?

http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MjA1MzYzQU40

--- In smf_addin@yahoogroups.com, "Steven" <stevenletzer@...> wrote:
>
> Thank you
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > How about:
> >
> > =smfStrExtr(smfGetTagContent("
> > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MzgxNDFFSjU5","h1",-1,"BondDetail1_BondTickerLabel"),">","
> > ")
> >
> > =smfStrExtr(smfGetTagContent("
> > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MzgxNDFFSjU5","h1",-1,"BondDetail1_BondTickerLabel"),"CUSIP:
> > ","<")
> >
> > On Fri, Nov 16, 2012 at 2:10 PM, Steven <stevenletzer@> wrote:
> >
> > > I am trying to capture this information at the FINRA web site.
> > > Bond Detail
> > > GS3928918 / CUSIP: 38141EJ59
> > >
> > >
> > > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MzgxNDFFSjU5
> > >
> > > I am tyring to capture the symbol GS3928918, and the CUSIP 38141EJ59.
> > >
> >
>

Fri Nov 16, 2012 1:56 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

How about:

=RCHCreateComment("http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/
"&smfStrExtr(smfGetTagContent("
http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MjA1MzYzQU40
","div",-1,"BondDetailChart1_imgBondDetailChart"),"src=""",""""),99)

On Fri, Nov 16, 2012 at 2:26 PM, Steven <stevenletzer@yahoo.com> wrote:

> Any idea of how to bring the price chart in?
>
>
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MjA1MzYzQU40
>

Fri Nov 16, 2012 2:03 pm (PST) . Posted by:

"Steven" stevenletzer

That is amazing!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> How about:
>
> =RCHCreateComment("http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/
> "&smfStrExtr(smfGetTagContent("
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MjA1MzYzQU40
> ","div",-1,"BondDetailChart1_imgBondDetailChart"),"src=""",""""),99)
>
> On Fri, Nov 16, 2012 at 2:26 PM, Steven <stevenletzer@...> wrote:
>
> > Any idea of how to bring the price chart in?
> >
> >
> > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MjA1MzYzQU40
> >
>

Tidak ada komentar:

Posting Komentar