7 New Messages
Digest #2346
1b Re: Find historical stock price daily and quarterly dividend per sha by "Stephen D" n_nobodysfool 1c Re: Find historical stock price daily and quarterly dividend per sha by "Randy Harmelink" rharmelink 1e Re: Find historical stock price daily and quarterly dividend per sha by "Randy Harmelink" rharmelink 2b Re: New to the group, trying to figure out SMF-Template-RCHGetYahooQ by "Randy Harmelink" rharmelink |
Messages
Fri Sep 14, 2012 11:08 am (PDT) . Posted by:
"Minh" minh0279
Hi all,
Do you know how to get historical stock price daily and quarterly dividend per share of any index? I already have S&P 500
Thank you for your time.
Minh
Do you know how to get historical stock price daily and quarterly dividend per share of any index? I already have S&P 500
Thank you for your time.
Minh
Fri Sep 14, 2012 1:36 pm (PDT) . Posted by:
"Stephen D" n_nobodysfool
Same as the S&p500 index; Stocks can be attained as the indices as well,
Sent from my iPhone
On Sep 14, 2012, at 1:08 PM, "Minh" <minh0279@yahoo.ca > wrote:
> Hi all,
>
> Do you know how to get historical stock price daily and quarterly dividend per share of any index? I already have S&P 500
>
> Thank you for your time.
>
> Minh
>
>
>
>
>
>
>
Sent from my iPhone
On Sep 14, 2012, at 1:08 PM, "Minh" <minh0279@yahoo.
> Hi all,
>
> Do you know how to get historical stock price daily and quarterly dividend per share of any index? I already have S&P 500
>
> Thank you for your time.
>
> Minh
>
>
>
>
>
>
>
Fri Sep 14, 2012 1:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just use the RCHGetYahooHistory() function...
On Fri, Sep 14, 2012 at 11:08 AM, Minh <minh0279@yahoo.ca > wrote:
>
> Do you know how to get historical stock price daily and quarterly dividend
> per share of any index? I already have S&P 500
>
On Fri, Sep 14, 2012 at 11:08 AM, Minh <minh0279@yahoo.
>
> Do you know how to get historical stock price daily and quarterly dividend
> per share of any index? I already have S&P 500
>
Fri Sep 14, 2012 9:47 pm (PDT) . Posted by:
"minh0279" minh0279
I do not know how to use that function. Can someone show me how to get data for one market, then I will do others? I probably need NYSE, AMEX, NASDAQ.
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just use the RCHGetYahooHistory() function...
>
> On Fri, Sep 14, 2012 at 11:08 AM, Minh <minh0279@...> wrote:
>
> >
> > Do you know how to get historical stock price daily and quarterly dividend
> > per share of any index? I already have S&P 500
> >
>
Thanks
--- In smf_addin@yahoogrou
>
> Just use the RCHGetYahooHistory(
>
> On Fri, Sep 14, 2012 at 11:08 AM, Minh <minh0279@..
>
> >
> > Do you know how to get historical stock price daily and quarterly dividend
> > per share of any index? I already have S&P 500
> >
>
Fri Sep 14, 2012 9:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Look in the "Documentation" folder of the files area for the documentation
on the function.
However, if you're looking to get history on all the stocks in each
exchange, this probably isn't the right tool for you.
On Fri, Sep 14, 2012 at 9:47 PM, minh0279 <minh0279@yahoo.ca > wrote:
> I do not know how to use that function. Can someone show me how to get
> data for one market, then I will do others? I probably need NYSE, AMEX,
> NASDAQ.
>
on the function.
However, if you're looking to get history on all the stocks in each
exchange, this probably isn't the right tool for you.
On Fri, Sep 14, 2012 at 9:47 PM, minh0279 <minh0279@yahoo.
> I do not know how to use that function. Can someone show me how to get
> data for one market, then I will do others? I probably need NYSE, AMEX,
> NASDAQ.
>
Fri Sep 14, 2012 10:08 pm (PDT) . Posted by:
"dmikester1" dmikester1
I would like to get this worksheet to pull in automatic stock quotes from Yahoo. I have copied the plugin files to C:\Program Files\SMF Add-in and downloaded the excel sheet and made sure to add the addin to Excel. I have verified the cell formula is looking in the right spot. Here is the formula for cell C4: ='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B4:B203,C2:V2)
However all my cells just say #NAME? What am I doing wrong? I've hit F9 and Shift-F9 several times. I've searched the documentation and this message group.
Thanks!
Mike
However all my cells just say #NAME? What am I doing wrong? I've hit F9 and Shift-F9 several times. I've searched the documentation and this message group.
Thanks!
Mike
Fri Sep 14, 2012 10:10 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Check out the LINKS area of the Yahoo group, and look for the item on
location errors.
On Fri, Sep 14, 2012 at 10:06 PM, dmikester1 <dmikester1@gmail.com > wrote:
> I would like to get this worksheet to pull in automatic stock quotes from
> Yahoo. I have copied the plugin files to C:\Program Files\SMF Add-in and
> downloaded the excel sheet and made sure to add the addin to Excel. I have
> verified the cell formula is looking in the right spot. Here is the
> formula for cell C4: ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B4:B203,C2:V2)
>
> However all my cells just say #NAME? What am I doing wrong? I've hit F9
> and Shift-F9 several times. I've searched the documentation and this
> message group.
>
location errors.
On Fri, Sep 14, 2012 at 10:06 PM, dmikester1 <dmikester1@gmail.
> I would like to get this worksheet to pull in automatic stock quotes from
> Yahoo. I have copied the plugin files to C:\Program Files\SMF Add-in and
> downloaded the excel sheet and made sure to add the addin to Excel. I have
> verified the cell formula is looking in the right spot. Here is the
> formula for cell C4: ='C:\Program Files\SMF
> Add-In\RCH_Stock_
>
> However all my cells just say #NAME? What am I doing wrong? I've hit F9
> and Shift-F9 several times. I've searched the documentation and this
> message group.
>
Tidak ada komentar:
Posting Komentar