Jumat, 10 Juli 2015

[smf_addin] Digest Number 3453

7 Messages

Digest #3453

Messages

Thu Jul 9, 2015 5:26 am (PDT) . Posted by:

"J@Y" g3m1n1980


Im getting #NAME for each cell on the new gurufocus test you created.

Wondering if it has to do with me not being a "premium" member of guru focus.

I do however get results when I use this

=RCHGetTableCell("http://www.gurufocus.com/financials/"&$A1&"",3,">revenue per share",,,,5,"</table",,"--")

The problem is the cells shift left and right for companies younger than 15 years old.

Any ideas?


-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Wed, Jul 8, 2015 9:53 pm
Subject: Re: [smf_addin] Hoping to only retrieve 10 years of Gurufocus financial data

I've added a new experimental function to the add-in -- smfGetGuruFocusItem(). Two new files can be found in the "Works in Progress" folder on the SMF add-in website, as:

RCH_Stock_Market_Functions-2.1.2015.07.08.zip

smfGetGuruFocusItem-Full-Template.xls


The new function can return data for 185 data items, some that only apply to financial institutions. The function can return the label, the TTM value, or the fiscal year or fiscal quarter values for a given data item. For example:

=smfGetGuruFocusItem(Ticker,1,"L")
=smfGetGuruFocusItem(Ticker,1,"TTM";)
=smfGetGuruFocusItem(Ticker,1,"A",0)
=smfGetGuruFocusItem(Ticker,1,"Q",0)


...would return data items for "Revenue per share". The last two items would be FY0 and FQ0, the most recent fiscal year and fiscal quarter results. Fiscal years would typically range from 0 to 14 and fiscal quarters would typically range from 0 to 8. For logged in premium members, anyway. Non-premium members are now limited to 5 fiscal years of data.




I'm hoping it will return "Premium" for premium data items that are only available to logged in members. It should return "N/A" for data items that are beyond the existing history of a company.


Advance warning -- the template has nearly 5000 data item retrievals and takes me nearly a minute to load. All formulas are hard-coded like the examples above, with the ticker symbol being the only cell reference in the formula. That should make copying and pasting easier. Most of you probably only want small sections, instead of all 5000 data items. :)

Let me know if you run into any discrepancies, or if I missed some data items on the 15-year display. I compared a number of results to the 20-year download file they have for members and most matched. Those that didn't had values to more decimal places in the 20-year file, but matched when I rounded them off.
























Thu Jul 9, 2015 6:06 am (PDT) . Posted by:

sirons1962

This works great! Thank you!

I do have a question on the quarterly data, is there a way to retrieve beyond the 9 quarters with the simpler format you have? Since I am a premium member I can get the data using this for the Revenue for Dec12:

=smfConvertData(smfGetTagContent("http://www.gurufocus.com/modules/financials/quarterly_iframe.php?symbol="&ticker&";&is","td",-10,">Revenue";,"<tr"))

If not I'll stick with this as it's working.

Thu Jul 9, 2015 6:33 am (PDT) . Posted by:

"J@Y" g3m1n1980


Answered my own question.

Got it working.

Great work

Jason


-----Original Message-----
From: 'J@Y' xxjaysonxx@aol.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Thu, Jul 9, 2015 8:26 am
Subject: Re: [smf_addin] Hoping to only retrieve 10 years of Gurufocus financial data

Im getting #NAME for each cell on the new gurufocus test you created.



Wondering if it has to do with me not being a "premium" member of guru focus.



I do however get results when I use this



=RCHGetTableCell(" http://www.gurufocus.com/financials/"&$A1&"",3,">revenue per share",,,,5,"</table",,"--")



The problem is the cells shift left and right for companies younger than 15 years old.



Any ideas?





-----Original Message-----
From: Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Wed, Jul 8, 2015 9:53 pm
Subject: Re: [smf_addin] Hoping to only retrieve 10 years of Gurufocus financial data












I've added a new experimental function to the add-in -- smfGetGuruFocusItem(). Two new files can be found in the "Works in Progress" folder on the SMF add-in website, as:

RCH_Stock_Market_Functions-2.1.2015.07.08.zip

smfGetGuruFocusItem-Full-Template.xls


The new function can return data for 185 data items, some that only apply to financial institutions. The function can return the label, the TTM value, or the fiscal year or fiscal quarter values for a given data item. For example:

=smfGetGuruFocusItem(Ticker,1,"L")
=smfGetGuruFocusItem(Ticker,1,"TTM";)
=smfGetGuruFocusItem(Ticker,1,"A",0)
=smfGetGuruFocusItem(Ticker,1,"Q",0)


...would return data items for "Revenue per share". The last two items would be FY0 and FQ0, the most recent fiscal year and fiscal quarter results. Fiscal years would typically range from 0 to 14 and fiscal quarters would typically range from 0 to 8. For logged in premium members, anyway. Non-premium members are now limited to 5 fiscal years of data.




I'm hoping it will return "Premium" for premium data items that are only available to logged in members. It should return "N/A" for data items that are beyond the existing history of a company.


Advance warning -- the template has nearly 5000 data item retrievals and takes me nearly a minute to load. All formulas are hard-coded like the examples above, with the ticker symbol being the only cell reference in the formula. That should make copying and pasting easier. Most of you probably only want small sections, instead of all 5000 data items. :)

Let me know if you run into any discrepancies, or if I missed some data items on the 15-year display. I compared a number of results to the 20-year download file they have for members and most matched. Those that didn't had values to more decimal places in the 20-year file, but matched when I rounded them off.

































Thu Jul 9, 2015 7:49 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'd rather avoid that page for the function, since only premium members can
get it.

If you use their CSV (or XLS) file, you can get 20 years of annual and
quarterly data...for example:

=smfGetCSVFile("
http://www.gurufocus.com/download_financials_in_CSV.php?symbol=MMM")

On Thu, Jul 9, 2015 at 6:05 AM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> This works great! Thank you!
>
> I do have a question on the quarterly data, is there a way to retrieve
> beyond the 9 quarters with the simpler format you have? Since I am a
> premium member I can get the data using this for the Revenue for Dec12:
>
> =smfConvertData(smfGetTagContent("
> http://www.gurufocus.com/modules/financials/quarterly_iframe.php?symbol=
> "&ticker&";&is","td",-10,">Revenue";,"<tr"))
>
> If not I'll stick with this as it's working.
>

Thu Jul 9, 2015 3:27 pm (PDT) . Posted by:

sirons1962

No problem Randy. Thanks for responding and for all the work you put into this.

Thu Jul 9, 2015 1:20 pm (PDT) . Posted by:

trendsekr

=smfGetOptionQuotes("splk 7/17 2015 $70 Call", "%") gives me "Unrecognized item ID: %".

Documentation says it should return % Change.

Suggestions?


Thu Jul 9, 2015 1:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

% Change is not available from Yahoo. You can get it from Google:

=smfGetOptionQuotes("splk 7/17 2015 $70 Call", "%",,"G")

On Thu, Jul 9, 2015 at 1:20 PM, trendsekr@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> =smfGetOptionQuotes("splk 7/17 2015 $70 Call", "%") gives me "Unrecognized
> item ID: %".
>
> Documentation says it should return % Change.
>
> Suggestions?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.05

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)