10 New Messages
Digest #2332
| 1c Re: How to Extract Financial Information from Morningstar by "leiliao78@ymail.com" leiliao78@ymail.com |
Messages
Thu Aug 30, 2012 6:47 pm (PDT) . Posted by:
"Lei Liao" leiliao78@ymail.com
Hi Randy,
Thanks so much, I made it work now after i highlighted the range.
I still have a question, if I only want to have specific info, how do it
change the code.
Let's say, if I want to only extract Google's annual revenue raw data as
reported from 2002 to 2011 from Income Statement, how should I write the
code to achieve this goal.
Thanks,
Lei
Thanks so much, I made it work now after i highlighted the range.
I still have a question, if I only want to have specific info, how do it
change the code.
Let's say, if I want to only extract Google's annual revenue raw data as
reported from 2002 to 2011 from Income Statement, how should I write the
code to achieve this goal.
Thanks,
Lei
Thu Aug 30, 2012 7:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I think the file is a fixed format?
If so, you could retrieve the array of data in another worksheet, and then
reference the cells you need directly.
Otherwise, you could do a MATCH() or VLOOKUP() on the first column, looking
for an exact match on the row, and go over the number of columns you need
to for the correct year or quarter of data.
On Thu, Aug 30, 2012 at 6:47 PM, Lei Liao <liaolei78@gmail.com > wrote:
>
> Thanks so much, I made it work now after i highlighted the range.
>
> I still have a question, if I only want to have specific info, how do it
> change the code.
>
> Let's say, if I want to only extract Google's annual revenue raw data as
> reported from 2002 to 2011 from Income Statement, how should I write the
> code to achieve this goal.
>
>
If so, you could retrieve the array of data in another worksheet, and then
reference the cells you need directly.
Otherwise, you could do a MATCH() or VLOOKUP() on the first column, looking
for an exact match on the row, and go over the number of columns you need
to for the correct year or quarter of data.
On Thu, Aug 30, 2012 at 6:47 PM, Lei Liao <liaolei78@gmail.
>
> Thanks so much, I made it work now after i highlighted the range.
>
> I still have a question, if I only want to have specific info, how do it
> change the code.
>
> Let's say, if I want to only extract Google's annual revenue raw data as
> reported from 2002 to 2011 from Income Statement, how should I write the
> code to achieve this goal.
>
>
Thu Aug 30, 2012 8:24 pm (PDT) . Posted by:
"leiliao78@ymail.com" leiliao78@ymail.com
Thanks Randy!
Lei
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I think the file is a fixed format?
>
> If so, you could retrieve the array of data in another worksheet, and then
> reference the cells you need directly.
>
> Otherwise, you could do a MATCH() or VLOOKUP() on the first column, looking
> for an exact match on the row, and go over the number of columns you need
> to for the correct year or quarter of data.
>
> On Thu, Aug 30, 2012 at 6:47 PM, Lei Liao <liaolei78@...> wrote:
>
> >
> > Thanks so much, I made it work now after i highlighted the range.
> >
> > I still have a question, if I only want to have specific info, how do it
> > change the code.
> >
> > Let's say, if I want to only extract Google's annual revenue raw data as
> > reported from 2002 to 2011 from Income Statement, how should I write the
> > code to achieve this goal.
> >
> >
>
Lei
--- In smf_addin@yahoogrou
>
> I think the file is a fixed format?
>
> If so, you could retrieve the array of data in another worksheet, and then
> reference the cells you need directly.
>
> Otherwise, you could do a MATCH() or VLOOKUP() on the first column, looking
> for an exact match on the row, and go over the number of columns you need
> to for the correct year or quarter of data.
>
> On Thu, Aug 30, 2012 at 6:47 PM, Lei Liao <liaolei78@.
>
> >
> > Thanks so much, I made it work now after i highlighted the range.
> >
> > I still have a question, if I only want to have specific info, how do it
> > change the code.
> >
> > Let's say, if I want to only extract Google's annual revenue raw data as
> > reported from 2002 to 2011 from Income Statement, how should I write the
> > code to achieve this goal.
> >
> >
>
Thu Aug 30, 2012 7:09 pm (PDT) . Posted by:
"leiliao78@ymail.com" leiliao78@ymail.com
Hi Randy and all others,
I tried to get the last price of specific stock by using the function: RCHGetElementNumber(),( # 25, source from MSN), and it seems it does not work any more.
Do you know what the problem is? or is there another way to get the last price of specific stock?
Thanks a lot
I tried to get the last price of specific stock by using the function: RCHGetElementNumber
Do you know what the problem is? or is there another way to get the last price of specific stock?
Thanks a lot
Thu Aug 30, 2012 7:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
For some reason, MSN is citing the previous day's closing price as the
"Last Price". For current quotes, I suggest using the RCHGetYahooQuotes()
function -- it can return numerous items on up to 200 ticker symbols in a
single Internet access. Which can speed things up significantly from
getting data items one web page at a time.
On Thu, Aug 30, 2012 at 7:09 PM, leiliao78@ymail.com <liaolei78@gmail.com >wrote:
>
> I tried to get the last price of specific stock by using the function:
> RCHGetElementNumber(),( # 25, source from MSN), and it seems it does not
> work any more.
>
> Do you know what the problem is? or is there another way to get the last
> price of specific stock?
>
"Last Price". For current quotes, I suggest using the RCHGetYahooQuotes(
function -- it can return numerous items on up to 200 ticker symbols in a
single Internet access. Which can speed things up significantly from
getting data items one web page at a time.
On Thu, Aug 30, 2012 at 7:09 PM, leiliao78@ymail.
>
> I tried to get the last price of specific stock by using the function:
> RCHGetElementNumber
> work any more.
>
> Do you know what the problem is? or is there another way to get the last
> price of specific stock?
>
Thu Aug 30, 2012 8:36 pm (PDT) . Posted by:
"leiliao78@ymail.com" leiliao78@ymail.com
Thanks Randy,I tried the RCHGetYahooQuotes(
By the way, I want to automate this process by creating a ticker, so that every time I change the ticker's symbol ( e.g. from AAPL to GOOG), the current price of that ticker will show up accordingly.
So I wrote this code: =RCHGetYahooQuotes(
I don't know where I went wrong, could you tell me the problem with it?
Thanks,
Lei
--- In smf_addin@yahoogrou
>
> For some reason, MSN is citing the previous day's closing price as the
> "Last Price". For current quotes, I suggest using the RCHGetYahooQuotes(
> function -- it can return numerous items on up to 200 ticker symbols in a
> single Internet access. Which can speed things up significantly from
> getting data items one web page at a time.
>
> On Thu, Aug 30, 2012 at 7:09 PM, leiliao78@..
>
> >
> > I tried to get the last price of specific stock by using the function:
> > RCHGetElementNumber
> > work any more.
> >
> > Do you know what the problem is? or is there another way to get the last
> > price of specific stock?
> >
>
Thu Aug 30, 2012 8:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When you put "Ticker" in quotes, that IS your ticker symbol. Which doesn't
exist. So it returns a value of 0.
You want to put a cell reference there, such as:
=RCHGetYahooQuotes(A1,"l1")
Take a look at the step-by-step example of creating a quotes table pointed
to in either the documentation for the function, or in the LINKS area of
the group.
On Thu, Aug 30, 2012 at 8:36 PM, leiliao78@ymail.com <liaolei78@gmail.com >wrote:
>
> Thanks Randy,I tried the RCHGetYahooQuotes(), and it works perfect.
>
> By the way, I want to automate this process by creating a ticker, so that
> every time I change the ticker's symbol ( e.g. from AAPL to GOOG), the
> current price of that ticker will show up accordingly.
>
> So I wrote this code: =RCHGetYahooQuotes("Ticker","l1"), and it returns me
> the value of "0" for some reason. But if I write e.g. "GOOG" instead of
> "ticker", it returns me the correct value.
>
> I don't know where I went wrong, could you tell me the problem with it?
>
exist. So it returns a value of 0.
You want to put a cell reference there, such as:
=RCHGetYahooQuotes(
Take a look at the step-by-step example of creating a quotes table pointed
to in either the documentation for the function, or in the LINKS area of
the group.
On Thu, Aug 30, 2012 at 8:36 PM, leiliao78@ymail.
>
> Thanks Randy,I tried the RCHGetYahooQuotes(
>
> By the way, I want to automate this process by creating a ticker, so that
> every time I change the ticker's symbol ( e.g. from AAPL to GOOG), the
> current price of that ticker will show up accordingly.
>
> So I wrote this code: =RCHGetYahooQuotes(
> the value of "0" for some reason. But if I write e.g. "GOOG" instead of
> "ticker", it returns me the correct value.
>
> I don't know where I went wrong, could you tell me the problem with it?
>
Thu Aug 30, 2012 9:06 pm (PDT) . Posted by:
"leiliao78@ymail.com" leiliao78@ymail.com
I actually renamed the cell as "ticker" as well, and it worked for some reason after I closed and re-opened it.
Thanks,
--- In smf_addin@yahoogrou
>
> When you put "Ticker" in quotes, that IS your ticker symbol. Which doesn't
> exist. So it returns a value of 0.
>
> You want to put a cell reference there, such as:
>
> =RCHGetYahooQuotes(
>
> Take a look at the step-by-step example of creating a quotes table pointed
> to in either the documentation for the function, or in the LINKS area of
> the group.
>
> On Thu, Aug 30, 2012 at 8:36 PM, leiliao78@..
>
> >
> > Thanks Randy,I tried the RCHGetYahooQuotes(
> >
> > By the way, I want to automate this process by creating a ticker, so that
> > every time I change the ticker's symbol ( e.g. from AAPL to GOOG), the
> > current price of that ticker will show up accordingly.
> >
> > So I wrote this code: =RCHGetYahooQuotes(
> > the value of "0" for some reason. But if I write e.g. "GOOG" instead of
> > "ticker", it returns me the correct value.
> >
> > I don't know where I went wrong, could you tell me the problem with it?
> >
>
Thu Aug 30, 2012 9:30 pm (PDT) . Posted by:
"sudhir agarwal" sudhir_agarwal1
Hi,
I have a created a sheet in which you can enter multiple symbols and it
will give you the real time quote through MSN.
You can also set teh refresh frequency(1 min, 2 min 5 mins etc) and data
will be refreshed automatically.
I hope this helps you.
Sudhir
On Thu, Aug 30, 2012 at 11:36 PM, leiliao78@ymail.com
<liaolei78@gmail.com >wrote:
> **
>
>
>
> Thanks Randy,I tried the RCHGetYahooQuotes(), and it works perfect.
>
> By the way, I want to automate this process by creating a ticker, so that
> every time I change the ticker's symbol ( e.g. from AAPL to GOOG), the
> current price of that ticker will show up accordingly.
>
> So I wrote this code: =RCHGetYahooQuotes("Ticker","l1"), and it returns me
> the value of "0" for some reason. But if I write e.g. "GOOG" instead of
> "ticker", it returns me the correct value.
>
> I don't know where I went wrong, could you tell me the problem with it?
>
> Thanks,
>
> Lei
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > For some reason, MSN is citing the previous day's closing price as the
> > "Last Price". For current quotes, I suggest using the RCHGetYahooQuotes()
> > function -- it can return numerous items on up to 200 ticker symbols in a
> > single Internet access. Which can speed things up significantly from
> > getting data items one web page at a time.
> >
> > On Thu, Aug 30, 2012 at 7:09 PM, leiliao78@... <liaolei78@...>wrote:
>
> >
> > >
> > > I tried to get the last price of specific stock by using the function:
> > > RCHGetElementNumber(),( # 25, source from MSN), and it seems it does
> not
> > > work any more.
> > >
> > > Do you know what the problem is? or is there another way to get the
> last
> > > price of specific stock?
> > >
> >
>
>
>
I have a created a sheet in which you can enter multiple symbols and it
will give you the real time quote through MSN.
You can also set teh refresh frequency(1 min, 2 min 5 mins etc) and data
will be refreshed automatically.
I hope this helps you.
Sudhir
On Thu, Aug 30, 2012 at 11:36 PM, leiliao78@ymail.
<liaolei78@gmail.
> **
>
>
>
> Thanks Randy,I tried the RCHGetYahooQuotes(
>
> By the way, I want to automate this process by creating a ticker, so that
> every time I change the ticker's symbol ( e.g. from AAPL to GOOG), the
> current price of that ticker will show up accordingly.
>
> So I wrote this code: =RCHGetYahooQuotes(
> the value of "0" for some reason. But if I write e.g. "GOOG" instead of
> "ticker", it returns me the correct value.
>
> I don't know where I went wrong, could you tell me the problem with it?
>
> Thanks,
>
> Lei
>
> --- In smf_addin@yahoogrou
> >
> > For some reason, MSN is citing the previous day's closing price as the
> > "Last Price". For current quotes, I suggest using the RCHGetYahooQuotes(
> > function -- it can return numerous items on up to 200 ticker symbols in a
> > single Internet access. Which can speed things up significantly from
> > getting data items one web page at a time.
> >
> > On Thu, Aug 30, 2012 at 7:09 PM, leiliao78@..
>
> >
> > >
> > > I tried to get the last price of specific stock by using the function:
> > > RCHGetElementNumber
> not
> > > work any more.
> > >
> > > Do you know what the problem is? or is there another way to get the
> last
> > > price of specific stock?
> > >
> >
>
>
>
Attachments with this message:
1 of 1 File(s)
Thu Aug 30, 2012 8:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know of any place off-hand. And daily might be a stretch. I'd
suggest using Google (or another search engine) to look for a possible
source.
On Thu, Aug 30, 2012 at 6:27 PM, Minh <minh0279@yahoo.ca > wrote:
>
> I am looking for the S&P 500 historical daily dividend. Please let me know
> if you know how to get it.
>
suggest using Google (or another search engine) to look for a possible
source.
On Thu, Aug 30, 2012 at 6:27 PM, Minh <minh0279@yahoo.
>
> I am looking for the S&P 500 historical daily dividend. Please let me know
> if you know how to get it.
>
Tidak ada komentar:
Posting Komentar