12 Messages
Digest #4526
Messages
Tue Apr 23, 2019 10:24 am (PDT) . Posted by:
bihi_selow
There is a way to work around this issue using
=RCHGetElementNumber(B7,4924)
where B7 is the stock symbol.
you'll need to create a new column outside the array to get this to work.
;-)
=RCHGetElementNumbe
where B7 is the stock symbol.
you'll need to create a new column outside the array to get this to work.
;-)
Tue Apr 23, 2019 11:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not a good solution, as you need to do a web page retrieval for each one.
A better solution is the one mentioned on another thread -- just change the
ranged array-entered formula to grab a different dividend field. Either the
forward one or trailing one. Both are still available. That is, from field
#33 to #36 or #38...? Then, everything is still grabbed with one Internet
access. Much faster.
On Tue, Apr 23, 2019 at 10:25 AM bhui_ipsg@... wrote:
>
> There is a way to work around this issue using
>
> =RCHGetElementNumber(B7,4924)
>
> where B7 is the stock symbol.
>
> you'll need to create a new column outside the array to get this to work.
>
> ;-)
>
>
>
A better solution is the one mentioned on another thread -- just change the
ranged array-entered formula to grab a different dividend field. Either the
forward one or trailing one. Both are still available. That is, from field
#33 to #36 or #38...? Then, everything is still grabbed with one Internet
access. Much faster.
On Tue, Apr 23, 2019 at 10:25 AM bhui_ipsg@..
>
> There is a way to work around this issue using
>
> =RCHGetElementNumbe
>
> where B7 is the stock symbol.
>
> you'll need to create a new column outside the array to get this to work.
>
> ;-)
>
>
>
Tue Apr 23, 2019 12:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure the best way. I've not had to try it, as I usually don't do many
ticker symbols.
But if you have the array up and working for some ticker symbols within the
request, maybe just blank out the tickers that are returning data? It
should recalculate, leaving those lines empty of data. Then repeat.
You may get to a point where a set of tickers is returning nothing. At that
point, it may be trial and error to find the culprit? Maybe sort them in a
different order?
On Tue, Apr 23, 2019 at 12:03 PM weldencd@... wrote:
>
> What's the best way to troubleshoot it?
>
>
>
ticker symbols.
But if you have the array up and working for some ticker symbols within the
request, maybe just blank out the tickers that are returning data? It
should recalculate, leaving those lines empty of data. Then repeat.
You may get to a point where a set of tickers is returning nothing. At that
point, it may be trial and error to find the culprit? Maybe sort them in a
different order?
On Tue, Apr 23, 2019 at 12:03 PM weldencd@... wrote:
>
> What's the best way to troubleshoot it?
>
>
>
Tue Apr 23, 2019 12:30 pm (PDT) . Posted by:
weldenc
I just tried a few things to fix it. No luck so far.
I tried making a copy of the worksheet tab that grabs the yahoo data (I'll call it "copy"). I deleted all the stock symbols in "copy". I went to the original yahoo data tab (call it "original"; )and copied the last 10 symbols to "copy". The stock data populated as expected. I skipped a line in "copy" and pasted the same 10 symbols again. No data was returned. I went to the 1st row in "copy" and deleted the symbol there. Immediately, the 1st symbol in the second group returned data.
I tried the same operation (after deleting all stock symbols in "copy") except this time I used the 1st 10 symbols in "original";. I got the same behavior.
I'm also wondering why the symbol IBM works in the "original"; tab AFTER line 180 when no other symbol seems to work.
I tried making a copy of the worksheet tab that grabs the yahoo data (I'll call it "copy"
I tried the same operation (after deleting all stock symbols in "copy"
I'm also wondering why the symbol IBM works in the "original"
Tue Apr 23, 2019 1:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When you say "no data was returned" when you pasted the same 10 ticker
symbols, do you mean no data at all, or just do data for the repeated
ticker symbols? I ask because the function only returns to the first
occurrence of a ticker symbol unless you specify via a parameter that you
want all of them to be filled.
So you have a workbook with just the function invocation and the list of
ticker symbols? If so, you could attach it and I could take a look at it. I
don't want a workbook that will take a long time to calculate. But with
just that one function invocation, the response time should be immediate.
On Tue, Apr 23, 2019 at 12:30 PM weldencd@... wrote:
>
> I just tried a few things to fix it. No luck so far.
>
> I tried making a copy of the worksheet tab that grabs the yahoo data (I'll
> call it "copy"). I deleted all the stock symbols in "copy". I went to the
> original yahoo data tab (call it "original"; )and copied the last 10 symbols
> to "copy". The stock data populated as expected. I skipped a line in "copy"
> and pasted the same 10 symbols again. No data was returned. I went to the
> 1st row in "copy" and deleted the symbol there. Immediately, the 1st symbol
> in the second group returned data.
>
> I tried the same operation (after deleting all stock symbols in "copy")
> except this time I used the 1st 10 symbols in "original";. I got the same
> behavior.
>
> I'm also wondering why the symbol IBM works in the "original"; tab AFTER
> line 180 when no other symbol seems to work.
>
>
>
symbols, do you mean no data at all, or just do data for the repeated
ticker symbols? I ask because the function only returns to the first
occurrence of a ticker symbol unless you specify via a parameter that you
want all of them to be filled.
So you have a workbook with just the function invocation and the list of
ticker symbols? If so, you could attach it and I could take a look at it. I
don't want a workbook that will take a long time to calculate. But with
just that one function invocation, the response time should be immediate.
On Tue, Apr 23, 2019 at 12:30 PM weldencd@... wrote:
>
> I just tried a few things to fix it. No luck so far.
>
> I tried making a copy of the worksheet tab that grabs the yahoo data (I'll
> call it "copy"
> original yahoo data tab (call it "original"
> to "copy"
> and pasted the same 10 symbols again. No data was returned. I went to the
> 1st row in "copy" and deleted the symbol there. Immediately, the 1st symbol
> in the second group returned data.
>
> I tried the same operation (after deleting all stock symbols in "copy"
> except this time I used the 1st 10 symbols in "original"
> behavior.
>
> I'm also wondering why the symbol IBM works in the "original"
> line 180 when no other symbol seems to work.
>
>
>
Tue Apr 23, 2019 3:39 pm (PDT) . Posted by:
weldenc
I think the easiest solution right now is to include a new tab with a second worksheet to return stock data I tried it and it seemed to work. Is there any reason that this might give me problems?
Tue Apr 23, 2019 4:09 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Impossible to say. It all depends on what is causing the problem...
On Tue, Apr 23, 2019 at 3:39 PM weldencd@... wrote:
>
> I think the easiest solution right now is to include a new tab with a
> second worksheet to return stock data I tried it and it seemed to work.. Is
> there any reason that this might give me problems?
>
>
>
On Tue, Apr 23, 2019 at 3:39 PM weldencd@... wrote:
>
> I think the easiest solution right now is to include a new tab with a
> second worksheet to return stock data I tried it and it seemed to work.. Is
> there any reason that this might give me problems?
>
>
>
Tue Apr 23, 2019 8:00 pm (PDT) . Posted by:
"Joseph G. Keithley, III" joekeithley@verizon.net
Hi, Randy
I am a little confused on the Data Items options for the
RCHGetYahooHistory function. Both code "A" and code "C" return the same
value, at least for the two stocks I checked. When I checked a few
points against Yahoo Historical Quotes directly the value returned was
the adjusted close. On a lark I tried using code "U" and found that I
would get values that matched the unadjusted closing price (as per the
Yahoo Historical Quotes page). Shouldn't code "U" be listed as one of
the Data Items?
Thanks for all your hard work. My financial life would definitely
be more troublesome without it.
Joe
I am a little confused on the Data Items options for the
RCHGetYahooHistory function. Both code "A" and code "C" return the same
value, at least for the two stocks I checked. When I checked a few
points against Yahoo Historical Quotes directly the value returned was
the adjusted close. On a lark I tried using code "U" and found that I
would get values that matched the unadjusted closing price (as per the
Yahoo Historical Quotes page). Shouldn'
the Data Items?
Thanks for all your hard work. My financial life would definitely
be more troublesome without it.
Joe
Tue Apr 23, 2019 10:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmm. That documentation was never updated when the function was replaced.
For most intents and purposes, that function is now obsolete, replaced with
the smfGetYahooHistory() function.
On Tue, Apr 23, 2019 at 8:00 PM 'Joseph G. Keithley, III' jgkiii@.... wrote:
>
> I am a little confused on the Data Items options for the
> RCHGetYahooHistory function. Both code "A" and code "C" return the same
> value, at least for the two stocks I checked. When I checked a few
> points against Yahoo Historical Quotes directly the value returned was
> the adjusted close. On a lark I tried using code "U" and found that I
> would get values that matched the unadjusted closing price (as per the
> Yahoo Historical Quotes page). Shouldn't code "U" be listed as one of
> the Data Items?
>
> Thanks for all your hard work. My financial life would definitely
> be more troublesome without it.
>
>
>
For most intents and purposes, that function is now obsolete, replaced with
the smfGetYahooHistory(
On Tue, Apr 23, 2019 at 8:00 PM 'Joseph G. Keithley, III' jgkiii@.... wrote:
>
> I am a little confused on the Data Items options for the
> RCHGetYahooHistory function. Both code "A" and code "C" return the same
> value, at least for the two stocks I checked. When I checked a few
> points against Yahoo Historical Quotes directly the value returned was
> the adjusted close. On a lark I tried using code "U" and found that I
> would get values that matched the unadjusted closing price (as per the
> Yahoo Historical Quotes page). Shouldn'
> the Data Items?
>
> Thanks for all your hard work. My financial life would definitely
> be more troublesome without it.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar