Sabtu, 26 Desember 2015

[smf_addin] Digest Number 3592[1 Attachment]

11 Messages

Digest #3592
2a
2b
Re: smfstrExtr Options by "Randy Harmelink" rharmelink

Messages

Fri Dec 25, 2015 2:34 am (PST) . Posted by:

"Randy Harmelink" rharmelink

This brings me to a login page...

If you can't create a bookmark that goes directly to the web page, the
add-in won't be able to access the data.

On Thu, Dec 24, 2015 at 9:38 PM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> http://www.unclestock.com/?email=perseuslim@gmail.com&code=-1401172332
>
> actually there's no specific url, because in the url, it just contain my
> email behind the main url..
> hmm..?
>

Fri Dec 25, 2015 2:39 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Nope. Not unless it would change the URL.

You could import only those table cells you want, using the
RCHGetTableCell() function. For example:

=RCHGetTableCell("
http://www.klse.my/stock/result/financial/last10fy/3107.jsp",1,"Last 10 FY
Result",">Revenue")

On Fri, Dec 25, 2015 at 12:55 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> and can i import the table without the Horiz% option? (untick horizontal)
>
> *KLSE - FIMACOR(3107): FIMA CORPORATION BHD
> <http://www.klse.my/stock/result/financial/last10fy/3107.jsp#stockDetailDiv>*
>

Fri Dec 25, 2015 2:40 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I see no table on that web page. But it does indicate an error:

"Your search text ("=STOCKNO") did not match any stock. Please enter a
different search text and try again."

On Fri, Dec 25, 2015 at 1:11 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> and i tried this formula
> =RCHGetHTMLTable("http://klse.i3investor.com/servlets/stk/fin/=stockno.jsp","Annual
> Result:",-1,"",1)
> and the smfgetcvs function
>
> but both returns nothing , why?
>
>

Fri Dec 25, 2015 4:10 am (PST) . Posted by:

perseuslim11

ohh, the =stockno is set by myself, as I refer that part of link to a "name" I've created for a cell reference..

so actually the =stockno can be replace with lets say 5053








as for creating a bookmark to the webpage, which website are you referring to?

Fri Dec 25, 2015 4:14 am (PST) . Posted by:

perseuslim11



for the klseinvestor website, the url i would like to access is :
OSK: Financials | I3investor http://klse.i3investor.com/servlets/stk/fin/5053.jsp

http://klse.i3investor.com/servlets/stk/fin/5053.jsp

OSK: Financials | I3investor http://klse.i3investor.com/servlets/stk/fin/5053.jsp A free and independent portal for stock investors. The portal provides aggregated investment Blogs and News, Stock Database & Quotes, Price Targets, an...



View on klse.i3investor.com http://klse.i3investor.com/servlets/stk/fin/5053.jsp
Preview by Yahoo







for unclestockscreener website, there's no specific url, just
http://www.unclestock.com/?email=perseuslim@...&code=-1401172332 http://www.unclestock.com/?email=perseuslim@...&code=-1401172332



but perhaps you could register and try it out? Its quite a good website, you could just register, simple really, just need a username and password, no other info required for registration, that way I think you could try it out?





Fri Dec 25, 2015 5:12 am (PST) . Posted by:

perseuslim11

target url:
http://financials.morningstar.com/income-statement/is.html?t=7087®ion=mys&culture=en-US http://financials.morningstar.com/income-statement/is.html?t=7087®ion=mys&culture=en-US



I tried this formula below: =smfgetcvsfile("http://financials.morningstar.com/income-statement/is.html?t="&tickerno&&quot;®ion=mys&culture=en-US"


but in the end i get the result inside attached photo..


confusing... and the documentation/tipsntricks page is not very clear, hence I cant quite figure it out @.@


sorry for troubling you, Randy :)


Have a nice Christmas day
Attachment(s) from
1 of 1 Photo(s)

Fri Dec 25, 2015 9:02 am (PST) . Posted by:

kennade

spam maybe?It seems when you click to perseu........11 to the site mentioned it will go under his account for number of click visits? Thanks,Ken

From: "perseuslim11@yahoo.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Friday, December 25, 2015 7:14 AM
Subject: [smf_addin] Re: Hi,I'm a newbie here, I've read the faq page, but I still have no clue to get the data below..

 
for the klseinvestor website, the url i would like to access is :OSK: Financials | I3investor
| |
| | | | OSK: Financials | I3investor A free and independent portal for stock investors. The portal provides aggregated investment Blogs and News, Stock Database & Quotes, Price Targets, an... | |
| View on klse.i3investor.com | Preview by Yahoo |
| |

 

for unclestockscreener website, there's no specific url, just http://www.unclestock.com/?email=perseuslim@...&code=-1401172332

but perhaps you could register and try it out? Its quite a good website, you could just register, simple really, just need a username and password, no other info required for registration, that way I think you could try it out?

#yiv7105033899 #yiv7105033899 -- #yiv7105033899ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7105033899 #yiv7105033899ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7105033899 #yiv7105033899ygrp-mkp #yiv7105033899hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7105033899 #yiv7105033899ygrp-mkp #yiv7105033899ads {margin-bottom:10px;}#yiv7105033899 #yiv7105033899ygrp-mkp .yiv7105033899ad {padding:0 0;}#yiv7105033899 #yiv7105033899ygrp-mkp .yiv7105033899ad p {margin:0;}#yiv7105033899 #yiv7105033899ygrp-mkp .yiv7105033899ad a {color:#0000ff;text-decoration:none;}#yiv7105033899 #yiv7105033899ygrp-sponsor #yiv7105033899ygrp-lc {font-family:Arial;}#yiv7105033899 #yiv7105033899ygrp-sponsor #yiv7105033899ygrp-lc #yiv7105033899hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7105033899 #yiv7105033899ygrp-sponsor #yiv7105033899ygrp-lc .yiv7105033899ad {margin-bottom:10px;padding:0 0;}#yiv7105033899 #yiv7105033899actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7105033899 #yiv7105033899activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7105033899 #yiv7105033899activity span {font-weight:700;}#yiv7105033899 #yiv7105033899activity span:first-child {text-transform:uppercase;}#yiv7105033899 #yiv7105033899activity span a {color:#5085b6;text-decoration:none;}#yiv7105033899 #yiv7105033899activity span span {color:#ff7900;}#yiv7105033899 #yiv7105033899activity span .yiv7105033899underline {text-decoration:underline;}#yiv7105033899 .yiv7105033899attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7105033899 .yiv7105033899attach div a {text-decoration:none;}#yiv7105033899 .yiv7105033899attach img {border:none;padding-right:5px;}#yiv7105033899 .yiv7105033899attach label {display:block;margin-bottom:5px;}#yiv7105033899 .yiv7105033899attach label a {text-decoration:none;}#yiv7105033899 blockquote {margin:0 0 0 4px;}#yiv7105033899 .yiv7105033899bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7105033899 .yiv7105033899bold a {text-decoration:none;}#yiv7105033899 dd.yiv7105033899last p a {font-family:Verdana;font-weight:700;}#yiv7105033899 dd.yiv7105033899last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7105033899 dd.yiv7105033899last p span.yiv7105033899yshortcuts {margin-right:0;}#yiv7105033899 div.yiv7105033899attach-table div div a {text-decoration:none;}#yiv7105033899 div.yiv7105033899attach-table {width:400px;}#yiv7105033899 div.yiv7105033899file-title a, #yiv7105033899 div.yiv7105033899file-title a:active, #yiv7105033899 div.yiv7105033899file-title a:hover, #yiv7105033899 div.yiv7105033899file-title a:visited {text-decoration:none;}#yiv7105033899 div.yiv7105033899photo-title a, #yiv7105033899 div.yiv7105033899photo-title a:active, #yiv7105033899 div.yiv7105033899photo-title a:hover, #yiv7105033899 div.yiv7105033899photo-title a:visited {text-decoration:none;}#yiv7105033899 div#yiv7105033899ygrp-mlmsg #yiv7105033899ygrp-msg p a span.yiv7105033899yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7105033899 .yiv7105033899green {color:#628c2a;}#yiv7105033899 .yiv7105033899MsoNormal {margin:0 0 0 0;}#yiv7105033899 o {font-size:0;}#yiv7105033899 #yiv7105033899photos div {float:left;width:72px;}#yiv7105033899 #yiv7105033899photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7105033899 #yiv7105033899photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7105033899 #yiv7105033899reco-category {font-size:77%;}#yiv7105033899 #yiv7105033899reco-desc {font-size:77%;}#yiv7105033899 .yiv7105033899replbq {margin:4px;}#yiv7105033899 #yiv7105033899ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7105033899 #yiv7105033899ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7105033899 #yiv7105033899ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7105033899 #yiv7105033899ygrp-mlmsg select, #yiv7105033899 input, #yiv7105033899 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7105033899 #yiv7105033899ygrp-mlmsg pre, #yiv7105033899 code {font:115% monospace;}#yiv7105033899 #yiv7105033899ygrp-mlmsg * {line-height:1.22em;}#yiv7105033899 #yiv7105033899ygrp-mlmsg #yiv7105033899logo {padding-bottom:10px;}#yiv7105033899 #yiv7105033899ygrp-msg p a {font-family:Verdana;}#yiv7105033899 #yiv7105033899ygrp-msg p#yiv7105033899attach-count span {color:#1E66AE;font-weight:700;}#yiv7105033899 #yiv7105033899ygrp-reco #yiv7105033899reco-head {color:#ff7900;font-weight:700;}#yiv7105033899 #yiv7105033899ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7105033899 #yiv7105033899ygrp-sponsor #yiv7105033899ov li a {font-size:130%;text-decoration:none;}#yiv7105033899 #yiv7105033899ygrp-sponsor #yiv7105033899ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7105033899 #yiv7105033899ygrp-sponsor #yiv7105033899ov ul {margin:0;padding:0 0 0 8px;}#yiv7105033899 #yiv7105033899ygrp-text {font-family:Georgia;}#yiv7105033899 #yiv7105033899ygrp-text p {margin:0 0 1em 0;}#yiv7105033899 #yiv7105033899ygrp-text tt {font-size:120%;}#yiv7105033899 #yiv7105033899ygrp-vital ul li:last-child {border-right:none !important;}#yiv7105033899

Fri Dec 25, 2015 9:16 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That's the source web page that the CSV file comes from. Not the CSV file I
gave you to use earlier. So you're telling the function to process a web
page as if it were a CSV file. Won't work.

On Fri, Dec 25, 2015 at 6:12 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> [Attachment(s) <#151d94517fe9c474_TopText> from perseuslim11@yahoo.com
> [smf_addin] included below]
>
> target url:
> http://financials.morningstar.com/income-statement/is.html?t=7087
> ®ion=mys&culture=en-US
>
> I tried this formula below:
> =smfgetcvsfile("
> http://financials.morningstar.com/income-statement/is.html?t="&tickerno&&quot;
> ®ion=mys&culture=en-US"
>
> but in the end i get the result inside attached photo..
>
> confusing... and the documentation/tipsntricks page is not very clear,
> hence I cant quite figure it out @.@
>
> sorry for troubling you, Randy :)
>
> Have a nice Christmas day
>

Fri Dec 25, 2015 11:27 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetHTMLTable("http://klse.i3investor.com/servlets/stk/fin/5053.jsp","Annual
Result:",1,"",1)

=RCHGetHTMLTable("http://klse.i3investor.com/servlets/stk/fin/5053.jsp","Quarter
Result:",1,"",1)

On Fri, Dec 25, 2015 at 5:14 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> for the klseinvestor website, the url i would like to access is :
> OSK: Financials | I3investor
> <http://klse.i3investor.com/servlets/stk/fin/5053.jsp>
> [image: image] <http://klse.i3investor.com/servlets/stk/fin/5053.jsp>
> OSK: Financials | I3investor
> <http://klse.i3investor.com/servlets/stk/fin/5053.jsp>
> A free and independent portal for stock investors. The portal provides
> aggregated investment Blogs and News, Stock Database & Quotes, Price
> Targets, an...
> View on klse.i3investor.com
> <http://klse.i3investor.com/servlets/stk/fin/5053.jsp>
> Preview by Yahoo
>

Fri Dec 25, 2015 5:55 pm (PST) . Posted by:

jimw1705


Hi,


Are there other options for smfstrExtr to specify the end of a string other than a tilde? (~)


I have an output string enclosed with parenthesis () if the value is negative. Using the tilde (~) option results in the right paren included in the string. Positive numbers work okay; just negatives with the parens are the issue.


This is the function in text format:
=smfstrExtr(smfGetTagContent("http://www.ftportfolios.com/retail/dp/dpprice.aspx?fundid=10277","td",39),"$","~")


This is the result from the function in text format:
<img src="/Common/Images/mktdown.bmp" border="0"> -0.26178% ($0.0222)



This is the actual function output:
0.0222)



I'm looking for a way to specify a character limit or a way to drop the ) from the result.


Thanks.

Fri Dec 25, 2015 6:09 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I'm confused -- why are you extracting to the end of the string instead of
to the right parenthesis?

Here is what I would do:

=smfConvertData(smfStrExtr(smfGetTagContent("
http://www.ftportfolios.com/retail/dp/dpprice.aspx?fundid=10277
","td",39),"$",")"))

I added the smfConvertData() function so that it will convert the extracted
string into a numeric value. If it's not a numeric value, smfConvertData()
would just leave the string as-is.

Hmmm. Would a positive amount NOT have parentheses?

If so, this should work for both positive and negative values:

=smfConvertData(smfStrExtr(smfGetTagContent("
http://www.ftportfolios.com/retail/dp/dpprice.aspx?fundid=10277
","td",39),"%","~"))

The smfConvertData() recognizes that the parentheses around a number make
it negative, and will ignore the dollar sign on the value.

P.S. You REALLY are skipping exactly 39 table cells? That works every time?
I'm surprised.

On Fri, Dec 25, 2015 at 6:55 PM, jimw@premier1.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Are there other options for smfstrExtr to specify the end of a string
> other than a tilde? (~)
>
>
> I have an output string enclosed with parenthesis () if the value is
> negative. Using the tilde (~) option results in the right paren included in
> the string. Positive numbers work okay; just negatives with the parens are
> the issue.
>
>
> This is the function in text format:
>
> =smfstrExtr(smfGetTagContent("
> http://www.ftportfolios.com/retail/dp/dpprice.aspx?fundid=10277
> ","td",39),"$","~")
>
>
> This is the result from the function in text format:
>
> <img src="/Common/Images/mktdown.bmp" border="0"> -0.26178% ($0.0222)
>
>
> This is the actual function output:
>
> 0.0222)
>
>
> I'm looking for a way to specify a character limit or a way to drop the )
> from the result.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.04

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)