8 Messages
Digest #3936
Messages
Tue Mar 7, 2017 8:15 am (PST) . Posted by:
shane.kelly2222
Hi All,
I am trying to build a spreadsheet to retrieve the income, cash and balance statements from whichever web site i can get the most years of free data, for a list of stocks.
For a start, I grabbed the template "SMF-Template-Google-Income-Statement-Tables", and "SMF-Template-Morningstar-Key-Ratios". I attached one of these to show my result.
I am getting all "error" returns on retrieved values, without making any changes. I'm sure this has been asked before but i could not find anything that explains it for me. your help would be appreciated.
I have tested to see if my installation is correct by using the =RCHGetElementNumber("Version") formula, and provided I point the add-in to the correct location, that component works.
VersionStock Market Functions add-in, Version 2.1.2017.02.15 (C:\SMF Add-in; Windows (64-bit) NT 6.02; 15.0; www; Local; 61)".
I am running Windows 8, and excel 2013.
Thanks
Shane
I am trying to build a spreadsheet to retrieve the income, cash and balance statements from whichever web site i can get the most years of free data, for a list of stocks.
For a start, I grabbed the template "SMF-Template-
I am getting all "error" returns on retrieved values, without making any changes. I'm sure this has been asked before but i could not find anything that explains it for me. your help would be appreciated.
I have tested to see if my installation is correct by using the =RCHGetElementNumbe
VersionStock Market Functions add-in, Version 2.1.2017.02.
I am running Windows 8, and excel 2013.
Thanks
Shane
Attachment(s) from
1 of 1 Photo(s)
Tue Mar 7, 2017 8:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. I just opened the Google workbook from the web site and it's
populating for me when I use "goog" as the ticker symbol. What do you see
as the formula in cell C3? I see:
=RCHGetElementNumber(Ticker, 3308)
On Tue, Mar 7, 2017 at 6:30 AM, skelly22@
...wrote:
> Hi All,
>
> I am trying to build a spreadsheet to retrieve the income, cash and
> balance statements from whichever web site i can get the most years of free
> data, for a list of stocks.
>
> For a start, I grabbed the template "SMF-Template-Google-Income-Statement-Tables",
> and "SMF-Template-Morningstar-Key-Ratios". I attached one of these to
> show my result.
>
> I am getting all "error" returns on retrieved values, without making any
> changes. I'm sure this has been asked before but i could not find anything
> that explains it for me. your help would be appreciated.
>
> I have tested to see if my installation is correct by using the *=RCHGetElementNumber("Version")
> *formula, and provided I point the add-in to the correct location, that
> component works.
>
> VersionStock Market Functions add-in, Version 2.1.2017.02.15 (C:\SMF
> Add-in; Windows (64-bit) NT 6.02; 15.0; www; Local; 61)".
>
> I am running Windows 8, and excel 2013.
>
>
populating for me when I use "goog" as the ticker symbol. What do you see
as the formula in cell C3? I see:
=RCHGetElementNumbe
On Tue, Mar 7, 2017 at 6:30 AM, skelly22@
...wrote:
> Hi All,
>
> I am trying to build a spreadsheet to retrieve the income, cash and
> balance statements from whichever web site i can get the most years of free
> data, for a list of stocks.
>
> For a start, I grabbed the template "SMF-Template-
> and "SMF-Template-
> show my result.
>
> I am getting all "error" returns on retrieved values, without making any
> changes. I'm sure this has been asked before but i could not find anything
> that explains it for me. your help would be appreciated.
>
> I have tested to see if my installation is correct by using the *=RCHGetElementNumb
> *formula, and provided I point the add-in to the correct location, that
> component works.
>
> VersionStock Market Functions add-in, Version 2.1.2017.02.
> Add-in; Windows (64-bit) NT 6.02; 15.0; www; Local; 61)".
>
> I am running Windows 8, and excel 2013.
>
>
Tue Mar 7, 2017 5:04 pm (PST) . Posted by:
shane.kelly2222
Hi Randy,
i just checked the same spreadsheet when i got to work and it retrieves the values fine for nearly all companies i have checked which is great. I must have a bad plugin install on my home PC. I will check it a again when I get home and re-install. thanks for getting back to me!!
Shane
i just checked the same spreadsheet when i got to work and it retrieves the values fine for nearly all companies i have checked which is great. I must have a bad plugin install on my home PC. I will check it a again when I get home and re-install. thanks for getting back to me!!
Shane
Tue Mar 7, 2017 12:36 pm (PST) . Posted by:
gbullr
Randy: Help again:
Site:
https://www.investing.com/commodities/crude-oil-contracts https://www.investing.com/commodities/crude-oil-contracts
Formula:
=rchgethtmltable("https://www.investing.com/commodities/crude-oil-contracts","Month")
Results:
Blank,
I have tried to put in Cash Crude Oil and other things where Month is.
Thank you very much for your help.
Site:
https://www.investing.com/commodities/crude-oil-contracts https://www.investing.com/commodities/crude-oil-contracts
Formula:
=rchgethtmltable("https://www.investing.com/commodities/crude-oil-contracts","
Results:
Blank,
I have tried to put in Cash Crude Oil and other things where Month is.
Thank you very much for your help.
Tue Mar 7, 2017 2:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
"Month" is not a good search term because it occurs several times on the
web page before the table. Try:
=rchgethtmltable("https://www.investing.com/commodities/crude-oil-contracts
",">Chg.")
On Tue, Mar 7, 2017 at 1:36 PM, gaston.bullrich@
...wrote:
> Randy: Help again:
>
> Site:
>
> https://www.investing.com/commodities/crude-oil-contracts
>
> Formula:
>
> =rchgethtmltable("https://www.investing.com/commodities/
> crude-oil-contracts","Month")
>
> Results:
>
> Blank,
>
> I have tried to put in Cash Crude Oil and other things where Month is.
>
> Thank you very much for your help.
>
>
web page before the table. Try:
=rchgethtmltable("https://www.investing.com/commodities/crude-oil-contracts
",">Chg.")
On Tue, Mar 7, 2017 at 1:36 PM, gaston.bullrich@
...wrote:
> Randy: Help again:
>
> Site:
>
> https://www.investing.com/commodities/crude-oil-contracts
>
> Formula:
>
> =rchgethtmltable("https://www.investing.com/commodities/
> crude-oil-contracts
>
> Results:
>
> Blank,
>
> I have tried to put in Cash Crude Oil and other things where Month is.
>
> Thank you very much for your help.
>
>
Tue Mar 7, 2017 2:49 pm (PST) . Posted by:
"Allan" aprivoisermoi2005
I see Yahoo company income and balance sheet data (missing on google
finance) for companies without a smf retreaval function. Are these
unsupported by smf?
i.e.
http://finance.yahoo.com/quote/LIND/financials?p=LIND
I'm aware of the YahooKS (Key Statistics) functions...
--
Allan
finance) for companies without a smf retreaval function. Are these
unsupported by smf?
i.e.
http://finance.yahoo.com/quote/LIND/financials?p=LIND
I'm aware of the YahooKS (Key Statistics) functions...
--
Allan
Tue Mar 7, 2017 3:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yahoo financial data items are "unsupported" to the extent there are only a
few defined elements. However, there is a template on the Yahoo group:
https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-Yahoo-Financial-Statements.xls
But that does use an older Yahoo page that they may remove. Unfortunately,
the web page you quoted does not have the data within it. It is a generated
web page. The actual data to fill the web page is done via an API call that
returns JSON data:l
https://query1.finance.yahoo.com/v10/finance/quoteSummary/LIND?formatted=true&modules=incomeStatementHistory%2CcashflowStatementHistory%2CbalanceSheetHistory%2CincomeStatementHistoryQuarterly%2CcashflowStatementHistoryQuarterly%2CbalanceSheetHistoryQuarterly%2Cearnings
Difficult to extract from.
I tend to avoid Google and Yahoo for financials, because they have so few
time periods. I also don't like the way Yahoo pigeon-holes the data (e.g.
"Restricted cash" is included within "Cash and Equivalents").
Google financials templates are on the web site:
http://ogres-crypt.com/SMF/Templates/#Google
On Tue, Mar 7, 2017 at 3:14 PM, Allan allanhasmail@
...wrote:
> I see Yahoo company income and balance sheet data (missing on google
> finance) for companies without a smf retreaval function. Are these
> unsupported by smf?
>
> i.e.
>
> http://finance.yahoo.com/quote/LIND/financials?p=LIND
>
> I'm aware of the YahooKS (Key Statistics) functions...
>
few defined elements. However, there is a template on the Yahoo group:
https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-Yahoo-Financial-Statements.xls
But that does use an older Yahoo page that they may remove. Unfortunately,
the web page you quoted does not have the data within it. It is a generated
web page. The actual data to fill the web page is done via an API call that
returns JSON data:l
https://query1.finance.yahoo.com/v10/finance/quoteSummary/LIND?formatted=true&modules=incomeStatementHistory%2CcashflowStatementHistory%2CbalanceSheetHistory%2CincomeStatementHistoryQuarterly%2CcashflowStatementHistoryQuarterly%2CbalanceSheetHistoryQuarterly%2Cearnings
Difficult to extract from.
I tend to avoid Google and Yahoo for financials, because they have so few
time periods. I also don't like the way Yahoo pigeon-holes the data (e.g.
"Restricted cash" is included within "Cash and Equivalents").
Google financials templates are on the web site:
http://ogres-crypt.com/SMF/Templates/#Google
On Tue, Mar 7, 2017 at 3:14 PM, Allan allanhasmail@
...wrote:
> I see Yahoo company income and balance sheet data (missing on google
> finance) for companies without a smf retreaval function. Are these
> unsupported by smf?
>
> i.e.
>
> http://finance.yahoo.com/quote/LIND/financials?p=LIND
>
> I'm aware of the YahooKS (Key Statistics) functions...
>
Tue Mar 7, 2017 4:47 pm (PST) . Posted by:
"Allan" aprivoisermoi2005
A template, eh? Wow! Look at that! Thank you, that's awesome Randy.
There may be better data, but for me, this is a start.
Allan
On 03/07/2017 05:25 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> Yahoo financial data items are "unsupported" to the extent there are
> only a few defined elements. However, there is a template on the Yahoo
> group:
>
> https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-Yahoo-Financial-Statements.xls
>
> But that does use an older Yahoo page that they may remove.
> Unfortunately, the web page you quoted does not have the data within
> it. It is a generated web page. The actual data to fill the web page
> is done via an API call that returns JSON data:l
>
> https://query1.finance.yahoo.com/v10/finance/quoteSummary/LIND?formatted=true&modules=incomeStatementHistory%2CcashflowStatementHistory%2CbalanceSheetHistory%2CincomeStatementHistoryQuarterly%2CcashflowStatementHistoryQuarterly%2CbalanceSheetHistoryQuarterly%2Cearnings
>
> Difficult to extract from.
>
> I tend to avoid Google and Yahoo for financials, because they have so
> few time periods. I also don't like the way Yahoo pigeon-holes the
> data (e.g. "Restricted cash" is included within "Cash and Equivalents").
>
> Google financials templates are on the web site:
>
> http://ogres-crypt.com/SMF/Templates/#Google
>
>
>
>
>
> On Tue, Mar 7, 2017 at 3:14 PM, Allan allanhasmail@
> ...wrote:
>
> I see Yahoo company income and balance sheet data (missing on google
> finance) for companies without a smf retreaval function. Are these
> unsupported by smf?
>
> i.e.
>
> http://finance.yahoo.com/quote/LIND/financials?p=LIND
> <http://finance.yahoo.com/quote/LIND/financials?p=LIND>
>
> I'm aware of the YahooKS (Key Statistics) functions...
>
>
>
There may be better data, but for me, this is a start.
Allan
On 03/07/2017 05:25 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> Yahoo financial data items are "unsupported" to the extent there are
> only a few defined elements. However, there is a template on the Yahoo
> group:
>
> https://groups.yahoo.com/neo/groups/smf_addin/files/Templates%20and%20Examples/RCHGetTableCell/RCHGetTableCell-Template-Yahoo-Financial-Statements.xls
>
> But that does use an older Yahoo page that they may remove.
> Unfortunately, the web page you quoted does not have the data within
> it. It is a generated web page. The actual data to fill the web page
> is done via an API call that returns JSON data:l
>
> https://query1.finance.yahoo.com/v10/finance/quoteSummary/LIND?formatted=true&modules=incomeStatementHistory%2CcashflowStatementHistory%2CbalanceSheetHistory%2CincomeStatementHistoryQuarterly%2CcashflowStatementHistoryQuarterly%2CbalanceSheetHistoryQuarterly%2Cearnings
>
> Difficult to extract from.
>
> I tend to avoid Google and Yahoo for financials, because they have so
> few time periods. I also don't like the way Yahoo pigeon-holes the
> data (e.g. "Restricted cash" is included within "Cash and Equivalents").
>
> Google financials templates are on the web site:
>
> http://ogres-crypt.com/SMF/Templates/#Google
>
>
>
>
>
> On Tue, Mar 7, 2017 at 3:14 PM, Allan allanhasmail@
> ...wrote:
>
> I see Yahoo company income and balance sheet data (missing on google
> finance) for companies without a smf retreaval function. Are these
> unsupported by smf?
>
> i.e.
>
> http://finance.yahoo.com/quote/LIND/financials?p=LIND
> <http://finance.yahoo.com/quote/LIND/financials?p=LIND>
>
> I'm aware of the YahooKS (Key Statistics) functions...
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar