3 Messages
Digest #3107
Messages
Sun Jun 29, 2014 2:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Check out the "Tips and FAQs" web page. There are several items there
regarding faster downloading of data from FinViz. The export process would
probably be the easiest. You can get everything on a CSV file with a single
Internet access.
On Sun, Jun 29, 2014 at 1:01 AM, schlange.meister@... wrote:
> I did not see any RCHGetElements for FinViz so I wanted to ask her for
> some advice.
>
> I am trying to download the 3 month, 6 month and annual performance from
> the FinViz page. It is on the right side of the table when you search for
> a stock. I want to do this for about 15 stocks at a time and was wondering
> two things:
>
> 1. What is the code needed to reference the ticker in A3 and download the
> 3m, 6m and full year performance from Finviz
>
> 2. Is there a faster way to do it given 3 fields and 15 stocks? Would an
> array be better for the data and less load on Finviz? How would I
> implement something like that?
>
regarding faster downloading of data from FinViz. The export process would
probably be the easiest. You can get everything on a CSV file with a single
Internet access.
On Sun, Jun 29, 2014 at 1:01 AM, schlange.meister@
> I did not see any RCHGetElements for FinViz so I wanted to ask her for
> some advice.
>
> I am trying to download the 3 month, 6 month and annual performance from
> the FinViz page. It is on the right side of the table when you search for
> a stock. I want to do this for about 15 stocks at a time and was wondering
> two things:
>
> 1. What is the code needed to reference the ticker in A3 and download the
> 3m, 6m and full year performance from Finviz
>
> 2. Is there a faster way to do it given 3 fields and 15 stocks? Would an
> array be better for the data and less load on Finviz? How would I
> implement something like that?
>
Sun Jun 29, 2014 6:50 pm (PDT) . Posted by:
drminvest
Hello
I would like to read Incoming, balance and cash from reuters.
I have try with RCHGetTableCell but I do not read nothing.
I have try with RCHGetWebData to see what to debug my previous function but I also do not get nothing:
=RCHGetWebData("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=KO",1)
(I have try with yahoo and it works fine=
Can someone help me?
Cheers
Sun Jun 29, 2014 7:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This got the Revenue number for me:
=RCHGetTableCell("
http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=KO
",1,">Revenue")
...but in order to access the financial statements data, you FIRST need to
create an IE security cookie by logging in to the Reuter site either using
the EXCEL Web Query dialog (keyboard shortcut alt+d+d+w) or by using IE.
I also got nothing with your formula below, until I logged into the Reuters
website and ran the smfForceRecalculation macro to get a new copy of the
web page (after the security cookie was in place). Then the formula worked
fine.
On Sun, Jun 29, 2014 at 5:33 PM, diegoreal@yahoo.es [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I would like to read Incoming, balance and cash from reuters.
>
> I have try with RCHGetTableCell but I do not read nothing.
>
> I have try with RCHGetWebData to see what to debug my previous function
> but I also do not get nothing:
>
> =RCHGetWebData("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=KO
> ",1)
>
> (I have try with yahoo and it works fine=
>
> Can someone help me?
>
=RCHGetTableCell("
http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=KO
",1,">Revenue")
...but in order to access the financial statements data, you FIRST need to
create an IE security cookie by logging in to the Reuter site either using
the EXCEL Web Query dialog (keyboard shortcut alt+d+d+w) or by using IE.
I also got nothing with your formula below, until I logged into the Reuters
website and ran the smfForceRecalculation macro to get a new copy of the
web page (after the security cookie was in place). Then the formula worked
fine.
On Sun, Jun 29, 2014 at 5:33 PM, diegoreal@yahoo.es [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I would like to read Incoming, balance and cash from reuters.
>
> I have try with RCHGetTableCell but I do not read nothing.
>
> I have try with RCHGetWebData to see what to debug my previous function
> but I also do not get nothing:
>
> =RCHGetWebData("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=KO
> ",1)
>
> (I have try with yahoo and it works fine=
>
> Can someone help me?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar