8 Messages
Digest #4508
2b
Re: Morningstar Data Now Requires Callback Parameter, What Can We Do by "Randy Harmelink" rharmelink
2c
Re: Morningstar Data Now Requires Callback Parameter, What Can We Do by "Marc Johnson" marclerjohnson
Messages
Fri Mar 29, 2019 6:23 am (PDT) . Posted by:
JCHyjun
Hello,
Randy has helped a lot of d-i-y investors with his famous Stock Market Functions Add-in. At the same time we observed trend of converting free financial data into subscribe-based businesses, which is OK because most of data providers are for-profit companies. Unfortunately many small investors cannot afford subscribtion(s), so usability of SMF decreases.
Nevertheless where are non-profit organizations that still provide (and will provide) free financial data (e.g. SEC with their EDGAR WWW site - https://www.sec.gov/edgar/searchedgar/companysearch.html). https://www.sec.gov/edgar/searchedgar/companysearch.html which by-the-way is original (and so most reliable) source of information.
I'd strongly appreciate if Randy and other computer savvy members of smf_addin group develop SMF elements and arrays that allows extract multi-years financial data EDGAR WWW site. IMHO it will be extremely helpful for all d-i-y investors.
Thank you in advance
JCH
Randy has helped a lot of d-i-y investors with his famous Stock Market Functions Add-in. At the same time we observed trend of converting free financial data into subscribe-based businesses, which is OK because most of data providers are for-profit companies. Unfortunately many small investors cannot afford subscribtion(s), so usability of SMF decreases.
Nevertheless where are non-profit organizations that still provide (and will provide) free financial data (e.g. SEC with their EDGAR WWW site - https://www.sec.gov/edgar/searchedgar/companysearch.html). https://www.sec.gov/edgar/searchedgar/companysearch.html which by-the-way is original (and so most reliable) source of information.
I'd strongly appreciate if Randy and other computer savvy members of smf_addin group develop SMF elements and arrays that allows extract multi-years financial data EDGAR WWW site. IMHO it will be extremely helpful for all d-i-y investors.
Thank you in advance
JCH
Fri Mar 29, 2019 8:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Can you give me an example URL of what you mean? Last time I looked at
Edgar, it was all individual filings, and different formats.
On Fri, Mar 29, 2019 at 6:28 AM jchyjun@... wrote:
>
> Randy has helped a lot of d-i-y investors with his famous Stock Market
> Functions Add-in. At the same time we observed trend of converting free
> financial data into subscribe-based businesses, which is OK because most of
> data providers are for-profit companies. Unfortunately many small investors
> cannot afford subscribtion(s), so usability of SMF decreases.
> Nevertheless where are non-profit organizations that still provide (and
> will provide) free financial data (e.g. SEC with their EDGAR WWW site -
> https://www.sec.gov/edgar/searchedgar/companysearch.html).
> <https://www.sec.gov/edgar/searchedgar/companysearch.html> which
> by-the-way is original (and so most reliable) source of information.
>
> I'd strongly appreciate if Randy and other computer savvy members of
> smf_addin group develop SMF elements and arrays that allows extract
> multi-years financial data EDGAR WWW site. IMHO it will be extremely
> helpful for all d-i-y investors.
>
>
>
Edgar, it was all individual filings, and different formats.
On Fri, Mar 29, 2019 at 6:28 AM jchyjun@... wrote:
>
> Randy has helped a lot of d-i-y investors with his famous Stock Market
> Functions Add-in. At the same time we observed trend of converting free
> financial data into subscribe-based businesses, which is OK because most of
> data providers are for-profit companies. Unfortunately many small investors
> cannot afford subscribtion(s), so usability of SMF decreases.
> Nevertheless where are non-profit organizations that still provide (and
> will provide) free financial data (e.g. SEC with their EDGAR WWW site -
> https://www.sec.gov/edgar/searchedgar/companysearch.html).
> <https://www.sec.gov/edgar/searchedgar/companysearch.html> which
> by-the-way is original (and so most reliable) source of information.
>
> I'd strongly appreciate if Randy and other computer savvy members of
> smf_addin group develop SMF elements and arrays that allows extract
> multi-years financial data EDGAR WWW site. IMHO it will be extremely
> helpful for all d-i-y investors.
>
>
>
Fri Mar 29, 2019 7:02 am (PDT) . Posted by:
gz_cp
Do you know if GuruFocus have historical data of the underlying indices of ETFs, such as the ICE U.S. Treasury 20+ Year Bond Index for TLT?
Thanks.
Thanks.
Fri Mar 29, 2019 8:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry. No idea. I don't use their historical quotes because it isn't
adjusted for dividends.
On Fri, Mar 29, 2019 at 7:02 AM gz_cp@... wrote:
>
> Do you know if GuruFocus have historical data of the underlying indices
> of ETFs, such as the ICE U.S. Treasury 20+ Year Bond Index for TLT?
>
>
>
adjusted for dividends.
On Fri, Mar 29, 2019 at 7:02 AM gz_cp@... wrote:
>
> Do you know if GuruFocus have historical data of the underlying indices
> of ETFs, such as the ICE U.S. Treasury 20+ Year Bond Index for TLT?
>
>
>
Fri Mar 29, 2019 12:30 pm (PDT) . Posted by:
"Marc Johnson" marclerjohnson
Not sure if this will be of value to you, but Microsoft Office 365 now offers free access to a few Morningstar stock fields from within Excel.
https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54
From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com>
Sent: March 29, 2019 9:27 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Morningstar Data Now Requires Callback Parameter, What Can We Do About It?
Sorry. No idea. I don't use their historical quotes because it isn't adjusted for dividends.
On Fri, Mar 29, 2019 at 7:02 AM gz_cp@... wrote:
Do you know if GuruFocus have historical data of the underlying indices of ETFs, such as the ICE U.S. Treasury 20+ Year Bond Index for TLT?
https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54
From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com>
Sent: March 29, 2019 9:27 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Morningstar Data Now Requires Callback Parameter, What Can We Do About It?
Sorry. No idea. I don't use their historical quotes because it isn't adjusted for dividends.
On Fri, Mar 29, 2019 at 7:02 AM gz_cp@... wrote:
Do you know if GuruFocus have historical data of the underlying indices of ETFs, such as the ICE U.S. Treasury 20+ Year Bond Index for TLT?
Fri Mar 29, 2019 2:08 pm (PDT) . Posted by:
descormiersg@videotron.ca
I
Is there a way to obtain the currency change ? I tried this
RCHGetElementNumber("CAD=X";15)
Is there another way.
Thanks in advance
Guy
Is there a way to obtain the currency change ? I tried this
RCHGetElementNumber
Is there another way.
Thanks in advance
Guy
Fri Mar 29, 2019 2:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Use the smfGetYahooPortfolioView() function.
On Fri, Mar 29, 2019 at 2:08 PM descormiersg@... wrote:
>
>
> Is there a way to obtain the currency change ? I tried this
>
> RCHGetElementNumber("CAD=X";15)
>
>
>
> Is there another way.
>
>
>
>
>
On Fri, Mar 29, 2019 at 2:08 PM descormiersg@
>
>
> Is there a way to obtain the currency change ? I tried this
>
> RCHGetElementNumber
>
>
>
> Is there another way.
>
>
>
>
>
Fri Mar 29, 2019 2:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Also, I think your ticker symbol needs two country codes to get an exchange
rate...
On Fri, Mar 29, 2019 at 2:08 PM descormiersg@... wrote:
>
>
> Is there a way to obtain the currency change ? I tried this
>
> RCHGetElementNumber("CAD=X";15)
>
>
>
> Is there another way.
>
>
>
rate...
On Fri, Mar 29, 2019 at 2:08 PM descormiersg@
>
>
> Is there a way to obtain the currency change ? I tried this
>
> RCHGetElementNumber
>
>
>
> Is there another way.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
