[smf_addin] Digest Number 3053

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #3053

1a

Re: Book or Online Tutorial On How To Set Up RCH GET ELEMENT Table? by jaaksbus

1b

Re: Book or Online Tutorial On How To Set Up RCH GET ELEMENT Table? by "Randy Harmelink" rharmelink

2a

Re: historical stock prices by lawleesh

2b

Re: historical stock prices by "Randy Harmelink" rharmelink

2c

Re: historical stock prices by lawleesh

Messages

1a

Re: Book or Online Tutorial On How To Set Up RCH GET ELEMENT Table?

Tue Apr 29, 2014 1:55 pm (PDT) . Posted by:

jaaksbus

Nwe to this, but 785;StockScores;20 Day Avg Vol;=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=~~~~~ http://www.stockscores.com/quickreport.asp?ticker=~~~~~",1,"20 Day Avg Vol")
does nothing when I put it in a spreadsheet cell. What am I missing? Am I suppose to put the part before "=RCH..." in seperate cells?


Thanks


John

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

1b

Re: Book or Online Tutorial On How To Set Up RCH GET ELEMENT Table?

Tue Apr 29, 2014 1:59 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's the definition of the element. To use it, you would do something
like:

=RCHGetElementNumber("MMM",785)

On Tue, Apr 29, 2014 at 9:26 AM, <jaaksbus@yahoo.com> wrote:

>
> Nwe to this, but 785;StockScores;20 Day Avg Vol;=RCHGetTableCell("
> http://www.stockscores.com/quickreport.asp?ticker=~~~~~",1,"20 Day Avg
> Vol")
> does nothing when I put it in a spreadsheet cell. What am I missing? Am I
> suppose to put the part before "=RCH..." in seperate cells?
>
>

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

2a

Re: historical stock prices

Tue Apr 29, 2014 9:47 pm (PDT) . Posted by:

lawleesh

Hi Randy

Your smfpricesbydate function downloads adjusted closing prices. If I want to download unadjusted closing prices is it possible?


regards


LL

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

2b

Re: historical stock prices

Tue Apr 29, 2014 9:52 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not as that function is currently set up...

You'd need to use RCHGetYahooHistory().

On Tue, Apr 29, 2014 at 9:47 PM, <lawrence.leesh@gmail.com> wrote:

>
> Hi Randy
>
> Your smfpricesbydate function downloads adjusted closing prices. If I want
> to download unadjusted closing prices is it possible?
>
>

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

2c

Re: historical stock prices

Tue Apr 29, 2014 10:01 pm (PDT) . Posted by:

lawleesh

I used this formula =RCHGetYahooHistory("4677.KL",2009,1,1,2014)

and it says "Something wrong with dates..."


Did I make a mistake somewhere?


thanks

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

Visit Your Group

• New Members 38

• Privacy • Unsubscribe • Terms of Use