5 Messages
Digest #4511
1b
Re: smfconvertdata, retrieve didends and eps from morningstar csv fi by "Randy Harmelink" rharmelink
Messages
Wed Apr 3, 2019 11:20 am (PDT) . Posted by:
"Joe" jtassielli2003
HI Randy
=smfConvertData(smfWord(RCHGetWebData("http://financials.morningstar..com/ajax/exportKR2CSV.html?t="&+E$2,
I get a blank screen. I would also like to get EPS, both for 10 years..
Thanks for your help.
#yiv1856786588 #yiv1856786588 -- #yiv1856786588ygrp-
Wed Apr 3, 2019 11:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, Morningstar CSV files are now protected and no longer
available to the add-in.
On Wed, Apr 3, 2019 at 11:20 AM Joe jtassielli2003@... wrote:
>
> =smfConvertData(smfWord(RCHGetWebData("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t="&+E$2,"Dividends
> USD,",100),3,","))
>
> I get a blank screen. I would also like to get EPS, both for 10 years..
>
>
>
available to the add-in.
On Wed, Apr 3, 2019 at 11:20 AM Joe jtassielli2003@... wrote:
>
> =smfConvertData(smfWord(RCHGetWebData("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t="&+E$2,
> USD,",100)
>
> I get a blank screen. I would also like to get EPS, both for 10 years..
>
>
>
Wed Apr 3, 2019 12:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't understand the problem. Why aren't you just extracting the data
from the second URL you gave? You can just grab the whole table with:
=RCHGetHTMLTable("
https://www.gurufocus.com/modules/chart/insider/insider_history_chart.php?symbol=AAPL","Shares
owned after this")
....although the header line is mixed up.
On Wed, Apr 3, 2019 at 3:25 AM naeem_4tk@... wrote:
> I am looking for formula to get figures from
> https://www.gurufocus.com/InsiderBuy.php?symbol1=AAPL I need to get
> "Shares Owned After This" which becomes visible only when you click
> anywhere on the main table. You can also take a look at this link
> https://www.gurufocus.com/modules/chart/insider/insider_history_chart.php?symbol=AAPL
>
>
from the second URL you gave? You can just grab the whole table with:
=RCHGetHTMLTable("
https://www.gurufocus.com/modules/chart/insider/insider_history_chart.php?symbol=AAPL","Shares
owned after this")
....although the header line is mixed up.
On Wed, Apr 3, 2019 at 3:25 AM naeem_4tk@... wrote:
> I am looking for formula to get figures from
> https://www.gurufocus.com/InsiderBuy.php?symbol1=AAPL I need to get
> "Shares Owned After This" which becomes visible only when you click
> anywhere on the main table. You can also take a look at this link
> https://www.gurufocus.com/modules/chart/insider/insider_history_chart.php?symbol=AAPL
>
>
Wed Apr 3, 2019 9:52 pm (PDT) . Posted by:
caleb.mullins25
Hi Randy, Thanks for help. I don't know how to grab desired values using the formula you shared. It only gets "Shares Owned After This" I want to extract each value in that column e.g. 1147283 ... 8940 and so on.
Wed Apr 3, 2019 11:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to array-enter the formula over a range to get the whole table. If
you enter it into a single cell, you'll just get a single table value..
If you just want the one column, you can array-enter this down a column:
=INDEX(RCHGetHTMLTable("
https://www.gurufocus.com/modules/chart/insider/insider_history_chart.php?symbol=AAPL","Shares
owned after this",,,,,20,20),,9)
You can grab single values out of the table with:
=INDEX(RCHGetHTMLTable("
https://www.gurufocus.com/modules/chart/insider/insider_history_chart.php?symbol=AAPL","Shares
owned after this",,,,,20,20),2,9)
=INDEX(RCHGetHTMLTable("
https://www.gurufocus.com/modules/chart/insider/insider_history_chart.php?symbol=AAPL","Shares
owned after this",,,,,20,20),3,9)
....and so forth...
On Wed, Apr 3, 2019 at 9:52 PM naeem_4tk@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks for help. I don't know how to grab desired values using the formula
> you shared. It only gets "Shares Owned After This" I want to extract each
> value in that column e.g. 1147283 ... 8940 and so on.
>
>
>
you enter it into a single cell, you'll just get a single table value..
If you just want the one column, you can array-enter this down a column:
=INDEX(RCHGetHTMLTable("
https://www.gurufocus.com/modules/chart/insider/insider_history_chart.php?symbol=AAPL","Shares
owned after this",,,,,20,20),,9)
You can grab single values out of the table with:
=INDEX(RCHGetHTMLTable("
https://www.gurufocus.com/modules/chart/insider/insider_history_chart.php?symbol=AAPL","Shares
owned after this",,,,,20,20),2,9)
=INDEX(RCHGetHTMLTable("
https://www.gurufocus.com/modules/chart/insider/insider_history_chart.php?symbol=AAPL","Shares
owned after this",,,,,20,20),3,9)
....and so forth...
On Wed, Apr 3, 2019 at 9:52 PM naeem_4tk@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks for help. I don't know how to grab desired values using the formula
> you shared. It only gets "Shares Owned After This" I want to extract each
> value in that column e.g. 1147283 ... 8940 and so on.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar