Jumat, 26 Agustus 2016

[smf_addin] Digest Number 3783[1 Attachment]

7 Messages

Digest #3783
1b
Re: Mutual Fund data / attributes by "Randy Harmelink" rharmelink
1d
2a
3b
Re: Sacks Stock Screener Data by "Randy Harmelink" rharmelink

Messages

Thu Aug 25, 2016 6:26 am (PDT) . Posted by:

msimmsx

No Randy, I was referring to the Quote.....to get all of the attributes of the mutual fund.
I just got a mass of text with no data.

Thu Aug 25, 2016 7:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I gave you an example of how to get beta, then you asked about the mutual
fund summary.

I am totally confused right now.

On Thu, Aug 25, 2016 at 6:26 AM, marksimms@
​...wrote:

>
> No Randy, I was referring to the Quote.....to get all of the attributes of
> the mutual fund.
> I just got a mass of text with no data.
>

Thu Aug 25, 2016 1:29 pm (PDT) . Posted by:

msimmsx

No Randy...I wanted the array of attributes for the particular mutual fund.
See attachment.
Prev Close, Net Assets, YTD return, Expense Ratio, Yield.....etc.

I believe this is only possible by making the call to the function symbol by symbol.....
I don't think multiple symbols are supported...in a single call.

I am installing the new version right now.....
I wish you had prefixed your MODULE NAMES with "smf" or "RCH".... as I have over a dozen modules in my VBA project.
It was very tedious to identify each and every one of your modules vs. my own modules !!!
Now I have to remove all of the Excel dependencies.....

You should employe a compiler variable to handle this problem:
#IF AppMode="Excel" then
Do this for Excel
#Else
Do this for Access
#EndIF
Attachment(s) from
1 of 1 Photo(s)

Thu Aug 25, 2016 4:33 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Thu, Aug 25, 2016 at 1:29 PM, marksimms@
​...​
wrote:

>
> No Randy...I wanted the array of attributes for the particular mutual fund.
> See attachment.
> Prev Close, Net Assets, YTD return, Expense Ratio, Yield.....etc.
>

​That's why I gave you an example of extracting the Beta. You'll need to do
something similar for the other items.​

> I believe this is only possible by making the call to the function symbol
> by symbol.....
> I don't think multiple symbols are supported...in a single call.
>

​Yes. You'll have to build the URL for each call, doing a string
concatenation of the ticker symbol where needed.​

I am installing the new version right now.....
> I wish you had prefixed your MODULE NAMES with "smf" or "RCH".... as I
> have over a dozen modules in my VBA project.
> It was very tedious to identify each and every one of your modules vs. my
> own modules !!!
> Now I have to remove all of the Excel dependencies.....
>

​I started out with RCH, because I was writing stuff for my own use, and
people asked me to share. That was in the xlTraders Yahoo group. When I
moved to my own group, I called it SMF, and any new functions started with
SMF. Unfortunately, I couldn't rename all of the old functions as
everything that was already using them would have had major problems
converting all their workbooks to the new formula prefix.

It's not like I planned it that way. :)​

Oh, wait, you're talking about module names. Not function names or macro
names. The module names have never been that kind of issue for me. They're
all in their own VBA project,

> You should employe a compiler variable to handle this problem:
> #IF AppMode="Excel" then
> Do this for Excel
> #Else
> Do this for Access
> #EndIF
>

I'm basically sharing stuff I wrote for my own use.​ I don't use Access.
Besides, I don't want people to abuse the free services and build databases
of data. I hope that's not what you're doing. One big reason I wrote the
add-in is so that I wouldn't HAVE to build databases. The collection of
data on the Internet is my database.

I made a concession to use the compiler variable for Mac usage.

Thu Aug 25, 2016 7:27 am (PDT) . Posted by:

"Leo Bueno" leobueno

Please excuse my wasting your time; I see it's in the Options in Excel.

=========
Leo Bueno
=========

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, August 24, 2016 9:56 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Microsoft Excel security message


I don't see the "Trusted" option in the Properties for any of the worksheets. I am using Window 7, Excel 2010.

Leo Bueno
305-669-5260
1825 Ponce de Leon Boulevard # 483
Coral Gables, FL 33134
Leo@BuenoLaw.com
Skype: BuenoLaw

[cid:image001.png@01D1E033.9E0A3CC0]



From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Thursday, July 28, 2016 12:27 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Microsoft Excel security message



Randy:

Adding the Trusted Location works perfectly. Maybe add that step to the installation instructions.

Thank for everything you do.

NM

Thu Aug 25, 2016 4:22 pm (PDT) . Posted by:

cgrablew

Randy,


Not sure you can answer this but I thought I'd ask - Zacks stock screener data and their website data seem to be different for a stock. For example, if you look at the stock ASH, the stock screener data says 5 out of 5 brokers recommend a strong buy but if you look at their website (field 13873) it says HOLD. There are several stocks like this that seemed to be disconnected. Any idea of why?


Chuck Grablewski
cgrablew@gmail.com

Thu Aug 25, 2016 4:50 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Element 13873 is the Zack's recommendation, not a broker recommendation. I
have it as a SELL right now:

https://www.zacks.com/stock/quote/ASH

Upper right hand corner shows the Zacks rank and recommendation: "4-Sell"

Sounds like what you're after is the current average broker recommendation
(i.e. ABR) from here;

https://www.zacks.com/stock/research/ASH/brokerage-recommendations

That's element #13885. Note the "4-Sell" Zacks rating and recommendation on
that page as well.

Or are you not asking about the element values being returned, but why
Zack's and the brokers differ? If so, one big difference could be
timeliness. I don't know how old each of the brokers' recommendations are.
It's not like they update them every day, while the Zack's
rating/recommendation might be. There was a big drop in price about a month
ago. Maybe that caused the big departure, because of the way Zack's
constructs their rating. ASH also released earning just a few weeks ago...

On Thu, Aug 25, 2016 at 4:22 PM, cgrablew@
​...​
wrote:

> Not sure you can answer this but I thought I'd ask - Zacks stock screener
> data and their website data seem to be different for a stock. For example,
> if you look at the stock ASH, the stock screener data says 5 out of 5
> brokers recommend a strong buy but if you look at their website (field
> 13873) it says HOLD. There are several stocks like this that seemed to be
> disconnected. Any idea of why?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar