[smf_addin] Digest Number 2972

EXCEL Stock Market Functions Add-in Group

7 Messages

Digest #2972

1a

Re: retrieve fixed number of quotes by sihlai

1b

Re: retrieve fixed number of quotes by "Randy Harmelink" rharmelink

2a

Re: smfpricesbetween with monthly dates by "Nikola Ganev" ganevniko

2b

Re: smfpricesbetween with monthly dates by timy2matoe

3a

Re: Yahoo Advancers / Decliners by donald_brown_48367

4a

How to Get this Data? by gz_cp

4b

Re: How to Get this Data? by "Randy Harmelink" rharmelink

Messages

1a

Re: retrieve fixed number of quotes

Mon Feb 17, 2014 7:46 am (PST) . Posted by:

sihlai

I thought about that and tried it out within the spreadsheet first with different data items. For example, according to the manual when using "H" or "L", it will return high or low for the period, but this particular line returned high and low for Feb 13 only. That led me to think that I did not retrieve the correct data set.


=RCHGetYahooHistory("MSFT";,2014,1,2,2014,2,13, , "H", 0, , ,20,1)

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

1b

Re: retrieve fixed number of quotes

Mon Feb 17, 2014 8:02 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It's not high or low for the PERIOD, but for each DAY within the period. If
you want high or low for a period, you'll need to use the
smfPricesBetween() function.

You probably got just a single line because you didn't array-enter the
formula over a range. If you just enter it into a single cell, you just get
the first item.

On Mon, Feb 17, 2014 at 8:46 AM, <sihlai@yahoo.ca> wrote:

>
> I thought about that and tried it out within the spreadsheet first with
> different data items. For example, according to the manual when using "H"
> or "L", it will return high or low for the period, but this particular line
> returned high and low for Feb 13 only. That led me to think that I did not
> retrieve the correct data set.
>
> =RCHGetYahooHistory("MSFT";,2014,1,2,2014,2,13, , "H", 0, , ,20,1)
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

2a

Re: smfpricesbetween with monthly dates

Mon Feb 17, 2014 10:41 am (PST) . Posted by:

"Nikola Ganev" ganevniko

I enter the following formula =RCHGetYahooHistory("IBM",2014,1,27,2014,2,3,"A",0) in an array and it just says "invalid period" in the first cell of the array.

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2b

Re: smfpricesbetween with monthly dates

Mon Feb 17, 2014 4:55 pm (PST) . Posted by:

timy2matoe

Nikola,
See if adding a comma after the 3 works for you..... =RCHGetYahooHistory("IBM",2007,1,3,2007,1,3,,"A",0)
Tim

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

3a

Re: Yahoo Advancers / Decliners

Mon Feb 17, 2014 4:42 pm (PST) . Posted by:

donald_brown_48367

Thanks very much Randy. I'll try that out.

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

4a

How to Get this Data?

Mon Feb 17, 2014 10:57 pm (PST) . Posted by:

gz_cp

If I want to return this "42" in "appears in our database 42 times", on this page http://www.stopforumspam.com/ipcheck/128.72.107.120 http://www.stopforumspam.com/ipcheck/128.72.107.120

How can I write the formula?


Thank you very much.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4b

Re: How to Get this Data?

Mon Feb 17, 2014 11:32 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.stopforumspam.com/ipcheck/128.72.107.120","p",-1,"appears in our
database"),"database","time"))

On Mon, Feb 17, 2014 at 11:56 PM, <gz_cp@yahoo.com> wrote:

>
> If I want to return this "42" in "appears in our database 42 times",
> on this page http://www.stopforumspam.com/ipcheck/128.72.107.120
>
> How can I write the formula?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

Visit Your Group

• New Members 42

• Privacy • Unsubscribe • Terms of Use