Selasa, 16 Januari 2018

[smf_addin] Digest Number 4293

15 Messages

Digest #4293
1a
Monthly Volume by lexstar
1b
Re: Monthly Volume by "Randy Harmelink" rharmelink
1c
1d
Re: Monthly Volume by "Randy Harmelink" rharmelink
1e
1f
Re: Monthly Volume by "Randy Harmelink" rharmelink
1g
1h
1i
Re: Monthly Volume by "Randy Harmelink" rharmelink
3a
3b
Re: Short Interest by "Randy Harmelink" rharmelink
4a
Sector and Industry information by rhonda.federman@gmail.com
4b
Re: Sector and Industry information by "Randy Harmelink" rharmelink

Messages

Tue Jan 16, 2018 6:50 am (PST) . Posted by:

lexstar

Given all the changes recently, what function is best to retrieve MONTHLY VOLUMES if I have a list of 500 stocks.


I'm kinda at a loss because the functions I've been using either returns only ERROR or just BLANK.


Any help is much appreciated. Thanks in advance.


Version is:
Stock Market Functions add-in, Version 2.1.2017.11.30 (C:\Program Files\SMF Add-In; Windows (64-bit) NT 10.00; 16.0; ; ; 1)

Tue Jan 16, 2018 8:39 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Have you tried field #26 of smfGetYahooPortfolioView() or field #80 of
smfGetBarchartPortfolioView()?

On Tue, Jan 16, 2018 at 7:50 AM, lexstar@
​...
wrote:

> Given all the changes recently, what function is best to retrieve MONTHLY
> VOLUMES if I have a list of 500 stocks.
>
> I'm kinda at a loss because the functions I've been using either returns
> only ERROR or just BLANK.
>
> Any help is much appreciated. Thanks in advance.
>
> Version is:
> Stock Market Functions add-in, Version 2.1.2017.11.30 (C:\Program
> Files\SMF Add-In; Windows (64-bit) NT 10.00; 16.0; ; ; 1)
>
>
>

Tue Jan 16, 2018 9:17 am (PST) . Posted by:

lexstar

No I havent tried either one.

However, upon trying them, only smfGetPortfolioView() gave data, the Barchart gave only blank values.


And, I'd prefer 1month's average volume over 3m average volume.

Tue Jan 16, 2018 10:04 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Barchart works fine here (it uses a 3-digit field number if passing it as a
string). Field #79 would be the 1-month volume.

1 9 16 10 6 7 8 12 79
*Ticker Symbol* *Symbol* *Last* *Trade Time* *Change $* *Open* *High* *Low*
*Volume* *1M Avg Vol*
MCD MCD $173.79 12:35 ET $0.22 $173.62 $174.41 $172.88 1168594 2562916
MMM MMM $245.21 12:35 ET $0.74 $245.30 $247.19 $245.08 707619 1679380
SPY SPY $278.47 12:35 ET $0.55 $279.35 $280.09 $278.31 35262273 70837078

On Tue, Jan 16, 2018 at 10:16 AM, lexstar@
​...
wrote:

>
> No I havent tried either one.
>
> However, upon trying them, only smfGetPortfolioView() gave data, the
> Barchart gave only blank values.
>
> And, I'd prefer 1month's average volume over 3m average volume..
>

Tue Jan 16, 2018 11:08 am (PST) . Posted by:

lexstar

I downloaded your example sheets and all I get is this for the Barchart function (see attachment), or below:



1 9 16 10 6 7 8 12 79 13 11 80 Ticker Symbol Symbol Last Trade Time Change $ Open High Low Volume 1M Avg Vol Previous Change % 3M Avg Vol None -- -- -- -- -- -- -- -- -- -- -- -- MMM -- -- -- -- -- -- -- -- -- -- -- -- SPY -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- SPY191220C00260000 -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- ^GBPCAD -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- LLY -- -- -- -- -- -- -- -- -- -- -- -- MDT -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- RY.TO -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- ZWZ17 -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --


Tue Jan 16, 2018 11:29 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The "None" as the first ticker symbol turns off any data retrieval...just
delete its value, or change it to a regular ticker symbol.

These days, I create a lot of my workbooks so that they don't do any data
retrieval when first opened.

On Tue, Jan 16, 2018 at 12:02 PM, lexstar@
​...
wrote:

>
> I downloaded your example sheets and all I get is this for the Barchart
> function (see attachment), or below:
>
>
>
> 1 9 16 10 6 7 8 12 79 13 11 80
> Ticker Symbol Symbol Last Trade Time Change $ Open High Low Volume 1M Avg
> Vol Previous Change % 3M Avg Vol
> None -- -- -- -- -- -- -- -- -- -- -- --
> MMM -- -- -- -- -- -- -- -- -- -- -- --
> SPY -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- -- -- -- -- -- -- -- --
> SPY191220C00260000 -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- -- -- -- -- -- -- -- --
> ^GBPCAD -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- -- -- -- -- -- -- -- --
> LLY -- -- -- -- -- -- -- -- -- -- -- --
> MDT -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- -- -- -- -- -- -- -- --
> RY.TO -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- -- -- -- -- -- -- -- --
> ZWZ17 -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- -- -- -- -- -- -- -- --
>
>
>

Tue Jan 16, 2018 11:45 am (PST) . Posted by:

lexstar

Ahh, thanks a bunch!

Tue Jan 16, 2018 1:20 pm (PST) . Posted by:

lexstar

Is there a limitation as to how many tickers we can use these functions for?

I was only able to download about 400 tickers with data. Thereafter, only get BLANKS.

Please advise. Thanks.

Tue Jan 16, 2018 1:44 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I'm not aware of any enforced limits, but I'm sure limits exist in one form
or another. Not sure whether they would be number of tickers or length of
returned file.Use your own experience as a guide.

But, again, I always question when someone needs so much data? Why do you
need it on all the stocks instead of just select ones, on an ad hoc basis?
If for screening, then use the online screeners.

The very fact people grab so much data is likely to force the free data
provider to turn it off or throttle it. It was a consideration of mine when
I released the add-in in the first place. And still is...

On Tue, Jan 16, 2018 at 2:20 PM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is there a limitation as to how many tickers we can use these functions
> for?
>
> I was only able to download about 400 tickers with data. Thereafter, only
> get BLANKS.
>
> Please advise. Thanks.
>

Tue Jan 16, 2018 8:40 am (PST) . Posted by:

trendsekr

The 2016 release no longer gets option bid/ask (besides stock prices) from yahoo or google. The 2017 release brings excel to its knees - takes hours to try to get quotes then excel freezes. Is this another Yahoo issue, or is there a working release I haven't found?

Thanks,
Michael


Tue Jan 16, 2018 8:54 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I can't think of a reason that would happen, unless you have functions
accessing hundreds of different websites on a recalculation, and those web
sites aren't being used in the 2016 release. I don't have any time issues
here.

Do you have problems with individual functions?

I'd suggest you try logging and see if the bottleneck is certain web sites.
See:

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

On Tue, Jan 16, 2018 at 9:38 AM, trendsekr@
​...
wrote:

>
> The 2016 release no longer gets option bid/ask (besides stock prices) from
> yahoo or google. The 2017 release brings excel to its knees - takes hours
> to try to get quotes then excel freezes. Is this another Yahoo issue, or is
> there a working release I haven't found?
>
>

Tue Jan 16, 2018 12:13 pm (PST) . Posted by:

gbullr

Is GetYahooQuotes for short ratio still working?


Is there another source that works quickly for SMF for a large ticker set?


Thanks Randy.


Happy new year.

Tue Jan 16, 2018 12:36 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Yahoo unplugged their current quotes feed on Halloween, so
RCHGetYahooQuotes() is now obsolete.

The replacement is smfGetYahooPortfolioView(). A template and documentation
can be found on the SMF add-in website. It appears to have short ratio, bu
I'm not sure how accurate it is -- it's returning zero for MMM.

You may want to review entries on the announcements blog since Halloween,
to get some context:

https://smf-add-in.blogspot.com/

I don't recall a good source for bulk retrieval of the shorts data.

On Tue, Jan 16, 2018 at 1:13 PM, gaston.bullrich@
​...
wrote:

> Is GetYahooQuotes for short ratio still working?
>
> Is there another source that works quickly for SMF for a large ticker set?
>
>
>

Tue Jan 16, 2018 12:15 pm (PST) . Posted by:

rhonda.federman@gmail.com

Randy,


I switched my pricing to your addin in November. Thank you for this phenomenal tool!


I was wondering if there is a way to pull the industry and sector information for a list of stocks. This data is on the profile page of a Yahoo Fiance quote. I do not see it on your list of field names. Is there another way to access it?


Rhonda

Tue Jan 16, 2018 12:49 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

To get it from Yahoo right now, I think you'd have to scrape it web by web
page, for each individual ticker symbol.

smfGetBarchartPortfolioView() has a field for "Industry", so you could
easily get it there for a list of stocks.

Finviz is a possibility, but I don't have a function specifically for it
yet. The screener show 20 stocks per page. I'm not sure what the limit of
the multiple quotes page is, but it would generate a HUGE web page if you
did a lot of ticker symbols. Probably not a good idea.

I used to use the Zacks screener to get them. I could do a simple screen of
something like Price > 1 and then export everything that was returned. Then
I could have EXCEL do a VLOOKUP() on that exported data. Since they rarely
change, you'd only need to do the export every once in a while.

On Tue, Jan 16, 2018 at 12:47 PM, rhonda.federman@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I switched my pricing to your addin in November. Thank you for this
> phenomenal tool!
>
> I was wondering if there is a way to pull the industry and sector
> information for a list of stocks. This data is on the profile page of a
> Yahoo Fiance quote. I do not see it on your list of field names. Is there
> another way to access it?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 13.44

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)