Kamis, 19 Mei 2016

[smf_addin] Digest Number 3702[2 Attachments]

13 Messages

Digest #3702
2b
Re: Zacks Rank No Longer Available? by "Randy Harmelink" rharmelink

Messages

Wed May 18, 2016 4:33 am (PDT) . Posted by:

perseuslim11

Hmm, I've just tried out the smfupdatedownloadtable, but after filling all data needed, then press Ctrl+Shift+J, nothing happens..?

Wed May 18, 2016 4:42 am (PDT) . Posted by:

perseuslim11

attached above is the smfupdatedownloadtable with my own data put into it, but somehow, pressing Ctrl-shift-J (control first, then shift, then J) doesm't have any effects..

I'ved also read the article u linked above, as well as the 4 other articles in tips n facts, but there isnt anywhere that tells me why nothing happends after filling in data and pressing ctrl shift j


Hmm..
Attachment(s) from
1 of 1 File(s)

Wed May 18, 2016 4:51 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

With changes in EXCEL versions and O/S, the keyboard shortcut wasn't
carried forward by EXCEL. That's why I specifically said:

*"You should just be able to run the smfUpdateDownloadTable macro from your
context menu, or via the macro dialog page. I usually run it from a button
I created on my toolbar."*
I highlight
​ed a small range and ran the macro in the attachment you sent, and it
filled the range in.

On Wed, May 18, 2016 at 4:33 AM, perseuslim11@ <perseuslim11@yahoo.com>
​...​
wrote:

>
> Hmm, I've just tried out the smfupdatedownloadtable, but after filling all
> data needed, then press Ctrl+Shift+J, nothing happens..?
>
>

Wed May 18, 2016 5:00 am (PDT) . Posted by:

"joo zhi" perseuslim11

my macro dialog page is empty for this xls file @.@ 

On Wednesday, May 18, 2016 7:52 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  With changes in EXCEL versions and O/S, the keyboard shortcut wasn't carried forward by EXCEL. That's why I specifically said:

"You should just be able to run the smfUpdateDownloadTable macro from your context menu, or via the macro dialog page. I usually run it from a button I created on my toolbar."

I highlight​ed a small range and ran the macro in the attachment you sent, and it filled the range in.

On Wed, May 18, 2016 at 4:33 AM, perseuslim11@​...​ wrote:

Hmm, I've just tried out the smfupdatedownloadtable, but after filling all data needed, then press Ctrl+Shift+J, nothing happens..?

#yiv6467245360 #yiv6467245360 -- #yiv6467245360ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6467245360 #yiv6467245360ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6467245360 #yiv6467245360ygrp-mkp #yiv6467245360hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6467245360 #yiv6467245360ygrp-mkp #yiv6467245360ads {margin-bottom:10px;}#yiv6467245360 #yiv6467245360ygrp-mkp .yiv6467245360ad {padding:0 0;}#yiv6467245360 #yiv6467245360ygrp-mkp .yiv6467245360ad p {margin:0;}#yiv6467245360 #yiv6467245360ygrp-mkp .yiv6467245360ad a {color:#0000ff;text-decoration:none;}#yiv6467245360 #yiv6467245360ygrp-sponsor #yiv6467245360ygrp-lc {font-family:Arial;}#yiv6467245360 #yiv6467245360ygrp-sponsor #yiv6467245360ygrp-lc #yiv6467245360hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6467245360 #yiv6467245360ygrp-sponsor #yiv6467245360ygrp-lc .yiv6467245360ad {margin-bottom:10px;padding:0 0;}#yiv6467245360 #yiv6467245360actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6467245360 #yiv6467245360activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6467245360 #yiv6467245360activity span {font-weight:700;}#yiv6467245360 #yiv6467245360activity span:first-child {text-transform:uppercase;}#yiv6467245360 #yiv6467245360activity span a {color:#5085b6;text-decoration:none;}#yiv6467245360 #yiv6467245360activity span span {color:#ff7900;}#yiv6467245360 #yiv6467245360activity span .yiv6467245360underline {text-decoration:underline;}#yiv6467245360 .yiv6467245360attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6467245360 .yiv6467245360attach div a {text-decoration:none;}#yiv6467245360 .yiv6467245360attach img {border:none;padding-right:5px;}#yiv6467245360 .yiv6467245360attach label {display:block;margin-bottom:5px;}#yiv6467245360 .yiv6467245360attach label a {text-decoration:none;}#yiv6467245360 blockquote {margin:0 0 0 4px;}#yiv6467245360 .yiv6467245360bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6467245360 .yiv6467245360bold a {text-decoration:none;}#yiv6467245360 dd.yiv6467245360last p a {font-family:Verdana;font-weight:700;}#yiv6467245360 dd.yiv6467245360last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6467245360 dd.yiv6467245360last p span.yiv6467245360yshortcuts {margin-right:0;}#yiv6467245360 div.yiv6467245360attach-table div div a {text-decoration:none;}#yiv6467245360 div.yiv6467245360attach-table {width:400px;}#yiv6467245360 div.yiv6467245360file-title a, #yiv6467245360 div.yiv6467245360file-title a:active, #yiv6467245360 div.yiv6467245360file-title a:hover, #yiv6467245360 div.yiv6467245360file-title a:visited {text-decoration:none;}#yiv6467245360 div.yiv6467245360photo-title a, #yiv6467245360 div.yiv6467245360photo-title a:active, #yiv6467245360 div.yiv6467245360photo-title a:hover, #yiv6467245360 div.yiv6467245360photo-title a:visited {text-decoration:none;}#yiv6467245360 div#yiv6467245360ygrp-mlmsg #yiv6467245360ygrp-msg p a span.yiv6467245360yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6467245360 .yiv6467245360green {color:#628c2a;}#yiv6467245360 .yiv6467245360MsoNormal {margin:0 0 0 0;}#yiv6467245360 o {font-size:0;}#yiv6467245360 #yiv6467245360photos div {float:left;width:72px;}#yiv6467245360 #yiv6467245360photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6467245360 #yiv6467245360photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6467245360 #yiv6467245360reco-category {font-size:77%;}#yiv6467245360 #yiv6467245360reco-desc {font-size:77%;}#yiv6467245360 .yiv6467245360replbq {margin:4px;}#yiv6467245360 #yiv6467245360ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6467245360 #yiv6467245360ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6467245360 #yiv6467245360ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6467245360 #yiv6467245360ygrp-mlmsg select, #yiv6467245360 input, #yiv6467245360 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6467245360 #yiv6467245360ygrp-mlmsg pre, #yiv6467245360 code {font:115% monospace;}#yiv6467245360 #yiv6467245360ygrp-mlmsg * {line-height:1.22em;}#yiv6467245360 #yiv6467245360ygrp-mlmsg #yiv6467245360logo {padding-bottom:10px;}#yiv6467245360 #yiv6467245360ygrp-msg p a {font-family:Verdana;}#yiv6467245360 #yiv6467245360ygrp-msg p#yiv6467245360attach-count span {color:#1E66AE;font-weight:700;}#yiv6467245360 #yiv6467245360ygrp-reco #yiv6467245360reco-head {color:#ff7900;font-weight:700;}#yiv6467245360 #yiv6467245360ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6467245360 #yiv6467245360ygrp-sponsor #yiv6467245360ov li a {font-size:130%;text-decoration:none;}#yiv6467245360 #yiv6467245360ygrp-sponsor #yiv6467245360ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6467245360 #yiv6467245360ygrp-sponsor #yiv6467245360ov ul {margin:0;padding:0 0 0 8px;}#yiv6467245360 #yiv6467245360ygrp-text {font-family:Georgia;}#yiv6467245360 #yiv6467245360ygrp-text p {margin:0 0 1em 0;}#yiv6467245360 #yiv6467245360ygrp-text tt {font-size:120%;}#yiv6467245360 #yiv6467245360ygrp-vital ul li:last-child {border-right:none !important;}#yiv6467245360

Attachment(s) from joo zhi
1 of 1 Photo(s)

Wed May 18, 2016 5:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's because the macro dialog only shows macros in open workbooks, which
doesn't include add-ins. You would need to type in the macro name when it's
in something like the add-in. Once you type in the full macro name, your
buttons on the right should activate. That's why I attached the macro to a
button on my toolbar. Much easier to access, and I use it quite a bit.

But, like I said, it should also be on the context menu within EXCEL. Just
right-click, click on "SMF", then on "Update Download Table".

On Wed, May 18, 2016 at 4:57 AM, joo zhi perseuslim11@
​... ​
wrote:

>
>
> my macro dialog page is empty for this xls file @.@
>
>

Wed May 18, 2016 7:44 am (PDT) . Posted by:

perseuslim11

Hi Randy, I've so far been successful in getting data for most items, however there are 2 items from Reuters that returns "Error"

smfGetTagContent("http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~.KL","td",1,"Sales (TTM) vs TTM 1 Yr. Ago")



smfGetTagContent("http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~.KL","td",1,"Sales - 5 Yr. Growth Rate")



above 2 are the only ones returning problems..
however, when tested as individual smfgettagcontent function, they work fine, just couldnt work well in the smfupdatedownloadtable


Any idea on what causes it?


Wed May 18, 2016 7:52 am (PDT) . Posted by:

perseuslim11

I found out the problem, it is due to reuters using their own specialised stock ticker, called the RICs (Reuters Instrument Code)

so now arises another problem, how do I use smfupdatedownloadtable to refer to the normal stock ticker and also the Reuters specialised ticker?


smfGetTagContent("http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~.KL","td",1,"Sales (TTM) vs TTM 1 Yr. Ago")



smfGetTagContent("http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~.KL","td",1,"Sales - 5 Yr. Growth Rate")




Example:
Normal ticker, Reuters ticker
0012, THEA
5959, AMRE
7086, ABEL


Only reuters uses such specialised ticker..

Wed May 18, 2016 9:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

There's not a way to do two different tickers there...at least nothing that
comes to mind.

On Wed, May 18, 2016 at 7:52 AM, perseuslim11@
​...​
wrote:

>
> I found out the problem, it is due to reuters using their own specialised
> stock ticker, called the RICs (Reuters Instrument Code)
>
> so now arises another problem, how do I use smfupdatedownloadtable to
> refer to the normal stock ticker and also the Reuters specialised ticker?
>
> smfGetTagContent("
> http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~.KL","td",1,"Sales
> (TTM) vs TTM 1 Yr. Ago")
>
> smfGetTagContent("
> http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~.KL","td",1,"Sales
> - 5 Yr. Growth Rate")
>
> Example:
> Normal ticker, Reuters ticker
> 0012, THEA
> 5959, AMRE
> 7086, ABEL
>
> Only reuters uses such specialised ticker..
>
>

Wed May 18, 2016 9:47 am (PDT) . Posted by:

"joo zhi" perseuslim11

Well, I did the next best thing, by copying another sheet the do it for reuters for those two items on the new sheet. Problem solved ^_^ Thanks Randy :)

Sent from Yahoo Mail on Android

On Thu, 19 May, 2016 at 0:02, Randy Harmelink rharmelink@gmail.com [smf_addin]<smf_addin@yahoogroups.com> wrote:  

There's not a way to do two different tickers there...at least nothing that comes to mind.

On Wed, May 18, 2016 at 7:52 AM, perseuslim11@​...​ wrote:

I found out the problem, it is due to reuters using their own specialised stock ticker, called the RICs (Reuters Instrument Code)
so now arises another problem, how do I use smfupdatedownloadtable to refer to the normal stock ticker and also the Reuters specialised ticker?
smfGetTagContent("http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~.KL","td",1,"Sales (TTM) vs TTM 1 Yr. Ago")

smfGetTagContent("http://www.reuters.com/finance/stocks/financialHighlights?symbol=~~~~~.KL","td",1,"Sales - 5 Yr. Growth Rate")

Example:Normal ticker, Reuters ticker0012, THEA5959, AMRE7086, ABEL
Only reuters uses such specialised ticker..

Wed May 18, 2016 10:02 am (PDT) . Posted by:

ghart21

I think there were messages some time ago that Zack's rank for individual stocks is no longer available from SMF. Used to be Element #848. Is that correct?

Wed May 18, 2016 10:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It is now obsolete...

On Wed, May 18, 2016 at 10:01 AM, ghart23@
​...​
wrote:

> I think there were messages some time ago that Zack's rank for individual
> stocks is no longer available from SMF. Used to be Element #848. Is that
> correct?
>
>

Wed May 18, 2016 10:28 am (PDT) . Posted by:

ghart21

Thanks Randy


-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: May 18, 2016 1:21 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Zacks Rank No Longer Available?



It is now obsolete...

On Wed, May 18, 2016 at 10:01 AM, ghart23@​...​
wrote:

I think there were messages some time ago that Zack's rank for
individual stocks is no longer available from SMF. Used to be
Element #848. Is that correct?




For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.25

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)