Rabu, 17 Februari 2016

[smf_addin] Digest Number 3641[1 Attachment]

15 Messages

Digest #3641
3b
Re: Data from Fidelity.com by "Randy Harmelink" rharmelink
4a
Thank You! by peterway
4b
Re: Thank You! by "Gaston Bullrich" gbullr
4c
Re: Thank You! by "Randy Harmelink" rharmelink

Messages

Wed Feb 17, 2016 6:59 am (PST) . Posted by:

perseuslim11

Hi everyone again, sorry for asking, but I've really tried every other means I could get my hands on, but still couldnt figure this out, it's regarding the smfgettagcontent function

It worked well for almost all stocks I've used it on, except the one I've just encountered today, which is CCB (2925.KL) http://klse.i3investor.com/servlets/stk/2925.jsp http://klse.i3investor.com/servlets/stk/2925.jsp

my function is

=smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&TickerNo&".jsp","td",4,"Last Price")


"&TickerNo&" refers to another cell which has the 4 digit stockcode


above function has worked well for me for 7087.KL,5001.KL,5053.KL,9261.KL,7052.KL
and many more, all worked like a charm, but just this 2925.KL (CCB) returns "Error" without quotes


I've also tried looking into the source code of 2925.KL page in the link included above, but found no abnormalities, it is also 4 tags to be skipped like the others


Any input will be greatly appreciated,
Thank!




Wed Feb 17, 2016 7:42 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It's working fine here.

I suspect what happened is that you got something on the web page with the
phrase "last price" on it -- maybe an ad or something. "Last price" is not
a good search term, because it can occur in a meta tag, a description,
whatever.

That's why I try to make the keywords more unique by using the ">" in front
of them, if the web page is coded that way.

On Wed, Feb 17, 2016 at 7:59 AM, perseuslim11@... wrote:

>
> Hi everyone again, sorry for asking, but I've really tried every other
> means I could get my hands on, but still couldnt figure this out, it's
> regarding the smfgettagcontent function
>
> It worked well for almost all stocks I've used it on, except the one I've
> just encountered today, which is CCB (2925.KL)
> http://klse.i3investor.com/servlets/stk/2925.jsp
>
> my function is
> =smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&TickerNo&".jsp","td",4,"Last
> Price")
>
> "&TickerNo&" refers to another cell which has the 4 digit stockcode
>
> above function has worked well for me for
> 7087.KL,5001.KL,5053.KL,9261.KL,7052.KL
> and many more, all worked like a charm, but just this 2925.KL (CCB)
> returns "Error" without quotes
>
> I've also tried looking into the source code of 2925.KL page in the link
> included above, but found no abnormalities, it is also 4 tags to be skipped
> like the others
>
> Any input will be greatly appreciated,
>
>

Wed Feb 17, 2016 8:08 am (PST) . Posted by:

perseuslim11

err, do you mean put ">Last Price" instead of "Last Price"? if so, it still isnt working ..

Wed Feb 17, 2016 8:10 am (PST) . Posted by:

perseuslim11

if Last Price isn't a good search term, how to determine which is a good term to search for?

I've tried also "Today's Change" as search term, but also not working hmm..

Wed Feb 17, 2016 9:46 am (PST) . Posted by:

"Randy Harmelink" rharmelink

This is working fine for me:

=smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",4,">Last
Price")

BTW, this will have the function convert it into a number:

=smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",4,">Last
Price",,,,1)

This also worked for me:

=smfGetTagContent("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",3,">Today's
Change",,,,1)

You could do something like:

=RCHGetWebData("http://klse.i3investor.com/servlets/stk/"&C24&".jsp","Last
Price")

...to see what kind of data is being returned.

A good search term is something that is pretty unique and would't be used
in a description of some kind. For example, if a news item were to show up
saying, "The last price of the day reflected...", then your search would be
ruined. Or, if the meta tag on the page said the page contained "...data
about a particular stock, including the last price, ...", ditto.

On Wed, Feb 17, 2016 at 9:10 AM, perseuslim11@... wrote:

>
> if Last Price isn't a good search term, how to determine which is a good
> term to search for?
>
> I've tried also "Today's Change" as search term, but also not working
> hmm..
>
>

Wed Feb 17, 2016 3:47 pm (PST) . Posted by:

perseuslim11

This is working fine for me:

=smfGetTagContent("http://klse.i3investor.com/servlets/stk/ http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",4,">Last Price")


BTW, this will have the function convert it into a number:

=smfGetTagContent("http://klse.i3investor.com/servlets/stk/ http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",4,">Last Price",,,,1)


This also worked for me:

=smfGetTagContent("http://klse.i3investor.com/servlets/stk/ http://klse.i3investor.com/servlets/stk/"&C24&".jsp","td",3,">Today's Change",,,,1)




the 3 functions above doesnt work, still returning a "Error" word only , hmm..
I'm attaching my input page here, maybe that will be easier to diagnose the problem?
btw, all 3 functions above work for many other stocks I've tested with, only this CCB (2925)
is weird
Attachment(s) from
1 of 1 File(s)

Wed Feb 17, 2016 7:00 am (PST) . Posted by:

"Randy Harmelink" rharmelink

http://ogres-crypt.com/SMF/

...is where I'm currently putting new files. But the Yahoo group still has
a number of them that haven't been moved yet. And the "Uploads by members"
folder will always stay on the Yahoo group.

There should be a "Read me" file in each Yahoo group files folder where all
the items have been relocated to the SMF web site.
<http://ogres-crypt.com/SMF/>

On Wed, Feb 17, 2016 at 1:18 AM, mail_to_subu@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> where are the most recent templates and sample files which users can use /
> test / share knowledge on ?
>
> here in this yahoo group's file's area
> https://groups.yahoo.com/neo/groups/smf_addin/files
>
> or at http://ogres-crypt.com/SMF/
>
> I wish to concentrate on what's known to be working before trying my hand
> at older files
>

Wed Feb 17, 2016 11:22 am (PST) . Posted by:

jbkbob1

Hi Randy, I have the latest 2015-09-26.... but =RCHGetElementNumber("Version&quot;) shows Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF Add-In; ; Local; 1). Is this what you get? I have win10 and excel 2010

Wed Feb 17, 2016 3:32 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

If you have installed the 2015-09-26 ZIP file, I would expect that date to
be returned by the "Version" function invocation.

On Wed, Feb 17, 2016 at 12:22 PM, jbkbob@... wrote:

>
> Hi Randy, I have the latest 2015-09-26.... but
> =RCHGetElementNumber("Version&quot;) shows
> Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF Add-In; ;
> Local; 1). Is this what you get? I have win10 and excel 2010
>
>

Wed Feb 17, 2016 11:15 am (PST) . Posted by:

zellabettic

Hi, I seem to still get an error when using:

=smfGetTagContent("http://eresearch.fidelity.com/eresearch/evaluate/snapshot.jhtml?symbols="&A1&"","a",-1,"&Sector=")



To obtain GICS Sector data from Fidelity. Can anyone suggest what I may be doing incorrectly?


Thank you.

Wed Feb 17, 2016 3:27 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It looks like they're doing something to prevent the add-in from retrieving
any source code for the web page.

On Wed, Feb 17, 2016 at 12:15 PM, zellabettic@... wrote:

>
> Hi, I seem to still get an error when using:
>
> =smfGetTagContent("
> http://eresearch.fidelity.com/eresearch/evaluate/snapshot.jhtml?symbols=
> "&A1&"","a",-1,"&Sector=")
>
> To obtain GICS Sector data from Fidelity. Can anyone suggest what I may
> be doing incorrectly?
>
>
>

Wed Feb 17, 2016 3:38 pm (PST) . Posted by:

zellabettic

Ok - thanks. Are you aware of any other free source to download GICs data if the Fidelity site is blocking the addin? Thank you,

Clete

Wed Feb 17, 2016 11:28 am (PST) . Posted by:

peterway

I just struggled for days to get reliable quotes in a spreadsheet. I'm a bit of a Luddite when using Microsoft. I keep wanting to upgrade, but I read reviews that usually tell me that Excel 2003 is just fine! Excel 2016 for MAC has a lot of problems and VB appears to be dumbed down.


So I finally figured out how to simply get my prices and your SMF add-in is priceless.


Thank you. Peter

Wed Feb 17, 2016 1:23 pm (PST) . Posted by:

"Gaston Bullrich" gbullr

Randy.

Is there a good industry/sector/subsector classication that can be
downloaded?

Was not able to find anything but 878 in the elements list.

Thank you.

On Wed, Feb 17, 2016 at 2:28 PM, p.way@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> I just struggled for days to get reliable quotes in a spreadsheet. I'm a
> bit of a Luddite when using Microsoft. I keep wanting to upgrade, but I
> read reviews that usually tell me that Excel 2003 is just fine! Excel 2016
> for MAC has a lot of problems and VB appears to be dumbed down.
>
>
> So I finally figured out how to simply get my prices and your SMF add-in
> is priceless.
>
>
> Thank you. Peter
>
>
>

--
Gaston Bullrich
20 East 67th Street Apt 2F
New York, NY 10065
Cel. 917 517 9907

Wed Feb 17, 2016 3:19 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It would really depend on whose definitions you wanted. What I've suggested
in the past is to go use the Zacks screener and just export the whole list,
including their industry and sectors for each company.

Otherwise, there are elements 13864 thru 13868 from Yahoo. But you'd need
to grab those company by company.

On Wed, Feb 17, 2016 at 2:23 PM, Gaston Bullrich gaston.bullrich@... wrote:

>
> Is there a good industry/sector/subsector classication that can be
> downloaded?
>
> Was not able to find anything but 878 in the elements list.
>
> Thank you.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 15.47

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)