Messages In This Digest (3 Messages)

1a.: smfPrice by and between From: antonvanas1989
1b.: Re: smfPrice by and between From: Randy Harmelink

2a.: Re: I am having trouble with RCHGetYahooQuotes() Excel function From: george

View All Topics | Create New Topic

Messages

1a.: smfPrice by and between

Posted by: "antonvanas1989" antonvanas1989@yahoo.com antonvanas1989

Fri Jan 6, 2012 5:13 am (PST)

Goodday Randy,

I got a problem now but i can't fix it by myself.

In my spreadsheet i uses Prices by dates:
Year low
Year high
Year end

herefor i different formulas:
low =smfPricesBetween(Ticker;M3;M4;"06")
high =smfPricesBetween(Ticker;M3;M4;"04")
end =smfPricesByDates(Ticker;M4)

The cells contain:
M3 = 01-01-10
M4 = 12-31-10

I'm Europian but using English (U.S.) for Data format

Now my problem is that i get the adjusted closed values insteed of the correct; high, low and close values from Yahoo.

Also tried [2010,12,31] , [Dec 31, 2010] , [12/31/2010] , [31-12-2010] but i still get adj. close value.

How can i solve this problem?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: smfPrice by and between

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Fri Jan 6, 2012 5:39 am (PST)

Both functions only use adjusted prices. To me, the prices aren't
comparable between or over periods without the adjustments. For example,
suppose there was a 3-1 split mid-year.

On Fri, Jan 6, 2012 at 6:13 AM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

>
> I got a problem now but i can't fix it by myself.
>
> In my spreadsheet i uses Prices by dates:
> Year low
> Year high
> Year end
>
> herefor i different formulas:
> low =smfPricesBetween(Ticker;M3;M4;"06")
> high =smfPricesBetween(Ticker;M3;M4;"04")
> end =smfPricesByDates(Ticker;M4)
>
> The cells contain:
> M3 = 01-01-10
> M4 = 12-31-10
>
> I'm Europian but using English (U.S.) for Data format
>
> Now my problem is that i get the adjusted closed values insteed of the
> correct; high, low and close values from Yahoo.
>
> Also tried [2010,12,31] , [Dec 31, 2010] , [12/31/2010] , [31-12-2010]
> but i still get adj. close value.
>
> How can i solve this problem?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2a.: Re: I am having trouble with RCHGetYahooQuotes() Excel function

Posted by: "george" panax@fuse.net simon_of_iernot

Fri Jan 6, 2012 5:50 am (PST)

The array formula works great! I had a workbook that took 5 minutes to retrieve data using the individual formulas.

Last weekend I converted it to the array formulas it now takes 4- 5 seconds to retrieve the same data.

gb

----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Thursday, January 05, 2012 16:01
Subject: Re: [smf_addin] I am having trouble with RCHGetYahooQuotes() Excel function

I would suspect you're getting timeout errors from Yahoo. I had a few this morning myself.

It should happen less often if you array-enter the formulas over a range -- then you can get all of the data in one Internet access instead of each function going to the Internet on its own.

On Thu, Jan 5, 2012 at 11:30 AM, investor952 <investor952@yahoo.com> wrote:

Last night and this morning, I am having trouble with this function in that there are several valid tickers that are returning an 'error' message for their price. I am using the formula
=RCHGetYahooQuotes(X,Y), where X is the ticker and Y is the smf code 'l1' . Note, some tickers are working, and others are returning this error. Below is a list of tickers that returned this error message the last time I tried it (about 20 minutes ago):

iqc
mua
evt
usb-pj
avv
mer-pp
jpm-pc
EEP
ohi
gsf
sxl
pmt
uan
ngg
pse

Prior to yesterday, I didn't have this problem.
I have not changed anything in my spreadsheet since it was working.
Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)