Minggu, 03 Mei 2015

[smf_addin] Digest Number 3397

7 Messages

Digest #3397
1b
Re: ADVFN 10 yr financial statements. by "Randy Harmelink" rharmelink
2a
Re: Sector by woodburydance
2b
Re: Sector by "Randy Randall" randyr_cds
2c
Re: Sector by "Randy Harmelink" rharmelink
3b

Messages

Sat May 2, 2015 8:41 am (PDT) . Posted by:

savickaslukas

Is there a way to get annual financial statements ? Including 2014 yr. Because it doesn't work for me. None of the templates do work.

Sat May 2, 2015 8:46 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You'll need the latest beta version of the add-in to access AdvFN web pages.

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28118

I'd also suggest taking a look at the GuruFocus models in the "Uploads by
Forum Members" folder in the FILES area of the Yahoo group. But custom
formulas can be used to grab financial statements data from a number of
data sources.

On Sat, May 2, 2015 at 8:33 AM, savickaslukas@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Is there a way to get annual financial statements ? Including 2014 yr.
> Because it doesn't work for me. None of the templates do work.
>

Sat May 2, 2015 9:21 am (PDT) . Posted by:

woodburydance

Using Zacks (850) for 72 stocks I get 44 different sectors:


AEROSPACE/DEFENSE AGRICULTURE/PRODUCTS AUTO -FOREIGN BANKS-MAJOR REGIONAL BEVERAGES-SOFT COMMUNICATIONS COMPONENTS COMP-MINI COMP-SOFTWARE COMP-STORAGE DEV Error FINANCIAL TRANSACTION SERVICES FIN-INVEST BKRS FIN-SVGS & LOAN FOOD-MISC/DIVERSIFIED HOTELS & MOTELS INSTRU-CONTROL INTERNET SERVICES LARGE CAP PHARMA MACH-CONST/MNG MED INSTRUMENTS MED-BIOMED/GENE MED-DRUGS MEDICAL SERVICES MINING -NON FERR OIL & GAS-DRILLING OIL FLD MCH&EQP OIL/GAS PROD PIPELINE MLP OIL-FIELD SVCS OIL-INTL INTGD OIL-US INTEGRTD POLLUTION CNTRL REIT-EQTY TRUST -OTHER REIT-MTGE TRUST RETAIL-DRUG STR RETAIL-RESTRNTS SEMI-ANALOG & MIXED SEMI-GENERAL SOAP&CLNG PREPS STEEL-PRODUCERS TOBACCO TRANS-AIR FRGHT TRANS-SHIP WIRELESS EQUIPMENT WIRELESS NATIONAL


I could just take the left most characters until I get a " " or a "-" and that would get me down to 29 categories. None of my stocks are trading below $5 and I am using this function for my results: =RCHGetElementNumber({Symbol Cell},850)


Bruce

Sat May 2, 2015 9:28 am (PDT) . Posted by:

"Randy Randall" randyr_cds

Bruce -

It seems as if you want sectors (Element 13896) instead of industries
(Element 850).

Randy Randall

On Sat, May 2, 2015 at 12:21 PM, bameyer@optonline.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Using Zacks (850) for 72 stocks I get 44 different sectors:
>
>
> AEROSPACE/DEFENSE AGRICULTURE/PRODUCTS AUTO
> -FOREIGN BANKS-MAJOR REGIONAL BEVERAGES-SOFT COMMUNICATIONS COMPONENTS
> COMP-MINI COMP-SOFTWARE COMP-STORAGE DEV Error FINANCIAL TRANSACTION
> SERVICES FIN-INVEST BKRS FIN-SVGS & LOAN FOOD-MISC/DIVERSIFIED HOTELS &
> MOTELS INSTRU-CONTROL INTERNET SERVICES LARGE CAP PHARMA MACH-CONST/MNG MED
> INSTRUMENTS MED-BIOMED/GENE MED-DRUGS MEDICAL SERVICES MINING -NON FERR OIL
> & GAS-DRILLING OIL FLD MCH&EQP OIL/GAS PROD PIPELINE MLP OIL-FIELD SVCS OIL-INTL
> INTGD OIL-US INTEGRTD POLLUTION CNTRL REIT-EQTY TRUST -OTHER REIT-MTGE
> TRUST RETAIL-DRUG STR RETAIL-RESTRNTS SEMI-ANALOG & MIXED SEMI-GENERAL SOAP&CLNG
> PREPS STEEL-PRODUCERS TOBACCO TRANS-AIR FRGHT TRANS-SHIP WIRELESS
> EQUIPMENT
>
> WIRELESS NATIONAL
>
>
> I could just take the left most characters until I get a " " or a "-" and
> that would get me down to 29 categories. None of my stocks are trading
> below $5 and I am using this function for my results:
> =RCHGetElementNumber({Symbol Cell},850)
>
>
> Bruce
>
>
>

Sat May 2, 2015 12:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Element #850 is industry groups. If you want sectors, you need to use
element #13896.

On Sat, May 2, 2015 at 9:21 AM, bameyer@optonline.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Using Zacks (850) for 72 stocks I get 44 different sectors:
>
> AEROSPACE/DEFENSE AGRICULTURE/PRODUCTS AUTO
> -FOREIGN BANKS-MAJOR REGIONAL BEVERAGES-SOFT COMMUNICATIONS COMPONENTS
> COMP-MINI COMP-SOFTWARE COMP-STORAGE DEV Error FINANCIAL TRANSACTION
> SERVICES FIN-INVEST BKRS FIN-SVGS & LOAN FOOD-MISC/DIVERSIFIED HOTELS &
> MOTELS INSTRU-CONTROL INTERNET SERVICES LARGE CAP PHARMA MACH-CONST/MNG MED
> INSTRUMENTS MED-BIOMED/GENE MED-DRUGS MEDICAL SERVICES MINING -NON FERR OIL
> & GAS-DRILLING OIL FLD MCH&EQP OIL/GAS PROD PIPELINE MLP OIL-FIELD SVCS OIL-INTL
> INTGD OIL-US INTEGRTD POLLUTION CNTRL REIT-EQTY TRUST -OTHER REIT-MTGE
> TRUST RETAIL-DRUG STR RETAIL-RESTRNTS SEMI-ANALOG & MIXED SEMI-GENERAL SOAP&CLNG
> PREPS STEEL-PRODUCERS TOBACCO TRANS-AIR FRGHT TRANS-SHIP WIRELESS
> EQUIPMENT
>
> WIRELESS NATIONAL
>
> I could just take the left most characters until I get a " " or a "-" and
> that would get me down to 29 categories. None of my stocks are trading
> below $5 and I am using this function for my results:
> =RCHGetElementNumber({Symbol Cell},850)
>
>
>
>

Sat May 2, 2015 4:36 pm (PDT) . Posted by:

adelgado2367

Hello!

As I am a newbie, I apologize if this issue has been dealt with before, but I could not find it

I am trying to learn the various functions, and so I tried the example given in the documentation by using the following:

=smfPricesBetween("IBM",TODAY()-365,TODAY())

However, the data returned showed big discrepancies with what is reported by, for example, Morningstar.

I tried to dig deeper, and concentrated on the "High" value reportedly occurred on 7/28/2014

Using the RCHGetYahoHistory function for that day, the returned data coincided with Morniingstar, but then I requested the adjusted data

=RCHGetYahooHistry("IBM",2014,7,28,2014,7,28,,,1)

and the data returned matched the data from smfPricesBetween

How can I have smfPricesBetween show the raw data, not adjusted values? The documentation section does not address this parameter

Thanks for your help, and thanks a lot for the add-in!




Sat May 2, 2015 4:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The function only shows adjusted values because it makes no sense to me to
compare quotes from various dates using unadjusted values.

On Sat, May 2, 2015 at 3:27 PM, adelgado2367@... wrote:

>
> As I am a newbie, I apologize if this issue has been dealt with before,
> but I could not find it
>
> I am trying to learn the various functions, and so I tried the example
> given in the documentation by using the following:
>
> =smfPricesBetween("IBM",TODAY()-365,TODAY())
>
> However, the data returned showed big discrepancies with what is reported
> by, for example, Morningstar.
>
> I tried to dig deeper, and concentrated on the "High" value reportedly
> occurred on 7/28/2014
>
> Using the RCHGetYahoHistory function for that day, the returned data
> coincided with Morniingstar, but then I requested the adjusted data
>
> =RCHGetYahooHistry("IBM",2014,7,28,2014,7,28,,,1)
>
> and the data returned matched the data from smfPricesBetween
>
> How can I have smfPricesBetween show the raw data, not adjusted values?
> The documentation section does not address this parameter
>
> Thanks for your help, and thanks a lot for the add-in!
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar