3 Messages
Digest #3063
Messages
Sun May 11, 2014 6:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I think that's what you need to do...I can't think of a better way.
On Sun, May 11, 2014 at 4:31 PM, mbabla@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I need to run a model using the average price during the quarter for a
> large number of companies (500+) for the last eight quarters. Is there an
> easier way to do it that downloading the price history for each of those
> stocks?
>
On Sun, May 11, 2014 at 4:31 PM, mbabla@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I need to run a model using the average price during the quarter for a
> large number of companies (500+) for the last eight quarters. Is there an
> easier way to do it that downloading the price history for each of those
> stocks?
>
Mon May 12, 2014 11:02 pm (PDT) . Posted by:
raniersfury
I was wondering if anyone had any ideas of how to leverage perhaps one of the existing SMF functions (RCHGetTableData; RCHGetWebData, etc) to retrieve the RiskMetrics score from the NASDAQ website, for a particular ticker.
The website will allow you to directly enter the ticker into the URL (i.e. www.nasdaq.com/symbol/[ticker]/risk)
but the RiskGrade appears on the continuum further below on the webpage and I'm not sure if it is technically in a table field or otherwise retrievable with one of the existing SMF functions (I mostly rerieve data using the RCHGetElementNumber function, which won't work here...thanks for putting all these great functions on this Group by the way).
I'm not too savvy 'coding" as I barely understand how the RCHGetElementNumber function works), so was hoping there was a straight forward SMF function to retrieve a ticker RiskGrade into an Excel workbook.
Any thoughts would be appreciated.
The website will allow you to directly enter the ticker into the URL (i.e. www.nasdaq.com/
but the RiskGrade appears on the continuum further below on the webpage and I'm not sure if it is technically in a table field or otherwise retrievable with one of the existing SMF functions (I mostly rerieve data using the RCHGetElementNumber function, which won't work here...thanks for putting all these great functions on this Group by the way).
I'm not too savvy 'coding" as I barely understand how the RCHGetElementNumber function works), so was hoping there was a straight forward SMF function to retrieve a ticker RiskGrade into an Excel workbook.
Any thoughts would be appreciated.
Tue May 13, 2014 12:33 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but the RiskGrade only appears on the image itself, so there's no
text for the add-in to extract.
On Mon, May 12, 2014 at 9:56 PM, cburkhalterjr@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I was wondering if anyone had any ideas of how to leverage perhaps one
> of the existing SMF functions (RCHGetTableData; RCHGetWebData, etc) to
> retrieve the RiskMetrics score from the NASDAQ website, for a particular
> ticker.
>
> The website will allow you to directly enter the ticker into the URL (i.e.
> www.nasdaq.com/symbol/[ticker]/risk<http://www.nasdaq.com/symbol/%5Bticker%5D/risk>
> )
>
> but the RiskGrade appears on the continuum further below on the webpage
> and I'm not sure if it is technically in a table field or otherwise
> retrievable with one of the existing SMF functions (I mostly rerieve data
> using the RCHGetElementNumber function, which won't work here...thanks for
> putting all these great functions on this Group by the way).
>
> I'm not too savvy 'coding" as I barely understand how the
> RCHGetElementNumber function works), so was hoping there was a straight
> forward SMF function to retrieve a ticker RiskGrade into an Excel workbook.
>
> Any thoughts would be appreciated.
>
text for the add-in to extract.
On Mon, May 12, 2014 at 9:56 PM, cburkhalterjr@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I was wondering if anyone had any ideas of how to leverage perhaps one
> of the existing SMF functions (RCHGetTableData; RCHGetWebData, etc) to
> retrieve the RiskMetrics score from the NASDAQ website, for a particular
> ticker.
>
> The website will allow you to directly enter the ticker into the URL (i.e.
> www.nasdaq.com/symbol/[ticker]/risk<http://www.nasdaq.com/symbol/%5Bticker%5D/risk>
> )
>
> but the RiskGrade appears on the continuum further below on the webpage
> and I'm not sure if it is technically in a table field or otherwise
> retrievable with one of the existing SMF functions (I mostly rerieve data
> using the RCHGetElementNumber function, which won't work here...thanks for
> putting all these great functions on this Group by the way).
>
> I'm not too savvy 'coding" as I barely understand how the
> RCHGetElementNumber function works), so was hoping there was a straight
> forward SMF function to retrieve a ticker RiskGrade into an Excel workbook.
>
> Any thoughts would be appreciated.
>
Tidak ada komentar:
Posting Komentar