10 New Messages
Digest #2677
4b
Re: Installation problem : Win 7 Excel 2007 64 bit please help [2 At by "Randy Harmelink" rharmelink
Messages
Sat Jun 29, 2013 8:52 am (PDT) . Posted by:
"graeb2" graeb2
I would like to automate the retrieval of Price, TTM Earnings, and Dividend into a spreadsheet that I manually update with Value Line data.
I have downloaded and successfully tested the Add-Ins.
Not being an expert on Excel, I can say that I use the Lists function. That seems to cause trouble with entering formulas.
Also, the list is in excess of 200 securities and Yahoo rejected a request for 200 quotes.
Any suggestions on how to go about this. By the way, I am very weak on using ranges. When I've tried, it seems impossible to modify a sheet further. I need to be able to add and remove securities.
Tks
I have downloaded and successfully tested the Add-Ins.
Not being an expert on Excel, I can say that I use the Lists function. That seems to cause trouble with entering formulas.
Also, the list is in excess of 200 securities and Yahoo rejected a request for 200 quotes.
Any suggestions on how to go about this. By the way, I am very weak on using ranges. When I've tried, it seems impossible to modify a sheet further. I need to be able to add and remove securities.
Tks
Sat Jun 29, 2013 1:18 pm (PDT) . Posted by:
"grahamstan82" grahamstan82
Hi
I am having the same problem - different values returned from the function than are shown in the yahoo.history function return. I am trying to return the highest/lowest prices in a 5-day week, to use to calculate the std_dev on a weekly basis.
Anybody help, please.
Stan
--- In smf_addin@yahoogroups.com , "lexstar" <lexstar@...> wrote:
>
> Why is it that sometimes smfPricesBetween() will give you a different price than what's reported on Yahoo.
>
> For example yesterday's close (June 26) for LGOAX using smfPricesBetween("LGOAX";,06/03/2013,06/26/2013,"08") give a value of 13.74, but yet on Yahoo Finance, it's 13.16.
>
> Anyone care to enlighten me on this? (It doesn't happened to every ticker, just some here and there).
>
> Thanks.
>
I am having the same problem - different values returned from the function than are shown in the yahoo.history function return. I am trying to return the highest/lowest prices in a 5-day week, to use to calculate the std_dev on a weekly basis.
Anybody help, please.
Stan
--- In smf_addin@yahoogrou
>
> Why is it that sometimes smfPricesBetween(
>
> For example yesterday'
>
> Anyone care to enlighten me on this? (It doesn't happened to every ticker, just some here and there).
>
> Thanks.
>
Sat Jun 29, 2013 1:19 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Examples?
On Sat, Jun 29, 2013 at 1:10 PM, grahamstan82 <asahi1931@hotmail.com > wrote:
> Hi
> I am having the same problem - different values returned from the function
> than are shown in the yahoo.history function return. I am trying to return
> the highest/lowest prices in a 5-day week, to use to calculate the std_dev
> on a weekly basis.
> Anybody help, please.
> Stan
>
On Sat, Jun 29, 2013 at 1:10 PM, grahamstan82 <asahi1931@hotmail.
> Hi
> I am having the same problem - different values returned from the function
> than are shown in the yahoo.history function return. I am trying to return
> the highest/lowest prices in a 5-day week, to use to calculate the std_dev
> on a weekly basis.
> Anybody help, please.
> Stan
>
Sat Jun 29, 2013 1:45 pm (PDT) . Posted by:
"grahamstan82" grahamstan82
Hi...examples.
Date Open High Low
28-Jun-13 160.63 161.4 159.86
27-Jun-13 161.1 161.82 160.95
26-Jun-13 159.87 160.5 159.25
25-Jun-13 158.48 160.1 157.42
24-Jun-13 157.41 158.43 155.73
21-Jun-13 159.64 159.76 157.47
20-Jun-13 161.86 163.47 158.98
19-Jun-13 165.6 165.89 163.38
18-Jun-13 164.53 165.99 164.52
17-Jun-13 164.29 165.22 163.22
14-Jun-13 164.03 164.67 162.91
13-Jun-13 161.66 164.5 161.3
12-Jun-13 164.22 164.39 161.6
11-Jun-13 163.3 164.54 162.74
10-Jun-13 165.31 165.4 164.37
7-Jun-13 163.85 164.95 163.14
This (above)is using History return.
--------------
This is using the smfhighbetween().
28-Jun-13 161.82 155.73
21-Jun-13 165.12 157.47
14-Jun-13 164.53 160.46
7-Jun-13 164.23 159.40
31-May-13 166.89 162.27
24-May-13 168.18 163.08
17-May-13 166.16 161.96
This is comparing the returns for high:
28 Jun 161.4 v 161.82
21 Jun 165.99 v 165.12
14 Jun 164.53 v 164.67
etc.
Hope that helps.Stan
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Examples?
>
> On Sat, Jun 29, 2013 at 1:10 PM, grahamstan82 <asahi1931@...> wrote:
>
> > Hi
> > I am having the same problem - different values returned from the function
> > than are shown in the yahoo.history function return. I am trying to return
> > the highest/lowest prices in a 5-day week, to use to calculate the std_dev
> > on a weekly basis.
> > Anybody help, please.
> > Stan
> >
>
Date Open High Low
28-Jun-13 160.63 161.4 159.86
27-Jun-13 161.1 161.82 160.95
26-Jun-13 159.87 160.5 159.25
25-Jun-13 158.48 160.1 157.42
24-Jun-13 157.41 158.43 155.73
21-Jun-13 159.64 159.76 157.47
20-Jun-13 161.86 163.47 158.98
19-Jun-13 165.6 165.89 163.38
18-Jun-13 164.53 165.99 164.52
17-Jun-13 164.29 165.22 163.22
14-Jun-13 164.03 164.67 162.91
13-Jun-13 161.66 164.5 161.3
12-Jun-13 164.22 164.39 161.6
11-Jun-13 163.3 164.54 162.74
10-Jun-13 165.31 165.4 164.37
7-Jun-13 163.85 164.95 163.14
This (above)is using History return.
------------
This is using the smfhighbetween(
28-Jun-13 161.82 155.73
21-Jun-13 165.12 157.47
14-Jun-13 164.53 160.46
7-Jun-13 164.23 159.40
31-May-13 166.89 162.27
24-May-13 168.18 163.08
17-May-13 166.16 161.96
This is comparing the returns for high:
28 Jun 161.4 v 161.82
21 Jun 165.99 v 165.12
14 Jun 164.53 v 164.67
etc.
Hope that helps.Stan
--- In smf_addin@yahoogrou
>
> Examples?
>
> On Sat, Jun 29, 2013 at 1:10 PM, grahamstan82 <asahi1931@
>
> > Hi
> > I am having the same problem - different values returned from the function
> > than are shown in the yahoo.history function return. I am trying to return
> > the highest/lowest prices in a 5-day week, to use to calculate the std_dev
> > on a weekly basis.
> > Anybody help, please.
> > Stan
> >
>
Sat Jun 29, 2013 1:53 pm (PDT) . Posted by:
"grahamstan82" grahamstan82
Here is the entry I used:
=SMFHighBetween($B$1,K8-5,K8)
were K8 is the date: 28-Jun-13
and B1 is SPY
K8 - 5 is 23-Jun-13.
Stan
--- In smf_addin@yahoogroups.com , "grahamstan82" <asahi1931@...> wrote:
>
> Hi...examples.
> Date Open High Low
> 28-Jun-13 160.63 161.4 159.86
> 27-Jun-13 161.1 161.82 160.95
> 26-Jun-13 159.87 160.5 159.25
> 25-Jun-13 158.48 160.1 157.42
> 24-Jun-13 157.41 158.43 155.73
> 21-Jun-13 159.64 159.76 157.47
> 20-Jun-13 161.86 163.47 158.98
> 19-Jun-13 165.6 165.89 163.38
> 18-Jun-13 164.53 165.99 164.52
> 17-Jun-13 164.29 165.22 163.22
> 14-Jun-13 164.03 164.67 162.91
> 13-Jun-13 161.66 164.5 161.3
> 12-Jun-13 164.22 164.39 161.6
> 11-Jun-13 163.3 164.54 162.74
> 10-Jun-13 165.31 165.4 164.37
> 7-Jun-13 163.85 164.95 163.14
> This (above)is using History return.
> --------------
> This is using the smfhighbetween().
> 28-Jun-13 161.82 155.73
> 21-Jun-13 165.12 157.47
> 14-Jun-13 164.53 160.46
> 7-Jun-13 164.23 159.40
> 31-May-13 166.89 162.27
> 24-May-13 168.18 163.08
> 17-May-13 166.16 161.96
>
> This is comparing the returns for high:
> 28 Jun 161.4 v 161.82
> 21 Jun 165.99 v 165.12
> 14 Jun 164.53 v 164.67
> etc.
> Hope that helps.Stan
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Examples?
> >
> > On Sat, Jun 29, 2013 at 1:10 PM, grahamstan82 <asahi1931@> wrote:
> >
> > > Hi
> > > I am having the same problem - different values returned from the function
> > > than are shown in the yahoo.history function return. I am trying to return
> > > the highest/lowest prices in a 5-day week, to use to calculate the std_dev
> > > on a weekly basis.
> > > Anybody help, please.
> > > Stan
> > >
> >
>
=SMFHighBetween(
were K8 is the date: 28-Jun-13
and B1 is SPY
K8 - 5 is 23-Jun-13.
Stan
--- In smf_addin@yahoogrou
>
> Hi...examples.
> Date Open High Low
> 28-Jun-13 160.63 161.4 159.86
> 27-Jun-13 161.1 161.82 160.95
> 26-Jun-13 159.87 160.5 159.25
> 25-Jun-13 158.48 160.1 157.42
> 24-Jun-13 157.41 158.43 155.73
> 21-Jun-13 159.64 159.76 157.47
> 20-Jun-13 161.86 163.47 158.98
> 19-Jun-13 165.6 165.89 163.38
> 18-Jun-13 164.53 165.99 164.52
> 17-Jun-13 164.29 165.22 163.22
> 14-Jun-13 164.03 164.67 162.91
> 13-Jun-13 161.66 164.5 161.3
> 12-Jun-13 164.22 164.39 161.6
> 11-Jun-13 163.3 164.54 162.74
> 10-Jun-13 165.31 165.4 164.37
> 7-Jun-13 163.85 164.95 163.14
> This (above)is using History return.
> ------------
> This is using the smfhighbetween(
> 28-Jun-13 161.82 155.73
> 21-Jun-13 165.12 157.47
> 14-Jun-13 164.53 160.46
> 7-Jun-13 164.23 159.40
> 31-May-13 166.89 162.27
> 24-May-13 168.18 163.08
> 17-May-13 166.16 161.96
>
> This is comparing the returns for high:
> 28 Jun 161.4 v 161.82
> 21 Jun 165.99 v 165.12
> 14 Jun 164.53 v 164.67
> etc.
> Hope that helps.Stan
>
> --- In smf_addin@yahoogrou
> >
> > Examples?
> >
> > On Sat, Jun 29, 2013 at 1:10 PM, grahamstan82 <asahi1931@
> >
> > > Hi
> > > I am having the same problem - different values returned from the function
> > > than are shown in the yahoo.history function return. I am trying to return
> > > the highest/lowest prices in a 5-day week, to use to calculate the std_dev
> > > on a weekly basis.
> > > Anybody help, please.
> > > Stan
> > >
> >
>
Sat Jun 29, 2013 2:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The problem is that the historical quotes you cite below are unadjusted.
smfHighBetween() uses quotes adjusted for dividends.
SPY went ex-dividend on June 21st.
On Sat, Jun 29, 2013 at 1:45 PM, grahamstan82 <asahi1931@hotmail.com > wrote:
> Hi...examples.
> Date Open High Low
> 28-Jun-13 160.63 161.4 159.86
> 27-Jun-13 161.1 161.82 160.95
> 26-Jun-13 159.87 160.5 159.25
> 25-Jun-13 158.48 160.1 157.42
> 24-Jun-13 157.41 158.43 155.73
> 21-Jun-13 159.64 159.76 157.47
> 20-Jun-13 161.86 163.47 158.98
> 19-Jun-13 165.6 165.89 163.38
> 18-Jun-13 164.53 165.99 164.52
> 17-Jun-13 164.29 165.22 163.22
> 14-Jun-13 164.03 164.67 162.91
> 13-Jun-13 161.66 164.5 161.3
> 12-Jun-13 164.22 164.39 161.6
> 11-Jun-13 163.3 164.54 162.74
> 10-Jun-13 165.31 165.4 164.37
> 7-Jun-13 163.85 164.95 163.14
> This (above)is using History return.
> --------------
> This is using the smfhighbetween().
> 28-Jun-13 161.82 155.73
> 21-Jun-13 165.12 157.47
> 14-Jun-13 164.53 160.46
> 7-Jun-13 164.23 159.40
> 31-May-13 166.89 162.27
> 24-May-13 168.18 163.08
> 17-May-13 166.16 161.96
>
> This is comparing the returns for high:
> 28 Jun 161.4 v 161.82
> 21 Jun 165.99 v 165.12
> 14 Jun 164.53 v 164.67
> etc.
> Hope that helps.Stan
>
smfHighBetween(
SPY went ex-dividend on June 21st.
On Sat, Jun 29, 2013 at 1:45 PM, grahamstan82 <asahi1931@hotmail.
> Hi...examples.
> Date Open High Low
> 28-Jun-13 160.63 161.4 159.86
> 27-Jun-13 161.1 161.82 160.95
> 26-Jun-13 159.87 160.5 159.25
> 25-Jun-13 158.48 160.1 157.42
> 24-Jun-13 157.41 158.43 155.73
> 21-Jun-13 159.64 159.76 157.47
> 20-Jun-13 161.86 163.47 158.98
> 19-Jun-13 165.6 165.89 163.38
> 18-Jun-13 164.53 165.99 164.52
> 17-Jun-13 164.29 165.22 163.22
> 14-Jun-13 164.03 164.67 162.91
> 13-Jun-13 161.66 164.5 161.3
> 12-Jun-13 164.22 164.39 161.6
> 11-Jun-13 163.3 164.54 162.74
> 10-Jun-13 165.31 165.4 164.37
> 7-Jun-13 163.85 164.95 163.14
> This (above)is using History return.
> ------------
> This is using the smfhighbetween(
> 28-Jun-13 161.82 155.73
> 21-Jun-13 165.12 157.47
> 14-Jun-13 164.53 160.46
> 7-Jun-13 164.23 159.40
> 31-May-13 166.89 162.27
> 24-May-13 168.18 163.08
> 17-May-13 166.16 161.96
>
> This is comparing the returns for high:
> 28 Jun 161.4 v 161.82
> 21 Jun 165.99 v 165.12
> 14 Jun 164.53 v 164.67
> etc.
> Hope that helps.Stan
>
Sat Jun 29, 2013 4:00 pm (PDT) . Posted by:
"sjagers" sjagers
Randy,
Hooray.... it works!!!
I replaced www.earnings.com with www.fulldisclosure.com and it extracts the same data as before.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> All the definitions are in smf-elements-8.txt. Looks like you could just do
> a "find and replace all" on the domain.
>
> On Wed, Jun 26, 2013 at 7:07 PM, sjagers <sjagers@...> wrote:
>
> > Randy.... Could this be the new URL for earnings.com data?
> >
> > http://www.fulldisclosure.com/company.asp?ticker=PAYX&coid=87087&client=cb
> >
> > The URL, abovve, is for Paychex earnings history.
> >
> > I just did an internet search and it popped up. Looks just like the
> > previous website.
> >
> > Can I modify your GetElementNumber macro or text file to see if we can
> > pull data from the website?
> >
> >
>
Hooray.... it works!!!
I replaced www.earnings.
--- In smf_addin@yahoogrou
>
> All the definitions are in smf-elements-
> a "find and replace all" on the domain.
>
> On Wed, Jun 26, 2013 at 7:07 PM, sjagers <sjagers@
>
> > Randy.... Could this be the new URL for earnings.com data?
> >
> > http://www.fulldisc
> >
> > The URL, abovve, is for Paychex earnings history.
> >
> > I just did an internet search and it popped up. Looks just like the
> > previous website.
> >
> > Can I modify your GetElementNumber macro or text file to see if we can
> > pull data from the website?
> >
> >
>
Sat Jun 29, 2013 6:03 pm (PDT) . Posted by:
"Mittal Monani" monani
Hello:
I have installed and activated the add-in in Excel (see screenshot 1) but when I try to test it using RCHGetYahooHistory("MSFT")
array formula, I get #VALUE errors (see screenshot 2). Could someone please help me fix this?
Thanks,
Mittal
I have installed and activated the add-in in Excel (see screenshot 1) but when I try to test it using RCHGetYahooHistory("MSFT")
array formula, I get #VALUE errors (see screenshot 2). Could someone please help me fix this?
Thanks,
Mittal
Attachments with this message:
2 of 2 Photo(s)
Sat Jun 29, 2013 6:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Wrong kind of double quotes around MSFT. You need the normal ones that
EXCEL uses, not those from a Word document (i.e. left double quotes and
right double quotes) -- they aren't proper string delimiters.
You probably cut and pasted from one of the installation blog entries?
On Sat, Jun 29, 2013 at 5:48 PM, Mittal Monani <monani@yahoo.com > wrote:
>
> I have installed and activated the add-in in Excel (see screenshot 1) but
> when I try to test it using RCHGetYahooHistory("MSFT")
> array formula, I get #VALUE errors (see screenshot 2). Could someone
> please help me fix this?
>
>
EXCEL uses, not those from a Word document (i.e. left double quotes and
right double quotes) -- they aren't proper string delimiters.
You probably cut and pasted from one of the installation blog entries?
On Sat, Jun 29, 2013 at 5:48 PM, Mittal Monani <monani@yahoo.
>
> I have installed and activated the add-in in Excel (see screenshot 1) but
> when I try to test it using RCHGetYahooHistory("MSFT")
> array formula, I get #VALUE errors (see screenshot 2). Could someone
> please help me fix this?
>
>
Sat Jun 29, 2013 6:39 pm (PDT) . Posted by:
"monani" monani
Randy:
I do appreciate the quick response to my request for help.
Thank you, you are right. The Excel double quote works. Yes, I did copy the original formula from one of the links in the links folder. It's a blog entry.
For the record, the formula that works is
=RCHGetYahooHistory("MSFT";)
entered as an array formula.
Thanks,
Mittal
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Wrong kind of double quotes around MSFT. You need the normal ones that
> EXCEL uses, not those from a Word document (i.e. left double quotes and
> right double quotes) -- they aren't proper string delimiters.
>
> You probably cut and pasted from one of the installation blog entries?
>
> On Sat, Jun 29, 2013 at 5:48 PM, Mittal Monani <monani@...> wrote:
>
> >
> > I have installed and activated the add-in in Excel (see screenshot 1) but
> > when I try to test it using RCHGetYahooHistory(“MSFTâ€)
> > array formula, I get #VALUE errors (see screenshot 2). Could someone
> > please help me fix this?
> >
> >
>
I do appreciate the quick response to my request for help.
Thank you, you are right. The Excel double quote works. Yes, I did copy the original formula from one of the links in the links folder. It's a blog entry.
For the record, the formula that works is
=RCHGetYahooHistory
entered as an array formula.
Thanks,
Mittal
--- In smf_addin@yahoogrou
>
> Wrong kind of double quotes around MSFT. You need the normal ones that
> EXCEL uses, not those from a Word document (i.e. left double quotes and
> right double quotes) -- they aren't proper string delimiters.
>
> You probably cut and pasted from one of the installation blog entries?
>
> On Sat, Jun 29, 2013 at 5:48 PM, Mittal Monani <monani@.
>
> >
> > I have installed and activated the add-in in Excel (see screenshot 1) but
> > when I try to test it using RCHGetYahooHistory(“MSFTâ€)
> > array formula, I get #VALUE errors (see screenshot 2). Could someone
> > please help me fix this?
> >
> >
>
Tidak ada komentar:
Posting Komentar