3 Messages
Digest #4660
1b
Re: Extract a cell from web based excel file, morning star #28540 by "Randy Harmelink" rharmelink
Messages
Fri Dec 13, 2019 6:17 pm (PST) . Posted by:
"Joe" jtassielli2003
Hi
Just want to extract a single cell, 10 year earnings, Not sure it's in csv or webpage.
Similar to the 10 year price performance.
Thanks
On Friday, May 26, 2017, 04:27:11 PM GMT-4, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Try:
=smfConvertData(smfWord(RCHGetWebData("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=PM","12/30/2016,",100),5,","))
Or, if you know where it will be on the returned file:
=INDEX(smfGetCSVFile("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=PM",,4,5),4,5)
On Fri, May 26, 2017 at 1:01 PM, jtassielli2003@...wrote:
I just wish to extract a single cell, E4: 91.49.
I used
http://performance. morningstar.com/Performance/ stock/exportStockPrice.action? pd=10y&freq=a&t=PM
thanks
| Date | Open | High | Low | Close | Volume |
| 5/25/2017 | 91.49 | 119.78 | 89.97 | 119.48 | 4,226,889 |
| 12/30/2016 | 87.91 | 104.2 | 84.46 | 91.49 | 4,470,395 |
Just want to extract a single cell, 10 year earnings, Not sure it's in csv or webpage.
Similar to the 10 year price performance.
Thanks
On Friday, May 26, 2017, 04:27:11 PM GMT-4, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Try:
=smfConvertData(smfWord(RCHGetWebData("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=PM","12/30/2016,",100),5,","))
Or, if you know where it will be on the returned file:
=INDEX(smfGetCSVFile("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?pd=10y&freq=a&t=PM",,4,5),4,5)
On Fri, May 26, 2017 at 1:01 PM, jtassielli2003@...wrote:
I just wish to extract a single cell, E4: 91.49.
I used
http://performance. morningstar.
thanks
| Date | Open | High | Low | Close | Volume |
| 5/25/2017 | 91.49 | 119.78 | 89.97 | 119.48 | 4,226,889 |
| 12/30/2016 | 87.91 | 104.2 | 84.46 | 91.49 | 4,470,395 |
Fri Dec 13, 2019 7:46 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sample URL and values you expect to extract please.
Most of the MorningStar CSV's are no longer accessible directly from EXCEL
because they require a cookie and credentials from the web site.in order to
retrieve them.
On Fri, Dec 13, 2019 at 7:17 PM Joe jtassielli2003@... wrote:
>
> Just want to extract a single cell, 10 year earnings, Not sure it's in csv
> or webpage.
>
> Similar to the 10 year price performance.
>
>
Most of the MorningStar CSV's are no longer accessible directly from EXCEL
because they require a cookie and credentials from the web site.in order to
retrieve them.
On Fri, Dec 13, 2019 at 7:17 PM Joe jtassielli2003@
>
> Just want to extract a single cell, 10 year earnings, Not sure it's in csv
> or webpage.
>
> Similar to the 10 year price performance.
>
>
Fri Dec 13, 2019 8:18 pm (PST) . Posted by:
"Subu S" mail_to_subu
Dear list members
Goodday. I'm a long time member.
I've Made very few posts but reading messages in digest mode.
I'm Posting now just to check my membership andALSO continue to be a MEMBER when yahoo group turns private.
I just wish to be a normal member even after yahoo groupsturn private.thanks in advregardsSubu
Goodday. I'm a long time member.
I've Made very few posts but reading messages in digest mode.
I'm Posting now just to check my membership andALSO continue to be a MEMBER when yahoo group turns private.
I just wish to be a normal member even after yahoo groupsturn private.thanks in advregardsSubu
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
1 komentar:
KnowledgeKafe.com is a world-class mediator connecting knowledge seekers with knowledge providers. We are actively involved in our efforts to make quality training courses and interesting events accessible and affordable for students and professionals in the region to enrol and attend.
Posting Komentar