2 Messages
Digest #4593
Messages
Mon Aug 5, 2019 12:14 pm (PDT) . Posted by:
rus101
Hi Randy,
Now that Morningstar did a major revamp of their site, many of the items you helped us code over the years are no longer available (e.g. anything from http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=mdlox http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=mdlox). I'm looking to replace some fund items with eTrade site. Could you please help with the best code to extract the data? For example, how would you pull "Number of Bond Holdings" or "Effective Duration" from the URL below?
https://www.etrade.wallst.com/v1/stocks/fund_portfolio/portfolio.asp?symbol=HYG http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=mdlox
Thanks!
Denis
Now that Morningstar did a major revamp of their site, many of the items you helped us code over the years are no longer available (e.g. anything from http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=mdlox http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=mdlox). I'm looking to replace some fund items with eTrade site. Could you please help with the best code to extract the data? For example, how would you pull "Number of Bond Holdings" or "Effective Duration" from the URL below?
https://www.etrade.wallst.com/v1/stocks/fund_portfolio/portfolio.asp?symbol=HYG http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=mdlox
Thanks!
Denis
Mon Aug 5, 2019 4:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
These work for me:
=RCHGetTableCell("
https://www.etrade.wallst.com/v1/stocks/fund_portfolio/portfolio.asp?symbol=HYG",1,">Number
of Bond Holdings")
=RCHGetTableCell("
https://www.etrade.wallst.com/v1/stocks/fund_portfolio/portfolio.asp?symbol=HYG",1,">Effective
Duration")
However, I did have to visit the Etrade website using EXCEL's "From Web
(Legacy)" option before I could access the page with the add-in. They have
some redirections that occur unless a website cookie is created first.
On Mon, Aug 5, 2019 at 12:16 PM rus101@... wrote:
> Now that Morningstar did a major revamp of their site, many of the items
> you helped us code over the years are no longer available (e.g. anything
> from
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=mdlox).
> I'm looking to replace some fund items with eTrade site. Could you please
> help with the best code to extract the data? For example, how would you
> pull "Number of Bond Holdings" or "Effective Duration" from the URL below?
>
>
> https://www.etrade.wallst.com/v1/stocks/fund_portfolio/portfolio.asp?symbol=HYG
>
>
>
=RCHGetTableCell("
https://www.etrade.wallst.com/v1/stocks/fund_portfolio/portfolio.asp?symbol=HYG",1,">Number
of Bond Holdings")
=RCHGetTableCell("
https://www.etrade.wallst.com/v1/stocks/fund_portfolio/portfolio.asp?symbol=HYG",1,">Effective
Duration")
However, I did have to visit the Etrade website using EXCEL's "From Web
(Legacy)" option before I could access the page with the add-in. They have
some redirections that occur unless a website cookie is created first.
On Mon, Aug 5, 2019 at 12:16 PM rus101@... wrote:
> Now that Morningstar did a major revamp of their site, many of the items
> you helped us code over the years are no longer available (e.g. anything
> from
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=mdlox).
> I'm looking to replace some fund items with eTrade site. Could you please
> help with the best code to extract the data? For example, how would you
> pull "Number of Bond Holdings" or "Effective Duration" from the URL below?
>
>
> https://www.etrade.wallst.com/v1/stocks/fund_portfolio/portfolio.asp?symbol=HYG
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar