Sabtu, 23 Januari 2016

[smf_addin] Digest Number 3614

15 Messages

Digest #3614
1a
add-in stopped working by "SaL" salarkhor
1b
Re: add-in stopped working by "Randy Harmelink" rharmelink
1e
Re: add-in stopped working by "Randy Harmelink" rharmelink
1g
Re: add-in stopped working by "Randy Harmelink" rharmelink

Messages

Fri Jan 22, 2016 8:34 am (PST) . Posted by:

"SaL" salarkhor

Hi Randy,
The add-in suddenly stopped working for me. I have re-installed it (and applied the suggestions 2, 4, 4a in FAQ) but still the same issue that all cells either show "error" or "#VALUE!".

For instance "=smfGetAdvFNElement(Ticker, "A", 1, ">total revenue<")" gives back "Error". Any idea what could be the issue here? I went through all FAQs but didn't manage myself so any help is so appreciated.

In case this is relevant:
- "=RCHGetElementNumber("Version")" gives back "Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF Add-In; www; Local; 31)"
- Located in the Netherlands

Thanks a lot for the support

Fri Jan 22, 2016 9:58 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I notice that you're using the "www" prefix for AdvFN. It might be that the
Netherlands is now under a regional area for AdvFN. If you type this
address in your browser:

http://www.advfn.com/

...does it stay the same in the address bar, or are you redirected to
another website (e.g. http://uk.advfn.com)?

PS: My ancestors came from Friesland. I hear that's where I get my
stubbornness from.

On Fri, Jan 22, 2016 at 9:34 AM, SaL salarkhor@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Hi Randy,
> The add-in suddenly stopped working for me. I have re-installed it (and
> applied the suggestions 2, 4, 4a in FAQ) but still the same issue that all
> cells either show "error" or "#VALUE!".
>
> For instance "=smfGetAdvFNElement(Ticker, "A", 1, ">total revenue<")"
> gives back "Error". Any idea what could be the issue here? I went through
> all FAQs but didn't manage myself so any help is so appreciated.
>
> In case this is relevant:
> - "=RCHGetElementNumber("Version")" gives back "Stock Market Functions
> add-in, Version 2.1.2015.08.13 (C:\SMF Add-In; www; Local; 31)"
> - Located in the Netherlands
>
> Thanks a lot for the support
>

Fri Jan 22, 2016 12:27 pm (PST) . Posted by:

salarkhor

update: by scrolling through this group, i noticed the redirection is a known issue and the solution is to create a txt file called "smf-AdvFN-Prefix.txt" (in the same directory as the add-in) with the two letters "uk" in it... Done... However, I still have the same issue.

Fri Jan 22, 2016 12:32 pm (PST) . Posted by:

salarkhor

Hi Randy, It seems that you're on to something cuz i'm indeed redirected to http://uk.advfn.com/ http://uk.advfn.com/
How should I tackle this in the add-in?


PS: Haha. People from Friesland are not only known to be confident (or stubborn:), but also very down to earth and big in length... If that sounds familiar, you might have more than only your stubborness from Friesland:-)

Fri Jan 22, 2016 1:09 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Then it depends on what isn't working.

If you're getting redirected to the "uk" site, it means your default stock
exchange is the London exchange. That means if you use a ticker symbol of
"COST", you'd get the Costain Group (which doesn't have financials listed).
You'd need to use "NASDAQ:COST" to get to Costco Wholesale Corp.

For example, check out the recent message thread that had this message:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/29527

Do the two formulas mentioned there work for you? That is:

=smfGetAdvFNElement("NASDAQ:COST","A",1,">date preliminary data
loaded<",,"--")

=RCHGetElementNumber("NASDAQ:COST",5206)

PS: Big in length AND width.

On Fri, Jan 22, 2016 at 1:32 PM, salarkhor@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> It seems that you're on to something cuz i'm indeed redirected to
> http://uk.advfn.com/
> How should I tackle this in the add-in?
>
> PS: Haha. People from Friesland are not only known to be confident (or
> stubborn:), but also very down to earth and big in length... If that sounds
> familiar, you might have more than only your stubborness from Friesland:-)
>
>

Fri Jan 22, 2016 2:57 pm (PST) . Posted by:

salarkhor

With both examples I get an "Error". The same for RCHGetYahooQuotes("COST"), even if I'd put "NASDAQ:COST" in the argument.

In case it makes any difference, I noticed I'm redirected to uk.advfn.com (without "http://"). Any other check I could do?



Fri Jan 22, 2016 3:32 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

About the only way RCHGetYahooQuotes("COST") would give an "Error" result
is if there is a communication error of some type. That would have nothing
to do with AdvFN.

Do you have some type of firewall that went up and is preventing EXCEL from
accessing the Internet?

On Fri, Jan 22, 2016 at 3:57 PM, salarkhor@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> With both examples I get an "Error". The same
> for RCHGetYahooQuotes("COST"), even if I'd put "NASDAQ:COST" in the
> argument.
>
> In case it makes any difference, I noticed I'm redirected to uk.advfn.com
> (without "http://"). Any other check I could do?
>

Sat Jan 23, 2016 4:55 pm (PST) . Posted by:

perseuslim11

Hi Randy, I've recently been back to working on my template after a few weeks of exams, I now know roughly how to use the RCHgetHTMLtable function, but I am still unable to automate the process, ie: i would like to make the table auto update whenever I change the ticker number, which i named "stockno"

=RCHGetHTMLTable("http://www.klse.my/stock/result/financial/quarterAnalysis/=stockno.jsp","Revenue (",-1,"",17)



the link above , when i put in the "=stockno"; instead of a number like 0104, the whole table is gone,
please teach me? sorry for the trouble Randy :(


Sat Jan 23, 2016 5:14 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It's just the normal string concatenation process of EXCEL. You have three
strings, one in a cell:

"http://www.klse.my/stock/result/financial/quarterAnalysis/"
A1
".jsp"

You concatenate them by putting an ampersand in between them. So:

=RCHGetHTMLTable("http://www.klse.my/stock/result/financial/quarterAnalysis/"
& A1 & ".jsp","Revenue (",-1,"",17)

With your STRING value of "0104" in cell A1. Note that if you just type
0104 in cell A1, ESCEL will convert it to a numeric 104, so make sure you
enter it as a string. Either as:

="0104"
'0104

On Sat, Jan 23, 2016 at 5:55 PM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi Randy, I've recently been back to working on my template after a few
> weeks of exams, I now know roughly how to use the RCHgetHTMLtable function,
> but I am still unable to automate the process, ie: i would like to make the
> table auto update whenever I change the ticker number, which i named
> "stockno"
>
> =RCHGetHTMLTable("
> http://www.klse.my/stock/result/financial/quarterAnalysis/=stockno.jsp","Revenue
> (",-1,"",17)
>
> the link above , when i put in the "=stockno"; instead of a number like
> 0104, the whole table is gone,
> please teach me? sorry for the trouble Randy :(
>

Sat Jan 23, 2016 6:58 pm (PST) . Posted by:

"joo zhi" perseuslim11

Ok, thanks Randy, I got it working after adding the concatenation ^^

Sent from Yahoo Mail on Android

On Sun, 24 Jan, 2016 at 9:14, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:  

It's just the normal string concatenation process of EXCEL. You have three strings, one in a cell:

"http://www.klse.my/stock/result/financial/quarterAnalysis/"
A1
".jsp"

You concatenate them by putting an ampersand in between them. So:

=RCHGetHTMLTable("http://www.klse.my/stock/result/financial/quarterAnalysis/" & A1 & ".jsp","Revenue (",-1,"",17)

With your STRING value of "0104" in cell A1. Note that if you just type 0104 in cell A1, ESCEL will convert it to a numeric 104, so make sure you enter it as a string. Either as:

="0104"
'0104

On Sat, Jan 23, 2016 at 5:55 PM, perseuslim11@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Hi Randy, I've recently been back to working on my template after a few weeks of exams, I now know roughly how to use the RCHgetHTMLtable function, but I am still unable to automate the process, ie: i would like to make the table auto update whenever I change the ticker number, which i named "stockno"
=RCHGetHTMLTable("http://www.klse.my/stock/result/financial/quarterAnalysis/=stockno.jsp","Revenue (",-1,"",17)

the link above , when i put in the "=stockno"; instead of a number like 0104, the whole table is gone,please teach me? sorry for the trouble Randy :(

Sat Jan 23, 2016 7:18 pm (PST) . Posted by:

perseuslim11

Randy, if I would like to get the 10 year MGS (Close%) value 3.88 from this url: BNM Government Securities Yield http://www.bnm.gov.my/index.php?tpl=govtsecuritiesyield

BNM Government Securities Yield http://www.bnm.gov.my/index.php?tpl=govtsecuritiesyield Malaysian Government Securities (MGS) - Conventional MGS Benchmarks Trading Yields Total Volume (RM million) Daily change (bps) Tenure Maturity Coupon (%) Low (%) High (%) Close (%) 3-year Mar-2019



View on www.bnm.gov.my http://www.bnm.gov.my/index.php?tpl=govtsecuritiesyield
Preview by Yahoo





what function should i use? is it the RCHgetElementNumber? but i press into the guide, its for
=RCHGetElementNumber( ticker , elementnumber [, errorvalue ] )

ticker,elementnumber only, im not sure how to use it for getting the value I need?






Sat Jan 23, 2016 7:31 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetTableCell("http://www.bnm.gov.my/index.php?tpl=govtsecuritiesyield
",5,">10-year")

The RCHGetElementNumber() is only for "saved" data retrievals. Nothing from
that web page is on the list, so you need to extract it yourself.
Typically, that is done with either RCHGetTableCell() or
smfGetTagContent(), depending on how the web page is coded. As a last
resort, you would go to RCHGetWebData(), where you have to extract it
yourself without using any of the HTML tags on the web page.

On Sat, Jan 23, 2016 at 8:18 PM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Randy, if I would like to get the 10 year MGS (Close%) value 3.88
> from this url: BNM Government Securities Yield
> <http://www.bnm.gov.my/index.php?tpl=govtsecuritiesyield>
>
> what function should i use? is it the RCHgetElementNumber? but i press
> into the guide, its for
> *=RCHGetElementNumber( ticker , elementnumber [, errorvalue ] )*
> ticker,elementnumber only, im not sure how to use it for getting the value
> I need?
>
>
>

Sat Jan 23, 2016 7:35 pm (PST) . Posted by:

perseuslim11

Thanks Randy :)

btw, one question, will the number 3.88 be autoupdated to a new value if the website value changes to say, 4.21?
or will it be stuck at 3.88?

Sat Jan 23, 2016 7:45 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It would be stuck at 3.88.

You would need to use smfForceRecalculation macro to force the add-in to
get a fresh copy of all web pages.

Exiting and restarting EXCEL would accomplish the same thing.

That's because the add-in saves a copy of a web page before extracting data
from it. If you do a normal recalculation, it would just redo the extract
from the same saved copy of the web page.

smfForceRecalculation purges all saved copies of web pages, so the
functions need to get a new copy.

On Sat, Jan 23, 2016 at 8:35 PM, perseuslim11@... wrote:

>
> btw, one question, will the number 3.88 be autoupdated to a new value if
> the website value changes to say, 4.21?
> or will it be stuck at 3.88?
>

Sat Jan 23, 2016 6:07 pm (PST) . Posted by:

ibm6550

Randy, Thanks for your reply, when I use extended ticker symbol as quote I can't fetch anything, even those original working quotes (KO, MMM, AAPL....I mentioned).
I will use build-in "From Web" function in Excel for certain quotes to complete my task.


Thanks!
Benny
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar