7 Messages
Digest #3397
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.
>
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
AEROSPACE/DEFENSE AGRICULTURE/
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: =RCHGetElementNumbe
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
>
>
>
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/
> -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/DIVERSIFI
> 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:
> =RCHGetElementNumbe
>
>
> 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)
>
>
>
>
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/
> -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/DIVERSIFI
> 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:
> =RCHGetElementNumbe
>
>
>
>
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!
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(
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(
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!
>
compare quotes from various dates using unadjusted values.
On Sat, May 2, 2015 at 3:27 PM, adelgado2367@
>
> 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(
>
> 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(
>
> 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:
Posting Komentar