15 Messages
Digest #4293
2b
Re: RCH_Stock_Market_Functions-2.1.2016.12.03 vs RCH_Stock_Market_Fu 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)
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.
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)
>
>
>
smfGetBarchartPortf
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.
> 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.
However, upon trying them, only smfGetPortfolioView
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..
>
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
> 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 -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
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 -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- -- -- -- -- -- -- -- --
>
>
>
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 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.
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.
>
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
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?
>
>
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.
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?
>
>
>
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
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?
>
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
Tidak ada komentar:
Posting Komentar