8 Messages
Digest #4349
2b
Re: What would be the formula using the smfGetTagContent function to by "Randy Harmelink" rharmelink
2d
Re: What would be the formula using the smfGetTagContent function to by "Randy Harmelink" rharmelink
Messages
Wed Jun 27, 2018 5:42 am (PDT) . Posted by:
"Carl Mims" aab3c65c4611ee62fa3f26b79f046867
Randy
Is there another place on yahoo to pull from other than YahooKS that might be updated
Where does the YahooJSON pull from and is there documentation to go from that will give me the syntax similar to Inventory below?
Carl
> On Jun 26, 2018, at 11:04 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> My better place would be GuruFocus, but I am a subscriber. I don't really do much with fundamental data these days outside of GuruFocus and Portfolio123.
>
> On Tue, Jun 26, 2018 at 6:30 PM, Carl Mims carlmims@
> ...
> wrote:
>
> Simply using your element # listed from the YahooKS area of your document sheet.
>
> 950 Fiscal Year End for example =RCHGetElementNumber(PIK.F,950)
> 956 Revenue
> 959 Cost of Goods
> 961 Net Income
> Inventories = =smfGetYahooJSONField(PIK.F,"balanceSheetHistory","quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.0.inventory.raw") You gave me this
> 954 Assets
> 954 Equity
>
> That is all I am getting for about 1,000 symbols over the course of a year. I am now running into a number of examples where they website finance.yahoo.com <http://finance.yahoo.com/> is updated but using the above the most current is a year old.
>
> Is there a better method similar to inventories? Is there a better place rather than Yahoo?
>
>
>
>
Is there another place on yahoo to pull from other than YahooKS that might be updated
Where does the YahooJSON pull from and is there documentation to go from that will give me the syntax similar to Inventory below?
Carl
> On Jun 26, 2018, at 11:04 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> My better place would be GuruFocus, but I am a subscriber. I don't really do much with fundamental data these days outside of GuruFocus and Portfolio123.
>
> On Tue, Jun 26, 2018 at 6:30 PM, Carl Mims carlmims@
> ...
> wrote:
>
> Simply using your element # listed from the YahooKS area of your document sheet.
>
> 950 Fiscal Year End for example =RCHGetElementNumber(PIK.F,950)
> 956 Revenue
> 959 Cost of Goods
> 961 Net Income
> Inventories = =smfGetYahooJSONField(PIK.F,"balanceSheetHistory","quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.0.inventory.raw") You gave me this
> 954 Assets
> 954 Equity
>
> That is all I am getting for about 1,000 symbols over the course of a year. I am now running into a number of examples where they website finance.yahoo.com <http://finance.yahoo.com/> is updated but using the above the most current is a year old.
>
> Is there a better method similar to inventories? Is there a better place rather than Yahoo?
>
>
>
>
Wed Jun 27, 2018 9:44 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I have a workbook on the add-in website that lists all the JSON fields I
was able to find:
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls
For example, that workbook had these for raw inventory numbers:
*Module* *Usable field name*
balanceSheetHistory
quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.0.inventory.raw
balanceSheetHistory
quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.1.inventory.raw
balanceSheetHistory
quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.2.inventory.raw
balanceSheetHistoryQuarterly
quoteSummary.result.0.balanceSheetHistoryQuarterly.balanceSheetStatements.0.inventory.raw
balanceSheetHistoryQuarterly
quoteSummary.result.0.balanceSheetHistoryQuarterly.balanceSheetStatements.1.inventory.raw
balanceSheetHistoryQuarterly
quoteSummary.result.0.balanceSheetHistoryQuarterly.balanceSheetStatements.2.inventory.raw
balanceSheetHistoryQuarterly
quoteSummary.result.0.balanceSheetHistoryQuarterly.balanceSheetStatements.3.inventory.raw
On Wed, Jun 27, 2018 at 5:42 AM, Carl Mims carlmims@
...
wrote:
>
> Is there another place on yahoo to pull from other than YahooKS that might
> be updated
>
> Where does the YahooJSON pull from and is there documentation to go from
> that will give me the syntax similar to Inventory below?
>
>
>
was able to find:
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls
For example, that workbook had these for raw inventory numbers:
*Module* *Usable field name*
balanceSheetHistory
quoteSummary.
balanceSheetHistory
quoteSummary.
balanceSheetHistory
quoteSummary.
balanceSheetHistory
quoteSummary.
balanceSheetHistory
quoteSummary.
balanceSheetHistory
quoteSummary.
balanceSheetHistory
quoteSummary.
On Wed, Jun 27, 2018 at 5:42 AM, Carl Mims carlmims@
...
wrote:
>
> Is there another place on yahoo to pull from other than YahooKS that might
> be updated
>
> Where does the YahooJSON pull from and is there documentation to go from
> that will give me the syntax similar to Inventory below?
>
>
>
Wed Jun 27, 2018 11:44 am (PDT) . Posted by:
"Carl Mims" aab3c65c4611ee62fa3f26b79f046867
Randy
Thanks for the workbook. It will help a lot.
Do you know if the JSON fields pull from a different place than the YahooKS? Therefore might be updated and match the website.
Carl
> On Jun 27, 2018, at 10:44 AM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> I have a workbook on the add-in website that lists all the JSON fields I was able to find:
>
> http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls <http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls>
>
> For example, that workbook had these for raw inventory numbers:
>
> Module Usable field name
> balanceSheetHistory quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements..0.inventory.raw
> balanceSheetHistory quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.1.inventory.raw
> balanceSheetHistory quoteSummary.result.0.balanceSheetHistory.balanceSheetStatements.2.inventory.raw
> balanceSheetHistoryQuarterly quoteSummary.result.0.balanceSheetHistoryQuarterly.balanceSheetStatements.0.inventory.raw
> balanceSheetHistoryQuarterly quoteSummary.result.0.balanceSheetHistoryQuarterly.balanceSheetStatements.1.inventory.raw
> balanceSheetHistoryQuarterly quoteSummary.result.0.balanceSheetHistoryQuarterly.balanceSheetStatements.2.inventory.raw
> balanceSheetHistoryQuarterly quoteSummary.result.0.balanceSheetHistoryQuarterly.balanceSheetStatements.3.inventory.raw
>
>
>
> On Wed, Jun 27, 2018 at 5:42 AM, Carl Mims carlmims@
> ...
> wrote:
>
> Is there another place on yahoo to pull from other than YahooKS that might be updated
>
> Where does the YahooJSON pull from and is there documentation to go from that will give me the syntax similar to Inventory below?
>
>
>
>
Thanks for the workbook. It will help a lot.
Do you know if the JSON fields pull from a different place than the YahooKS? Therefore might be updated and match the website.
Carl
> On Jun 27, 2018, at 10:44 AM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> I have a workbook on the add-in website that lists all the JSON fields I was able to find:
>
> http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls <http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls>
>
> For example, that workbook had these for raw inventory numbers:
>
> Module Usable field name
> balanceSheetHistory quoteSummary.
> balanceSheetHistory quoteSummary.
> balanceSheetHistory quoteSummary.
> balanceSheetHistory
> balanceSheetHistory
> balanceSheetHistory
> balanceSheetHistory
>
>
>
> On Wed, Jun 27, 2018 at 5:42 AM, Carl Mims carlmims@
> ...
> wrote:
>
> Is there another place on yahoo to pull from other than YahooKS that might be updated
>
> Where does the YahooJSON pull from and is there documentation to go from that will give me the syntax similar to Inventory below?
>
>
>
>
Wed Jun 27, 2018 2:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I have no idea where Yahoo gets the data that populates the Key Statistics
web pages or the JSON files. I know they calculate some of the Key
Statistics data items themselves. And some incorrectly. For example, the
50-day and 200-day moving averages are based on calendar days, not trading
days, so they won't match another 50-day and 200-day moving averages I know
of.
On Wed, Jun 27, 2018 at 11:44 AM, Carl Mims carlmims@
...
wrote:
>
> Thanks for the workbook. It will help a lot.
>
> Do you know if the JSON fields pull from a different place than the
> YahooKS? Therefore might be updated and match the website.
>
>
>
web pages or the JSON files. I know they calculate some of the Key
Statistics data items themselves. And some incorrectly. For example, the
50-day and 200-day moving averages are based on calendar days, not trading
days, so they won't match another 50-day and 200-day moving averages I know
of.
On Wed, Jun 27, 2018 at 11:44 AM, Carl Mims carlmims@
...
wrote:
>
> Thanks for the workbook. It will help a lot.
>
> Do you know if the JSON fields pull from a different place than the
> YahooKS? Therefore might be updated and match the website.
>
>
>
Wed Jun 27, 2018 8:18 am (PDT) . Posted by:
zbgb952
Hello Randy,
For some reason, when I tried both of these formulas that you suggested, Excel give me Error .
1. Why would this be?
2. How would I use these formulas having them point to a stock symbol in Excel...say, in D12 ? ...
and..
3. Can I use the RCHGetElementNumber function to get dividend yield, and if so, what would that be? This may be the simplest form.
Thanks.
Sorry for all the questions but I find that things get harder as I get older.
For some reason, when I tried both of these formulas that you suggested, Excel give me Error .
1. Why would this be?
2. How would I use these formulas having them point to a stock symbol in Excel...say, in D12 ? ...
and..
3. Can I use the RCHGetElementNumber function to get dividend yield, and if so, what would that be? This may be the simplest form.
Thanks.
Sorry for all the questions but I find that things get harder as I get older.
Wed Jun 27, 2018 9:55 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know why they would give you "Error". They both work fine here.
You would need to concatenate strings to reference a cell. That's basic
EXCEL:
="https://finviz.com/quote.ashx?t="&D12
The reason the element definitions workbook is out there is so you can look
those things up yourself:
*#* *Usage* *Source* *Element*
990 S YahooKS Dividend Yield
2183 S IBDQ Dividend Yield
4925 S YahooKS Forward Annual Dividend Yield
4927 S YahooKS Trailing Annual Dividend Yield
4928 S YahooKS 5 Year Average Dividend Yield
13666 SE ReutersRat Comparison Ratios -- Dividends -- Dividend Yield --
Company
13935 S MorningstarCV Valuation Ratios -- Dividend Yield -- Stock -- Current
14488 S MorningstarCV2 Dividend Yield % - Stock
15013 S Calculated Magic Formula Investing -- Earnings Yield
Most people would use #4925.
On Wed, Jun 27, 2018 at 8:18 AM, mb0329@
...
wrote:
>
> For some reason, when I tried both of these formulas that you suggested,
> Excel give me Error .
> 1. Why would this be?
>
> 2. How would I use these formulas having them point to a stock symbol in
> Excel...say, in D12 ? ...
> and..
>
> 3. Can I use the RCHGetElementNumber function to get dividend yield,
> and if so, what would that be? This may be the simplest form.
>
> Thanks.
>
> Sorry for all the questions but I find that things get harder as I get
> older.
>
>
You would need to concatenate strings to reference a cell. That's basic
EXCEL:
="https://finviz.com/quote.ashx?t="&D12
The reason the element definitions workbook is out there is so you can look
those things up yourself:
*#* *Usage* *Source* *Element*
990 S YahooKS Dividend Yield
2183 S IBDQ Dividend Yield
4925 S YahooKS Forward Annual Dividend Yield
4927 S YahooKS Trailing Annual Dividend Yield
4928 S YahooKS 5 Year Average Dividend Yield
13666 SE ReutersRat Comparison Ratios -- Dividends -- Dividend Yield --
Company
13935 S MorningstarCV Valuation Ratios -- Dividend Yield -- Stock -- Current
14488 S MorningstarCV2 Dividend Yield % - Stock
15013 S Calculated Magic Formula Investing -- Earnings Yield
Most people would use #4925.
On Wed, Jun 27, 2018 at 8:18 AM, mb0329@
...
wrote:
>
> For some reason, when I tried both of these formulas that you suggested,
> Excel give me Error .
> 1. Why would this be?
>
> 2. How would I use these formulas having them point to a stock symbol in
> Excel...say, in D12 ? ...
> and..
>
> 3. Can I use the RCHGetElementNumber function to get dividend yield,
> and if so, what would that be? This may be the simplest form.
>
> Thanks.
>
> Sorry for all the questions but I find that things get harder as I get
> older.
>
>
Wed Jun 27, 2018 1:21 pm (PDT) . Posted by:
zbgb952
Hello Randy, Real weird. It seems like whenever I try to use a function that is for Dividend Yield, I get an error message. For example, I just tried:
=RCHGetElementNumber("aapl", 4925 ) and got "error". However, If i used it for something else, I don't get the error message. What in the world is causing this???
=RCHGetElementNumbe
Wed Jun 27, 2018 2:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That formula works fine for me. What operating system and version of EXCEL
are you using?
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetTableCell("https://finance.yahoo.com/q/ks?s=AAPL",1,"FORWARD ANNUAL
DIVIDEND YIELD")
=RCHGetElementNumber("Definition",4925)
On Wed, Jun 27, 2018 at 1:20 PM, mb0329@
...
wrote:
>
> Hello Randy, Real weird. It seems like whenever I try to use a function
> that is for Dividend Yield, I get an error message. For example, I just
> tried:
>
> =RCHGetElementNumber("aapl", 4925 ) and got "error". However, If i used
> it for something else, I don't get the error message. What in the world is
> causing this???
>
>
are you using?
What do you get with:
=RCHGetElementNumber("Version")
=RCHGetTableCell("https://finance.yahoo.com/q/ks?s=AAPL",1,"
DIVIDEND YIELD")
=RCHGetElementNumbe
On Wed, Jun 27, 2018 at 1:20 PM, mb0329@
...
wrote:
>
> Hello Randy, Real weird. It seems like whenever I try to use a function
> that is for Dividend Yield, I get an error message. For example, I just
> tried:
>
> =RCHGetElementNumbe
> it for something else, I don't get the error message. What in the world is
> causing this???
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar