15 Messages
Digest #3982
Messages
Mon Apr 24, 2017 8:14 pm (PDT) . Posted by:
w_pellerin
As of today, the RCHGetYahooHistory function is not working for me.
I updated to the latest release last week, and things were working fine, until this morning.
Any ideas as to what is wrong?
I updated to the latest release last week, and things were working fine, until this morning.
Any ideas as to what is wrong?
Mon Apr 24, 2017 8:18 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
What formula are you using? I just tried MMM from scratch, and both IBM and
MMM with the template from the web site, and all appeared to work fine.
On Mon, Apr 24, 2017 at 7:53 PM, william.r.pellerin@
...wrote:
>
> As of today, the RCHGetYahooHistory function is not working for me.
>
>
>
> I updated to the latest release last week, and things were working fine,
> until this morning.
>
> Any ideas as to what is wrong?
>
MMM with the template from the web site, and all appeared to work fine.
On Mon, Apr 24, 2017 at 7:53 PM, william.r.pellerin@
...wrote:
>
> As of today, the RCHGetYahooHistory function is not working for me.
>
>
>
> I updated to the latest release last week, and things were working fine,
> until this morning.
>
> Any ideas as to what is wrong?
>
Mon Apr 24, 2017 8:20 pm (PDT) . Posted by:
w_pellerin
=rchGetYahooHistory(C2,YEAR(B2),MONTH(B2),DAY(B2),YEAR(A2),MONTH(A2),DAY(A2),"d","DOHLCVA",1,1,0)
B2=
5/25/2015
A2=
4/24/2017
C2=USLV
B2=
5/25/2015
A2=
4/24/2017
C2=USLV
Mon Apr 24, 2017 8:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Seems to work fine here...are you sure you're using the current version?
=RCHGetElementNumber("Version")
On Mon, Apr 24, 2017 at 8:20 PM, william.r.pellerin@
...wrote:
>
> =rchGetYahooHistory(C2,YEAR(B2),MONTH(B2),DAY(B2),YEAR(A2)
> ,MONTH(A2),DAY(A2),"d","DOHLCVA",1,1,0)
>
> B2=
> 5/25/2015
>
> A2=
> 4/24/2017
> C2=USLV
>
>
=RCHGetElementNumbe
On Mon, Apr 24, 2017 at 8:20 PM, william.r.pellerin@
...wrote:
>
> =rchGetYahooHistory
> ,MONTH(A2),DAY(
>
> B2=
> 5/25/2015
>
> A2=
> 4/24/2017
> C2=USLV
>
>
Mon Apr 24, 2017 8:49 pm (PDT) . Posted by:
w_pellerin
Stock Market Functions add-in, Version 2.1.2017.04.17 (P:\Dropbox\SMF Add-In for Excel; Windows (32-bit) NT 10.00; 16.0; ; ; 1)
Mon Apr 24, 2017 9:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
How long have you had the add-in located on DropBox?
Have you tried this in a new worksheet?
=RCHGetYahooHistory("MMM")
Does the "Download Data" button here work?
http://finance.yahoo.com/quote/MMM/history
What do you get with:
=RCHGetWebData("
https://chart.finance.yahoo.com/table.csv?s=MMM&a=2&b=24&c=2017&d=3&e=24&f=2017&g=d&ignore=.csv
",,30)
On Mon, Apr 24, 2017 at 8:49 PM, william.r.pellerin@
...wrote:
>
> Stock Market Functions add-in, Version 2.1.2017.04.17 (P:\Dropbox\SMF
> Add-In for Excel; Windows (32-bit) NT 10.00; 16.0; ; ; 1)
>
>
Have you tried this in a new worksheet?
=RCHGetYahooHistory("MMM")
Does the "Download Data" button here work?
http://finance.yahoo.com/quote/MMM/history
What do you get with:
=RCHGetWebData("
https://chart.finance.yahoo.com/table.csv?s=MMM&a=2&b=24&c=2017&d=3&e=24&f=2017&g=d&ignore=.csv
",,30)
On Mon, Apr 24, 2017 at 8:49 PM, william.r.pellerin@
...wrote:
>
> Stock Market Functions add-in, Version 2.1.2017.04.
> Add-In for Excel; Windows (32-bit) NT 10.00; 16.0; ; ; 1)
>
>
Mon Apr 24, 2017 10:18 pm (PDT) . Posted by:
w_pellerin
Ok, fixed it.
With the new version, I moved the smf directory. This broke the array formula.
I had to reenter the array formula.
Thanks for verifying things on your side.
Bill
With the new version, I moved the smf directory. This broke the array formula.
I had to reenter the array formula.
Thanks for verifying things on your side.
Bill
Tue Apr 25, 2017 5:54 am (PDT) . Posted by:
DefelRadar
I have been battling issues with both RCHGetYahooHistory and RCHGetElementNumber formulas. There are times that it appears both RCHGetYahooHistory and RCHGetElementNumber formulas work for me and then when I enter in a new stock that I know has data out there on like MMM everything comes up #VALUE!.
I probably use at least 100 RCHGetElementNumber formulas on one sheet and most center around yahoo, a handful are Zacks, BarCharts and Pio F score data elements that also show #VALUE! so I can't entirely say it is an issue with yahoo.
I have installed the latest SMF add-in dated 4/17/17. Initially when I installed it all my formulas worked on all my sheets and data came in beautifully. But as I changed stock symbols little by little the formulas broke again. I am using Excel 2010.
Thanks!
I probably use at least 100 RCHGetElementNumber formulas on one sheet and most center around yahoo, a handful are Zacks, BarCharts and Pio F score data elements that also show #VALUE! so I can't entirely say it is an issue with yahoo.
I have installed the latest SMF add-in dated 4/17/17. Initially when I installed it all my formulas worked on all my sheets and data came in beautifully. But as I changed stock symbols little by little the formulas broke again. I am using Excel 2010.
Thanks!
Tue Apr 25, 2017 8:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's strange, because the add-in formulas don't typically return #VALUE!
errors. When I get them, it's almost always because I entered my parameters
incorrectly, such as a string when an integer should be entered. But that
shouldn't apply if all you are doing is changing ticker symbols.
However, without specific examples, I have nothing to investigate...
On Tue, Apr 25, 2017 at 5:54 AM, defelradar@
...wrote:
> I have been battling issues with both RCHGetYahooHistory and
> RCHGetElementNumber formulas. There are times that it appears both
> RCHGetYahooHistory and RCHGetElementNumber formulas work for me and then
> when I enter in a new stock that I know has data out there on like MMM
> everything comes up #VALUE!.
>
> I probably use at least 100 RCHGetElementNumber formulas on one sheet and
> most center around yahoo, a handful are Zacks, BarCharts and Pio F score
> data elements that also show #VALUE! so I can't entirely say it is an issue
> with yahoo.
>
> I have installed the latest SMF add-in dated 4/17/17. Initially when I
> installed it all my formulas worked on all my sheets and data came in
> beautifully. But as I changed stock symbols little by little the formulas
> broke again. I am using Excel 2010.
>
>
>
>
errors. When I get them, it's almost always because I entered my parameters
incorrectly, such as a string when an integer should be entered. But that
shouldn'
However, without specific examples, I have nothing to investigate.
On Tue, Apr 25, 2017 at 5:54 AM, defelradar@
...wrote:
> I have been battling issues with both RCHGetYahooHistory and
> RCHGetElementNumber formulas. There are times that it appears both
> RCHGetYahooHistory and RCHGetElementNumber formulas work for me and then
> when I enter in a new stock that I know has data out there on like MMM
> everything comes up #VALUE!.
>
> I probably use at least 100 RCHGetElementNumber formulas on one sheet and
> most center around yahoo, a handful are Zacks, BarCharts and Pio F score
> data elements that also show #VALUE! so I can't entirely say it is an issue
> with yahoo.
>
> I have installed the latest SMF add-in dated 4/17/17. Initially when I
> installed it all my formulas worked on all my sheets and data came in
> beautifully. But as I changed stock symbols little by little the formulas
> broke again. I am using Excel 2010.
>
>
>
>
Tue Apr 25, 2017 11:11 am (PDT) . Posted by:
gobi5
Hi, A few days ago I noticed YahooKS elements breaking in my spreadsheet. Specifically RCHGetElementNumber 957, 989, 4924
I'm seeing some threads about Yahoo elements breaking but not seeing workarounds for these. Any ideas?
I'm seeing some threads about Yahoo elements breaking but not seeing workarounds for these. Any ideas?
Tue Apr 25, 2017 11:42 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried all three of those elements with ticker MMM, and they returned
data. Give me a few examples of those not working?
On Tue, Apr 25, 2017 at 11:11 AM, cmaxmagee@
...wrote:
> Hi, A few days ago I noticed YahooKS elements breaking in my spreadsheet.
> Specifically RCHGetElementNumber 957, 989, 4924
>
> I'm seeing some threads about Yahoo elements breaking but not seeing
> workarounds for these. Any ideas?
>
>
data. Give me a few examples of those not working?
On Tue, Apr 25, 2017 at 11:11 AM, cmaxmagee@
...wrote:
> Hi, A few days ago I noticed YahooKS elements breaking in my spreadsheet.
> Specifically RCHGetElementNumber 957, 989, 4924
>
> I'm seeing some threads about Yahoo elements breaking but not seeing
> workarounds for these. Any ideas?
>
>
Tue Apr 25, 2017 11:53 am (PDT) . Posted by:
gobi5
Here are some of the tickers I have:
HP
CNA
PRU
TSLA
CEMP
TTPH
PTLA
AKAO
DATA
CALA
RUN
It's strange though. If I type MMM it works and other tickers work as well. Just none of the tickers that are saved in this file. I've tried recalculating the worksheet as well.
HP
CNA
PRU
TSLA
CEMP
TTPH
PTLA
AKAO
DATA
CALA
RUN
It's strange though. If I type MMM it works and other tickers work as well. Just none of the tickers that are saved in this file. I've tried recalculating the worksheet as well.
Tue Apr 25, 2017 12:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
All of those are working for me:
# 957 989 4924
Element Revenue Per Share Dividend Forward Annual Dividend Rate
MMM 49.79 4.44 4.7
HP 13.92 2.79 2.8
CNA 34.64 1 1
PRU 137.51 2.8 3
TSLA 48.54 N/A N/A
CEMP 0.36 N/A N/A
TTPH 0.14 N/A N/A
PTLA 0.63 N/A N/A
AKAO 1.76 N/A N/A
DATA 11 N/A N/A
CALA N/A N/A N/A
RUN 4.43 N/A N/A
On Tue, Apr 25, 2017 at 11:53 AM, cmaxmagee@
...wrote:
>
> Here are some of the tickers I have:
>
> HP
> CNA
> PRU
> TSLA
> CEMP
> TTPH
> PTLA
> AKAO
> DATA
> CALA
> RUN
>
> It's strange though. If I type MMM it works and other tickers work as
> well. Just none of the tickers that are saved in this file. I've tried
> recalculating the worksheet as well.
>
>
# 957 989 4924
Element Revenue Per Share Dividend Forward Annual Dividend Rate
MMM 49.79 4.44 4.7
HP 13.92 2.79 2.8
CNA 34.64 1 1
PRU 137.51 2.8 3
TSLA 48.54 N/A N/A
CEMP 0.36 N/A N/A
TTPH 0.14 N/A N/A
PTLA 0.63 N/A N/A
AKAO 1.76 N/A N/A
DATA 11 N/A N/A
CALA N/A N/A N/A
RUN 4.43 N/A N/A
On Tue, Apr 25, 2017 at 11:53 AM, cmaxmagee@
...wrote:
>
> Here are some of the tickers I have:
>
> HP
> CNA
> PRU
> TSLA
> CEMP
> TTPH
> PTLA
> AKAO
> DATA
> CALA
> RUN
>
> It's strange though. If I type MMM it works and other tickers work as
> well. Just none of the tickers that are saved in this file. I've tried
> recalculating the worksheet as well.
>
>
Tue Apr 25, 2017 12:32 pm (PDT) . Posted by:
gobi5
It seems like maybe Excel is caching an Error value for those tickers for me? Even if I use them in a new file I get errors. Any idea why that might be happening and how to fix?
Tue Apr 25, 2017 1:01 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try running smfForceRecalculation (or exiting and restarting EXCEL). If the
add-in has saved pages that are causing you errors, a new sheet won't make
a difference. You'd need to have the add-in purge its saved web pages.
Now, if the Microsoft software behind the scenes is caching the web pages,
you'd have to fix your Internet Options to always get new content. However,
on Win10, I haven't been able to set that option...
On Tue, Apr 25, 2017 at 12:32 PM, cmaxmagee@
...wrote:
>
> It seems like maybe Excel is caching an Error value for those tickers for
> me? Even if I use them in a new file I get errors. Any idea why that might
> be happening and how to fix?
>
add-in has saved pages that are causing you errors, a new sheet won't make
a difference. You'd need to have the add-in purge its saved web pages.
Now, if the Microsoft software behind the scenes is caching the web pages,
you'd have to fix your Internet Options to always get new content. However,
on Win10, I haven't been able to set that option...
On Tue, Apr 25, 2017 at 12:32 PM, cmaxmagee@
...wrote:
>
> It seems like maybe Excel is caching an Error value for those tickers for
> me? Even if I use them in a new file I get errors. Any idea why that might
> be happening and how to fix?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar