5 New Messages
Digest #2322
| |
Messages
Wed Aug 22, 2012 8:04 am (PDT) . Posted by:
"notkoushik" notkoushik
Thanks a ton Randy. >string< fits very well in my code.
Regards
KK
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It's just doing what you told it -- getting the most recent year of data
> following search string ">EBIT". It's just not a unique enough string for
> what you want. That's why the function allows multiple search terms, so you
> can get to the one you want. Try:
>
> =smfGetADVFNElement("GOOG","A",1,">EBIT",">EBIT")
>
> Another option would be:
>
> =smfGetADVFNElement("GOOG","A",1,">EBIT<")
>
> On Tue, Aug 21, 2012 at 10:37 PM, notkoushik <notkoushik@...> wrote:
>
> > Hi Randy,
> > I think I found a small bug in the smfGetADVFNElement routine. I am trying
> > to retrieve EBIT using
> > =smfGetADVFNElement("GOOG","A",1,">EBIT")
> > but it returns the value corresponding to EBITDA
> > After looking within the routine, it points to this line in the code
> > within RCHExtractData -
> > iPos1 = InStr(iPos1 + 1, sData(3), UCase(pFind1))
> >
> > since InStr returns the first match, it ignores the real 'EBIT'.
> > I am not sure the data format within sData, and so I don't know how string
> > search can be modified to avoid multiple pattern matches. Can InStrRev
> > return value be compared against InStr return value and be used to find the
> > other pattern?
> >
> > Perhaps, there is an already existing solution/workaround, please let me
> > know.
> >
>
Regards
KK
--- In smf_addin@yahoogrou
>
> It's just doing what you told it -- getting the most recent year of data
> following search string ">EBIT". It's just not a unique enough string for
> what you want. That's why the function allows multiple search terms, so you
> can get to the one you want. Try:
>
> =smfGetADVFNElement
>
> Another option would be:
>
> =smfGetADVFNElement
>
> On Tue, Aug 21, 2012 at 10:37 PM, notkoushik <notkoushik@
>
> > Hi Randy,
> > I think I found a small bug in the smfGetADVFNElement routine. I am trying
> > to retrieve EBIT using
> > =smfGetADVFNElement
> > but it returns the value corresponding to EBITDA
> > After looking within the routine, it points to this line in the code
> > within RCHExtractData -
> > iPos1 = InStr(iPos1 + 1, sData(3), UCase(pFind1)
> >
> > since InStr returns the first match, it ignores the real 'EBIT'.
> > I am not sure the data format within sData, and so I don't know how string
> > search can be modified to avoid multiple pattern matches. Can InStrRev
> > return value be compared against InStr return value and be used to find the
> > other pattern?
> >
> > Perhaps, there is an already existing solution/workaround
> > know.
> >
>
Wed Aug 22, 2012 1:12 pm (PDT) . Posted by:
"Ron Spruell" hashky
Randy -
This file does not get all the option expiry dates for CSCO. It does for CAT. It looks like it needs an if statement (or something) to get the proper link. Have you encountered this problem? If so, do you have a solution.
Files > Templates and Examples >
RCHGetTableCell RCHGetTableCell-Template-Yahoo-Options-Quotes.xls
Ron Spruell
This file does not get all the option expiry dates for CSCO. It does for CAT. It looks like it needs an if statement (or something) to get the proper link. Have you encountered this problem? If so, do you have a solution.
Files > Templates and Examples >
RCHGetTableCell RCHGetTableCell-
Ron Spruell
Wed Aug 22, 2012 1:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's not working because Yahoo has invalid option symbols in their CSCO
tables. For example:
CSCO120922C0001000
CSCO120922C00010000
These look like they're meant to be the same ticker symbol (and the web
page cites the same prices), but note that the first ticker symbol is too
short. So when it tries to extract the date, it's in the wrong location.
On Wed, Aug 22, 2012 at 1:12 PM, Ron Spruell <hashky@yahoo.com > wrote:
>
> This file does not get all the option expiry dates for CSCO. It does for
> CAT. It looks like it needs an if statement (or something) to get the
> proper link. Have you encountered this problem? If so, do you have a
> solution.
> Files <http://finance.groups.yahoo.com/group/smf_addin/files/ > > Templates
> and Examples<http://finance.groups.yahoo.com/group/smf_addin/files/Templates%20and%20Examples/ >> RCHGetTableCell[image:
> application/vnd.ms-excel]
> RCHGetTableCell-Template-Yahoo-Options-Quotes.xls<http://f1.grp.yahoofs.com/v1/IB41UMSGPqg26bgM2LWQhlk5K9aptDBB6mUx4iKmlkDrSXN14QxelGCKPHAhaeUcWe9HJnBZGR1W4AWb0whvsX9tlPEL/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-Yahoo-Options-Quotes.xls >
>
tables. For example:
CSCO120922C0001000
CSCO120922C00010000
These look like they're meant to be the same ticker symbol (and the web
page cites the same prices), but note that the first ticker symbol is too
short. So when it tries to extract the date, it's in the wrong location.
On Wed, Aug 22, 2012 at 1:12 PM, Ron Spruell <hashky@yahoo.
>
> This file does not get all the option expiry dates for CSCO. It does for
> CAT. It looks like it needs an if statement (or something) to get the
> proper link. Have you encountered this problem? If so, do you have a
> solution.
> Files <http://finance.
> and Examples<http://finance.
> application/
> RCHGetTableCell-
>
Wed Aug 22, 2012 8:19 pm (PDT) . Posted by:
"hjreed@swbell.net" hjreed@swbell.net
Randy
Since MSN still lags a day on daily close, is there:
-another element that has the close (I didn't see one but better to ask)
-a way to pull the close from Yahoo Finance Summary?
http://finance.yahoo.com/q?s=mmm&ql=1
Thank you for all you have done in making this tool availiable to us!
Since MSN still lags a day on daily close, is there:
-another element that has the close (I didn't see one but better to ask)
-a way to pull the close from Yahoo Finance Summary?
http://finance.
Thank you for all you have done in making this tool availiable to us!
Wed Aug 22, 2012 8:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just use the RCHGetYahooQuotes() function -- it grabs a CSV file from Yahoo
that can return dozens of data items for up to 200 stocks, in a single
Internet access. Makes it VERY speedy to get quotes on a number of stocks.
On Wed, Aug 22, 2012 at 8:19 PM, hjreed@swbell.net <hjreed@swbell.net >wrote:
>
> Since MSN still lags a day on daily close, is there:
> -another element that has the close (I didn't see one but better to ask)
> -a way to pull the close from Yahoo Finance Summary?
> http://finance.yahoo.com/q?s=mmm&ql=1
>
> Thank you for all you have done in making this tool availiable to us!
>
that can return dozens of data items for up to 200 stocks, in a single
Internet access. Makes it VERY speedy to get quotes on a number of stocks.
On Wed, Aug 22, 2012 at 8:19 PM, hjreed@swbell.
>
> Since MSN still lags a day on daily close, is there:
> -another element that has the close (I didn't see one but better to ask)
> -a way to pull the close from Yahoo Finance Summary?
> http://finance.
>
> Thank you for all you have done in making this tool availiable to us!
>
Tidak ada komentar:
Posting Komentar