7 Messages
Digest #4367
1f
Re: smfGetYahooPortfolioView showing limited names [2 Attachments] by "Randy Harmelink" rharmelink
Messages
Wed Jul 25, 2018 8:18 am (PDT) . Posted by:
eclipsme
Randy, I have experience something similar, randomly and only occasionally. Here is my situation and how I have dealt with it:
I capture approximately 50-55 stocks using this formula:
='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetYahooPortfolioView($B$4:$B$412,$C$2:$AJ$2,,1)
Sometimes that last 10 or so stocks would be 'ignored', as the OP says - I don't remember exactly what the message in the cell was.
I created another sheet that captures only the last 15 stocks.
I have a 'combining sheet' where the first 45 tickers reference the original sheet and the rest look to the 2nd sheet. This is the sheet I reference from everywhere else.
I don't have any idea how often this is happening as having the 2nd sheet to read in the last stocks has always worked for me.
I have a hunch this is rooted in something Yahoo does. If it was the add-in, I would expect it to be much more predictable.
Hope that helps...
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
Not sure what you mean by "names"? Ticker symbols? If so, I just opened one of my workbooks that gets data for over 300 ticker symbols, and it works fine.
Possibly an issue with a ticker symbol?
On Tue, Jul 24, 2018 at 9:43 AM, mdediego@ ...
wrote:
Is it just me or smfGetYahooPortfolioView is returning data on just 56 names? anything beyond that is ignored...
I capture approximately 50-55 stocks using this formula:
='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetYahooPortfolioView($B$4:$B$412,$C$2:$AJ$2,,1)
Sometimes that last 10 or so stocks would be 'ignored', as the OP says - I don't remember exactly what the message in the cell was.
I created another sheet that captures only the last 15 stocks.
I have a 'combining sheet' where the first 45 tickers reference the original sheet and the rest look to the 2nd sheet. This is the sheet I reference from everywhere else.
I don't have any idea how often this is happening as having the 2nd sheet to read in the last stocks has always worked for me.
I have a hunch this is rooted in something Yahoo does. If it was the add-in, I would expect it to be much more predictable.
Hope that helps...
---In smf_addin@yahoogroups.com, <rharmelink@
Not sure what you mean by "names"
Possibly an issue with a ticker symbol?
On Tue, Jul 24, 2018 at 9:43 AM, mdediego@ ...
wrote:
Is it just me or smfGetYahooPortfoli
Wed Jul 25, 2018 10:04 am (PDT) . Posted by:
mdediegop
That was it... tickers that are no longer available were interfering with the rest of the list. The issue just appeared a couple of days ago, so I wonder why it was working before...
Thanks a lot Randy
Thanks a lot Randy
Wed Jul 25, 2018 3:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You really shouldn't keep the "
'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!" prefix on the add-in. It's
not operating as an add-in that way. Run the smfFixLinks macro to remove
the prefix. When you save the file and reopen it, that prefix should be
gone.
I'm surprised you're not getting #NAME? errors because of the prefix.
I've found Yahoo does different things when symbols are invalid. Not sure
why. Sometimes it just return no data for the ticker symbol. Other times it
stops processing ticker symbols at that point. And what it returns is not
always the same order in which ticker symbols were sent, so results can be
difficult to interpret without actually looking at the raw data Yahoo is
sending back.
On Wed, Jul 25, 2018 at 8:18 AM, harvey@
...
wrote:
>
> Randy, I have experience something similar, randomly and only
> occasionally. Here is my situation and how I have dealt with it:
>
> I capture approximately 50-55 stocks using this formula:
> =
>
> 'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!
> smfGetYahooPortfolioView($B$4:$B$412,$C$2:$AJ$2,,1)
>
> Sometimes that last 10 or so stocks would be 'ignored', as the OP says - I
> don't remember exactly what the message in the cell was.
>
> I created another sheet that captures only the last 15 stocks.
>
> I have a 'combining sheet' where the first 45 tickers reference the
> original sheet and the rest look to the 2nd sheet. This is the sheet I
> reference from everywhere else.
>
> I don't have any idea how often this is happening as having the 2nd sheet
> to read in the last stocks has always worked for me.
>
> I have a hunch this is rooted in something Yahoo does. If it was the
> add-in, I would expect it to be much more predictable.
>
> Hope that helps...
>
>
>
'C:\
not operating as an add-in that way. Run the smfFixLinks macro to remove
the prefix. When you save the file and reopen it, that prefix should be
gone.
I'm surprised you're not getting #NAME? errors because of the prefix.
I've found Yahoo does different things when symbols are invalid. Not sure
why. Sometimes it just return no data for the ticker symbol. Other times it
stops processing ticker symbols at that point. And what it returns is not
always the same order in which ticker symbols were sent, so results can be
difficult to interpret without actually looking at the raw data Yahoo is
sending back.
On Wed, Jul 25, 2018 at 8:18 AM, harvey@
...
wrote:
>
> Randy, I have experience something similar, randomly and only
> occasionally. Here is my situation and how I have dealt with it:
>
> I capture approximately 50-55 stocks using this formula:
> =
>
> 'C:\
> smfGetYahooPortfoli
>
> Sometimes that last 10 or so stocks would be 'ignored&#
> don't remember exactly what the message in the cell was.
>
> I created another sheet that captures only the last 15 stocks.
>
> I have a 'combining sheet' where the first 45 tickers reference the
> original sheet and the rest look to the 2nd sheet. This is the sheet I
> reference from everywhere else.
>
> I don't have any idea how often this is happening as having the 2nd sheet
> to read in the last stocks has always worked for me.
>
> I have a hunch this is rooted in something Yahoo does. If it was the
> add-in, I would expect it to be much more predictable.
>
> Hope that helps...
>
>
>
Wed Jul 25, 2018 7:22 pm (PDT) . Posted by:
"Pieter van Leeuwen" pietertvl
My fetch list is considerably longer (>200), and I'm not having that problem (truncation) at all. Most are ETFs.
I do purge dead tickers, but most are pretty active. So that won't happen to me often.
The other day, near the open, the GYPV fetch was having trouble nabbing Highs and Lows. Half showing as zero's.
But they cleaned that up 30 min into the session and it hasn't recurred..
Just a shout out while here to say thanks for the tool.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, July 25, 2018 9:19 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: smfGetYahooPortfolioView showing limited names
Randy, I have experience something similar, randomly and only occasionally. Here is my situation and how I have dealt with it:
I capture approximately 50-55 stocks using this formula:
='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetYahooPortfolioView($B$4:$B$412,$C$2:$AJ$2,,1)
Sometimes that last 10 or so stocks would be 'ignored', as the OP says - I don't remember exactly what the message in the cell was.
I created another sheet that captures only the last 15 stocks.
I have a 'combining sheet' where the first 45 tickers reference the original sheet and the rest look to the 2nd sheet. This is the sheet I reference from everywhere else.
I don't have any idea how often this is happening as having the 2nd sheet to read in the last stocks has always worked for me.
I have a hunch this is rooted in something Yahoo does. If it was the add-in, I would expect it to be much more predictable.
Hope that helps...
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
Not sure what you mean by "names"? Ticker symbols? If so, I just opened one of my workbooks that gets data for over 300 ticker symbols, and it works fine.
Possibly an issue with a ticker symbol?
On Tue, Jul 24, 2018 at 9:43 AM, mdediego@
...
wrote:
Is it just me or smfGetYahooPortfolioView is returning data on just 56 names? anything beyond that is ignored...
I do purge dead tickers, but most are pretty active. So that won't happen to me often.
The other day, near the open, the GYPV fetch was having trouble nabbing Highs and Lows. Half showing as zero's.
But they cleaned that up 30 min into the session and it hasn't recurred..
Just a shout out while here to say thanks for the tool.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Wednesday, July 25, 2018 9:19 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: smfGetYahooPortfolioView showing limited names
Randy, I have experience something similar, randomly and only occasionally. Here is my situation and how I have dealt with it:
I capture approximately 50-55 stocks using this formula:
='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetYahooPortfolioView($B$4:$B$412,$C$2:$AJ$2,,1)
Sometimes that last 10 or so stocks would be 'ignored', as the OP says - I don't remember exactly what the message in the cell was.
I created another sheet that captures only the last 15 stocks.
I have a 'combining sheet' where the first 45 tickers reference the original sheet and the rest look to the 2nd sheet. This is the sheet I reference from everywhere else.
I don't have any idea how often this is happening as having the 2nd sheet to read in the last stocks has always worked for me.
I have a hunch this is rooted in something Yahoo does. If it was the add-in, I would expect it to be much more predictable.
Hope that helps...
---In smf_addin@yahoogroups.com, <rharmelink@
Not sure what you mean by "names"
Possibly an issue with a ticker symbol?
On Tue, Jul 24, 2018 at 9:43 AM, mdediego@
...
wrote:
Is it just me or smfGetYahooPortfoli
Wed Jul 25, 2018 7:32 pm (PDT) . Posted by:
pete_cook2001
I'm not sure if this is the same issue, but there are many stocks for which smfgetyahooportfolioview() pulls data and there are many for which it doesn't.
I simply took the "field numbers" tab of the smfgetyahooportfolioview-sample.xls sheet and added a ticker field plus a column which returns the function's value using the ticker and the field number for that row.
If I plug in "F" for the ticker, all of the cells in that column return the correct data. If I change the ticker to "TSLA" all of the cells return "--".
(see attached)
I simply took the "field numbers" tab of the smfgetyahooportfoli
If I plug in "F" for the ticker, all of the cells in that column return the correct data. If I change the ticker to "TSLA" all of the cells return "--"
(see attached)
Attachment(s) from
2 of 2 Photo(s)
Thu Jul 26, 2018 12:33 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you -- I used this formula:
=TRANSPOSE(smfGetYahooPortfolioView("TSLA";,B3:B94,,,1,100))
....and TSLA works fine for me:
*Field #* *Field Description* *Yahoo field name* *Values*
00 N/A N/A --
01 Symbol symbol TSLA
02 Long Name longName Tesla, Inc.
03 Short Name shortName Tesla, Inc.
04 Exchange exchange NMS
05 Full Exchange Name fullExchangeName NasdaqGS
06 Market market us_market
07 Market State marketState PREPRE
08 Source Interval sourceInterval 15
09 Exchange Timezone Name exchangeTimezoneName America/New_York
10 Exchange Timezone Short Name exchangeTimezoneShortName EDT
11 GMT Offset Milliseconds gmtOffSetMilliseconds -14400000
12 Language language en-US
13 Quote Type quoteType EQUITY
14 Quote Source Name quoteSourceName Nasdaq Real Time Price
15 Last Price regularMarketPrice 308.74
16 Last Traded (UNIX) regularMarketTime 1532548801
17 Change regularMarketChange 11.309998
18 Open regularMarketOpen 296.74
19 High regularMarketDayHigh 309.62
20 Low regularMarketDayLow 294.5025
21 Volume regularMarketVolume 6913824
On Wed, Jul 25, 2018 at 9:36 AM, peterscottcook@
...
wrote:
>
> I'm not sure if this is the same issue, but there are many stocks for
> which smfgetyahooportfolioview() pulls data and there are many for which it
> doesn't.
>
> I simply took the "field numbers" tab of the smfgetyahooportfolioview-sample.xls
> sheet and added a ticker field plus a column which returns the function's
> value using the ticker and the field number for that row.
>
> If I plug in "F" for the ticker, all of the cells in that column return
> the correct data. If I change the ticker to "TSLA" all of the cells return
> "--".
>
>
>
=TRANSPOSE(smfGetYa
....and TSLA works fine for me:
*Field #* *Field Description* *Yahoo field name* *Values*
00 N/A N/A --
01 Symbol symbol TSLA
02 Long Name longName Tesla, Inc.
03 Short Name shortName Tesla, Inc.
04 Exchange exchange NMS
05 Full Exchange Name fullExchangeName NasdaqGS
06 Market market us_market
07 Market State marketState PREPRE
08 Source Interval sourceInterval 15
09 Exchange Timezone Name exchangeTimezoneNam
10 Exchange Timezone Short Name exchangeTimezoneSho
11 GMT Offset Milliseconds gmtOffSetMillisecon
12 Language language en-US
13 Quote Type quoteType EQUITY
14 Quote Source Name quoteSourceName Nasdaq Real Time Price
15 Last Price regularMarketPrice 308.74
16 Last Traded (UNIX) regularMarketTime 1532548801
17 Change regularMarketChange 11.309998
18 Open regularMarketOpen 296.74
19 High regularMarketDayHig
20 Low regularMarketDayLow 294.5025
21 Volume regularMarketVolume 6913824
On Wed, Jul 25, 2018 at 9:36 AM, peterscottcook@
...
wrote:
>
> I'm not sure if this is the same issue, but there are many stocks for
> which smfgetyahooportfoli
> doesn't.
>
> I simply took the "field numbers" tab of the smfgetyahooportfoli
> sheet and added a ticker field plus a column which returns the function'
> value using the ticker and the field number for that row.
>
> If I plug in "F" for the ticker, all of the cells in that column return
> the correct data. If I change the ticker to "TSLA" all of the cells return
> "--"
>
>
>
Thu Jul 26, 2018 4:13 am (PDT) . Posted by:
stan_12@ymail.com
Hello everyone,
has anyone an idea how to get this site into Excel?
https://www.zacks.com/stock/research/FB/key-company-metrics
My aim is to change the symbol in Excel and then pull the data dynamically.
I tried:
1.) "csv-download"
But it is rather an xls Download with non standard tab names. So difficult to refer to.
2.) SMF Quick Webpage Examination by html Tag
But i could find a suitable tag.
Best Regards ... Stan
has anyone an idea how to get this site into Excel?
https://www.zacks.com/stock/research/FB/key-company-metrics
My aim is to change the symbol in Excel and then pull the data dynamically.
I tried:
1.) "csv-download&
But it is rather an xls Download with non standard tab names. So difficult to refer to.
2.) SMF Quick Webpage Examination by html Tag
But i could find a suitable tag.
Best Regards ... Stan
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar