7 Messages
Digest #4584
Messages
Tue Jul 23, 2019 8:31 am (PDT) . Posted by:
forse85
Hello,
I used the following to pull the financials from Morningstar but now receive an error:
=smfGetCSVFile("http://financials.morningstar.com/ajax/exportKR2CSV.html?t="&Ticker)
Just checking if there is a way to get this working again. Also, if anybody knows a monthly service, etc., that would enable me to pull financials into Excel, that would be appreciated. Maybe there is an online broker that provides this service?
Thanks!
Scott
I used the following to pull the financials from Morningstar but now receive an error:
=smfGetCSVFile("http://financials.morningstar.com/ajax/exportKR2CSV.html?t="&Ticker)
Just checking if there is a way to get this working again. Also, if anybody knows a monthly service, etc., that would enable me to pull financials into Excel, that would be appreciated. Maybe there is an online broker that provides this service?
Thanks!
Scott
Tue Jul 23, 2019 9:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The financial CSV files from Morningstar now require credentials, so the
add-in can't grab them.
I don't use financials much, but do subscribe to GuruFocus for their
extensive bank of data. I've attached a copy of the template that grabs
data from their CSV file, with the results saved as values, so you can see
what kinds of things are available.
On Tue, Jul 23, 2019 at 8:34 AM ole.jeb@... wrote:
>
> I used the following to pull the financials from Morningstar but now
> receive an error:
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t="&Ticker)
>
> Just checking if there is a way to get this working again. Also, if
> anybody knows a monthly service, etc., that would enable me to pull
> financials into Excel, that would be appreciated. Maybe there is an online
> broker that provides this service?
>
>
>
add-in can't grab them.
I don't use financials much, but do subscribe to GuruFocus for their
extensive bank of data. I've attached a copy of the template that grabs
data from their CSV file, with the results saved as values, so you can see
what kinds of things are available.
On Tue, Jul 23, 2019 at 8:34 AM ole.jeb@... wrote:
>
> I used the following to pull the financials from Morningstar but now
> receive an error:
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t="&Ticker)
>
> Just checking if there is a way to get this working again. Also, if
> anybody knows a monthly service, etc., that would enable me to pull
> financials into Excel, that would be appreciated. Maybe there is an online
> broker that provides this service?
>
>
>
Tue Jul 23, 2019 11:31 am (PDT) . Posted by:
forse85
Hello Randy,
Thanks for the confirmation on Morningstar. Also, thanks for the GuruFocus info. I'll check it out tonight.
I'll move forward and find another way to get my information.
Thanks,
Scott
Thanks for the confirmation on Morningstar. Also, thanks for the GuruFocus info. I'll check it out tonight.
I'll move forward and find another way to get my information.
Thanks,
Scott
Tue Jul 23, 2019 10:39 am (PDT) . Posted by:
nelsonmuntz1000
Hi Randy. RCHGetElementNumber 704 Barchart Directional Indicator returns "Error". Was working until recently. Barchart 701, 702, 721 still return results. Has something changed? Sample url https://www.barchart.com/etfs-funds/quotes/IHI/opinion https://www.barchart.com/etfs-funds/quotes/IHI/opinion
Tue Jul 23, 2019 12:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They redesigned the page, dropping some of the items and adding others.
Even moving things around between the definitions of short, medium, and
long-term indicators...
Very little is as it was.
On Tue, Jul 23, 2019 at 10:39 AM ccoupe300@... wrote:
> Hi Randy. RCHGetElementNumber 704 Barchart Directional Indicator returns
> "Error". Was working until recently. Barchart 701, 702, 721 still return
> results. Has something changed? Sample url
> https://www.barchart.com/etfs-funds/quotes/IHI/opinion
>
>
Even moving things around between the definitions of short, medium, and
long-term indicators...
Very little is as it was.
On Tue, Jul 23, 2019 at 10:39 AM ccoupe300@... wrote:
> Hi Randy. RCHGetElementNumber 704 Barchart Directional Indicator returns
> "Error". Was working until recently. Barchart 701, 702, 721 still return
> results. Has something changed? Sample url
> https://www.barchart.com/etfs-funds/quotes/IHI/opinion
>
>
Tue Jul 23, 2019 12:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
P.S. Their description of the changes is here:
https://www.barchart.com/education/new-trading-signals
On Tue, Jul 23, 2019 at 10:39 AM ccoupe300@... wrote:
> Hi Randy. RCHGetElementNumber 704 Barchart Directional Indicator returns
> "Error". Was working until recently. Barchart 701, 702, 721 still return
> results. Has something changed? Sample url
> https://www.barchart.com/etfs-funds/quotes/IHI/opinion
>
>
>
https://www.barchart.com/education/new-trading-signals
On Tue, Jul 23, 2019 at 10:39 AM ccoupe300@... wrote:
> Hi Randy. RCHGetElementNumber 704 Barchart Directional Indicator returns
> "Error". Was working until recently. Barchart 701, 702, 721 still return
> results. Has something changed? Sample url
> https://www.barchart.com/etfs-funds/quotes/IHI/opinion
>
>
>
Wed Jul 24, 2019 3:37 am (PDT) . Posted by:
lawrence.leesh
Hi Randy
Could you pls help me with the formula for:
https://www.marketscreener.com/LIBSTAR-HOLDINGS-LTD-44965043/financials/ https://www.marketscreener.com/LIBSTAR-HOLDINGS-LTD-44965043/financials/
2018 (fiscal year)
9 892 (sales)
1 169 (debt)
thanks
Could you pls help me with the formula for:
https://www.marketscreener.com/LIBSTAR-HOLDINGS-LTD-44965043/financials/ https://www.marketscreener.com/LIBSTAR-HOLDINGS-LTD-44965043/financials/
2018 (fiscal year)
9 892 (sales)
1 169 (debt)
thanks
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar