15 Messages
Digest #3967
1a
Re: How to Use RCHGetTableCell in place of RCHGetElementNumber (1387 by "Randy Harmelink" rharmelink
Messages
Sun Apr 16, 2017 7:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Element #13878 has been redefined on smf-elements-6.txt. I'll upload it
shortly. Zack's changed the label on the data item.
On Thu, Apr 6, 2017 at 4:47 PM, labsrcool@
...wrote:
> RCHGetElementNumber (13878) (Earning per Share (TTM) does not appear to
> be working. I also would prefer to grab data from Morningstar using
> the RCHGetTableCell
>
>
shortly. Zack's changed the label on the data item.
On Thu, Apr 6, 2017 at 4:47 PM, labsrcool@
...wrote:
> RCHGetElementNumber (13878) (Earning per Share (TTM) does not appear to
> be working. I also would prefer to grab data from Morningstar using
> the RCHGetTableCell
>
>
Sun Apr 16, 2017 7:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The extraction from the JSON code would something look like this:
=smfConvertData(smfStrExtr(RCHGetWebData(D4,"""netInstSharesBuying"":",150),"""raw"":",","))
On Sat, Apr 8, 2017 at 10:54 PM, ghart23@
...wrote:
> [This does not work]:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/it?s="&$B2,1,">Net
> Institutional",">Net Shares Purchased")
>
>
> Where $B2 is the stock symbol such as AAPL
>
>
>
=smfConvertData(smfStrExtr(RCHGetWebData(D4,"""netInstSharesBuying"":",150),"""raw"":",","))
On Sat, Apr 8, 2017 at 10:54 PM, ghart23@
...wrote:
> [This does not work]:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/it?s="&$B2,1,
> Institutional"
>
>
> Where $B2 is the stock symbol such as AAPL
>
>
>
Sun Apr 16, 2017 7:36 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They have a new URL and a new label. This works for me:
=smfGetTagContent("http://finance.yahoo.com/quote/"&A3,"td",1,">Previous
Close",,,,1)
On Mon, Apr 10, 2017 at 8:05 AM, john@
...wrote:
>
> Another extraction from Yahoo that no longer works:
>
> =smfGetTagContent("http://finance.yahoo.com/q?s="&A3,"td",1,"Prev
> Close:",,,,1)
>
>
=smfGetTagContent("http://finance.yahoo.com/quote/"&A3,"td",1,">Previous
Close",,,,1)
On Mon, Apr 10, 2017 at 8:05 AM, john@
...wrote:
>
> Another extraction from Yahoo that no longer works:
>
> =smfGetTagContent("http://finance.yahoo.com/q?s="&A3,"
> Close:"
>
>
Sun Apr 16, 2017 7:45 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Turned out to be an easy fix -- they had changed the ">EPS Trends" label to
">EPS Trend".
I'll upload a new version of smf-elements-2.txt shortly.
On Sun, Apr 9, 2017 at 6:49 AM, ghart23@
...wrote:
>
> Of course this major disruption in Yahoo earnings data access would come
> up while you are "off the air"
>
> Of the top of your head any idea what could be blocking the very simple
> call:
>
> =RCHGetElementNumber($B2,560)
>
>
>
">EPS Trend".
I'll upload a new version of smf-elements-
On Sun, Apr 9, 2017 at 6:49 AM, ghart23@
...wrote:
>
> Of course this major disruption in Yahoo earnings data access would come
> up while you are "off the air"
>
> Of the top of your head any idea what could be blocking the very simple
> call:
>
> =RCHGetElementNumbe
>
>
>
Mon Apr 17, 2017 3:48 am (PDT) . Posted by:
"Robbie Geary" rgearyiii
It's kind of annoying that Yahoo!'s profile data, e.g.,
https://query1.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=assetProfile
, does not contain the company name. It usually appears in the business
description, but extracting the company name from that would be a pain.
Yes, company name can be found with other queries, but it would be nice to
get it with the same query that gets other things from the profile.
--
Robbie Geary
https://query1.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=assetProfile
, does not contain the company name. It usually appears in the business
description, but extracting the company name from that would be a pain.
Yes, company name can be found with other queries, but it would be nice to
get it with the same query that gets other things from the profile.
--
Robbie Geary
Mon Apr 17, 2017 4:32 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I looked at the dozen or so other modules and didn't see a company name
field on any of them.
On Mon, Apr 17, 2017 at 3:48 AM, Robbie Geary rgearyiii@
...wrote:
>
> It's kind of annoying that Yahoo!'s profile data, e.g.,
> https://query1.finance.yahoo.com/v10/finance/quoteSummary/
> AAPL?modules=assetProfile , does not contain the company name. It
> usually appears in the business description, but extracting the company
> name from that would be a pain. Yes, company name can be found with other
> queries, but it would be nice to get it with the same query that gets other
> things from the profile.
>
field on any of them.
On Mon, Apr 17, 2017 at 3:48 AM, Robbie Geary rgearyiii@
...wrote:
>
> It's kind of annoying that Yahoo!'s profile data, e.g.,
> https://query1.finance.yahoo.com/v10/finance/quoteSummary/
> AAPL?modules=
> usually appears in the business description, but extracting the company
> name from that would be a pain. Yes, company name can be found with other
> queries, but it would be nice to get it with the same query that gets other
> things from the profile.
>
Mon Apr 17, 2017 4:34 am (PDT) . Posted by:
colinmmoors
looks like get smfGetCSVFile not working as of now
Mon Apr 17, 2017 4:42 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
More details please. Example?
On Mon, Apr 17, 2017 at 4:34 AM, colinmmoors@
...wrote:
>
> looks like get smfGetCSVFile not working as of now
>
>
On Mon, Apr 17, 2017 at 4:34 AM, colinmmoors@
...wrote:
>
> looks like get smfGetCSVFile not working as of now
>
>
Mon Apr 17, 2017 6:26 am (PDT) . Posted by:
pjwdoyle
I'm getting blank values for RCHGetYahooHistory.
I'm using the latest download, just downloaded and reinstalled on Excel 2010, on Win 7 Professional.
Cells don't show any error messages - just blank.
Happens regardless of arguments in function, eg:
=RCHGetYahooHistory(H2,,,,,,,"w","A",,,)
=RCHGetYahooHistory(E2,,,,,,,"w","DA",,,)
=RCHGetYahooHistory(C1,,,,,,,,"DOHLC",,,)
Is this just me, or is this part of the changes on Yahoo's end?
Thanks.
I'm using the latest download, just downloaded and reinstalled on Excel 2010, on Win 7 Professional.
Cells don't show any error messages - just blank.
Happens regardless of arguments in function, eg:
=RCHGetYahooHistory
=RCHGetYahooHistory
=RCHGetYahooHistory
Is this just me, or is this part of the changes on Yahoo's end?
Thanks.
Sun Apr 16, 2017 8:09 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I made these changes:
"Obsolete elements #13864/13866/13868 (Industry numbers and symbols from
Yahoo), updated elements #13865 (Sector name) and #13866 (Industry name on
smf-elements-2.txt, because of Yahoo web page changes."
I'll upload the new smf-elements-2.txt shortly.
On Sun, Apr 9, 2017 at 12:38 AM, Robbie Geary rgearyiii@
...wrote:
>
> Has Yahoo! broken the industry lookups in the course of getting rid of the
> Industry Browser? All I get are errors now.
>
> On Fri, Feb 3, 2017 at 12:34 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> Works fine here. Could be Yahoo or communication issues?
>>
>> When you get an error on a ticker, do all of the items from that page
>> return Error?
>>
>> *#* *Element*
>> 13864 Sector Number
>> 13865 Sector Name
>> 13866 Industry Number
>> 13867 Industry Name
>> 13868 Industry Symbol
>>
>>
"Obsolete elements #13864/13866/13868 (Industry numbers and symbols from
Yahoo), updated elements #13865 (Sector name) and #13866 (Industry name on
smf-elements-2.txt, because of Yahoo web page changes."
I'll upload the new smf-elements-2.txt shortly.
On Sun, Apr 9, 2017 at 12:38 AM, Robbie Geary rgearyiii@
...wrote:
>
> Has Yahoo! broken the industry lookups in the course of getting rid of the
> Industry Browser? All I get are errors now.
>
> On Fri, Feb 3, 2017 at 12:34 PM, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> Works fine here. Could be Yahoo or communication issues?
>>
>> When you get an error on a ticker, do all of the items from that page
>> return Error?
>>
>> *#* *Element*
>> 13864 Sector Number
>> 13865 Sector Name
>> 13866 Industry Number
>> 13867 Industry Name
>> 13868 Industry Symbol
>>
>>
Sun Apr 16, 2017 9:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I think this is the list of sectors and industry groups on Yahoo, with
their lookup IDs for the JSON calls:
*Sector* *Industry Group* *scrID*
Basic Materials -- basic_materials
Conglomerates -- conglomerates
Consumer Goods -- consumer_goods
Financial -- financial
Healthcare -- healthcare
Industrial Goods -- industrial_goods
Services -- services
Technology -- technology
Utilities -- utilities
Basic Materials Chemicals - Major Diversified chemicals_major_diversified
Basic Materials Synthetics synthetics
Basic Materials Agricultural Chemicals agricultural_chemicals
Basic Materials Specialty Chemicals specialty_chemicals
Basic Materials Major Integrated Oil & Gas major_integrated_oil_gas
Basic Materials Independent Oil & Gas independent_oil_gas
Basic Materials Oil & Gas Refining & Marketing oil_gas_refining_marketing
Basic Materials Oil & Gas Drilling & Exploration
oil_gas_drilling_exploration
Basic Materials Oil & Gas Equipment & Services oil_gas_equipment_services
Basic Materials Oil & Gas Pipelines oil_gas_pipelines
Basic Materials Steel & Iron steel_iron
Basic Materials Copper copper
Basic Materials Aluminum aluminum
Basic Materials Industrial Metals & Minerals industrial_metals_minerals
Basic Materials Gold gold
Basic Materials Silver silver
Basic Materials Nonmetallic Mineral Mining nonmetallic_mineral_mining
Conglomerates Conglomerates conglomerates
Consumer Goods Appliances appliances
Consumer Goods Home Furnishings & Fixtures home_furnishings_fixtures
Consumer Goods Housewares & Accessories housewares_accessories
Consumer Goods Business Equipment business_equipment
Consumer Goods Electronic Equipment electronic_equipment
Consumer Goods Toys & Games toys_games
Consumer Goods Sporting Goods sporting_goods
Consumer Goods Recreational Goods, Other recreational_goods_other
Consumer Goods Photographic Equipment & Supplies
photographic_equipment_supplies
Consumer Goods Textile - Apparel Clothing textile_apparel_clothing
Consumer Goods Textile - Apparel Footwear & Accessories
textile_apparel_footwear_accessories
Consumer Goods Rubber & Plastics rubber_plastics
Consumer Goods Personal Products personal_products
Consumer Goods Paper & Paper Products paper_paper_products
Consumer Goods Packaging & Containers packaging_containers
Consumer Goods Cleaning Products cleaning_products
Consumer Goods Office Supplies office_supplies
Consumer Goods Auto Manufacturers - Major auto_manufacturers_major
Consumer Goods Trucks & Other Vehicles trucks_other_vehicles
Consumer Goods Recreational Vehicles recreational_vehicles
Consumer Goods Auto Parts auto_parts
Consumer Goods Food - Major Diversified food_major_diversified
Consumer Goods Farm Products farm_products
Consumer Goods Processed & Packaged Goods processed_packaged_goods
Consumer Goods Meat Products meat_products
Consumer Goods Dairy Products dairy_products
Consumer Goods Confectioners confectioners
Consumer Goods Beverages - Brewers beverages_brewers
Consumer Goods Beverages - Wineries & Distillers
beverages_wineries_distillers
Consumer Goods Beverages - Soft Drinks beverages_soft_drinks
Consumer Goods Cigarettes cigarettes
Consumer Goods Tobacco Products, Other tobacco_products_other
Financial Money Center Banks money_center_banks
Financial Regional - Northeast Banks regional_northeast_banks
Financial Regional - Mid-Atlantic Banks regional_midatlantic_banks
Financial Regional - Southeast Banks regional_southeast_banks
Financial Regional - Midwest Banks regional_midwest_banks
Financial Regional - Southwest Banks regional_southwest_banks
Financial Regional - Pacific Banks regional_pacific_banks
Financial Foreign Money Center Banks foreign_money_center_banks
Financial Foreign Regional Banks foreign_regional_banks
Financial Savings & Loans savings_loans
Financial Investment Brokerage - National investment_brokerage_national
Financial Investment Brokerage - Regional investment_brokerage_regional
Financial Asset Management asset_management
Financial Diversified Investments diversified_investments
Financial Credit Services credit_services
Financial Closed-End Fund - Debt closedend_fund_debt
Financial Closed-End Fund - Equity closedend_fund_equity
Financial Closed-End Fund - Foreign closedend_fund_foreign
Financial Life Insurance life_insurance
Financial Accident & Health Insurance accident_health_insurance
Financial Property & Casualty Insurance property_casualty_insurance
Financial Surety & Title Insurance surety_title_insurance
Financial Insurance Brokers insurance_brokers
Financial REIT - Diversified reit_diversified
Financial REIT - Office reit_office
Financial REIT - Healthcare Facilities reit_healthcare_facilities
Financial REIT - Hotel/Motel reit_hotel_motel
Financial REIT - Industrial reit_industrial
Financial REIT - Residential reit_residential
Financial REIT - Retail reit_retail
Financial Mortgage Investment mortgage_investment
Financial Property Management property_management
Financial Real Estate Development real_estate_development
Healthcare Drug Manufacturers - Major drug_manufacturers_major
Healthcare Drug Manufacturers - Other drug_manufacturers_other
Healthcare Drugs - Generic drugs_generic
Healthcare Drug Delivery drug_delivery
Healthcare Drug Related Products drug_related_products
Healthcare Biotechnology biotechnology
Healthcare Diagnostic Substances diagnostic_substances
Healthcare Medical Instruments & Supplies medical_instruments_supplies
Healthcare Medical Appliances & Equipment medical_appliances_equipment
Healthcare Health Care Plans health_care_plans
Healthcare Long-Term Care Facilities longterm_care_facilities
Healthcare Hospitals hospitals
Healthcare Medical Laboratories & Research medical_laboratories_research
Healthcare Home Health Care home_health_care
Healthcare Medical Practitioners medical_practitioners
Healthcare Specialized Health Services specialized_health_services
Industrial Goods Aerospace/Defense - Major Diversified
aerospace_defense_major_diversified
Industrial Goods Aerospace/Defense Products & Services
aerospace_defense_products_services
Industrial Goods Farm & Construction Machinery farm_construction_machinery
Industrial Goods Industrial Equipment & Components
industrial_equipment_components
Industrial Goods Diversified Machinery diversified_machinery
Industrial Goods Pollution & Treatment Controls pollution_treatment_controls
Industrial Goods Machine Tools & Accessories machine_tools_accessories
Industrial Goods Small Tools & Accessories small_tools_accessories
Industrial Goods Metal Fabrication metal_fabrication
Industrial Goods Industrial Electrical Equipment
industrial_electrical_equipment
Industrial Goods Textile Industrial textile_industrial
Industrial Goods Residential Construction residential_construction
Industrial Goods Manufactured Housing manufactured_housing
Industrial Goods Lumber, Wood Production lumber_wood_production
Industrial Goods Cement cement
Industrial Goods General Building Materials general_building_materials
Industrial Goods Heavy Construction heavy_construction
Industrial Goods General Contractors general_contractors
Industrial Goods Waste Management waste_management
Services Lodging lodging
Services Resorts & Casinos resorts_casinos
Services Restaurants restaurants
Services Specialty Eateries specialty_eateries
Services Gaming Activities gaming_activities
Services Sporting Activities sporting_activities
Services General Entertainment general_entertainment
Services Advertising Agencies advertising_agencies
Services Marketing Services marketing_services
Services Entertainment - Diversified entertainment_diversified
Services Broadcasting - TV broadcasting_tv
Services Broadcasting - Radio broadcasting_radio
Services CATV Systems catv_systems
Services Movie Production, Theaters movie_production_theaters
Services Publishing - Newspapers publishing_newspapers
Services Publishing - Periodicals publishing_periodicals
Services Publishing - Books publishing_books
Services Apparel Stores apparel_stores
Services Department Stores department_stores
Services Discount, Variety Stores discount_variety_stores
Services Drug Stores drug_stores
Services Grocery Stores grocery_stores
Services Electronics Stores electronics_stores
Services Home Improvement Stores home_improvement_stores
Services Home Furnishing Stores home_furnishing_stores
Services Auto Parts Stores auto_parts_stores
Services Catalog & Mail Order Houses catalog_mail_order_houses
Services Sporting Goods Stores sporting_goods_stores
Services Toy & Hobby Stores toy_hobby_stores
Services Jewelry Stores jewelry_stores
Services Music & Video Stores music_video_stores
Services Auto Dealerships auto_dealerships
Services Specialty Retail, Other specialty_retail_other
Services Auto Parts Wholesale auto_parts_wholesale
Services Building Materials Wholesale building_materials_wholesale
Services Industrial Equipment Wholesale industrial_equipment_wholesale
Services Electronics Wholesale electronics_wholesale
Services Medical Equipment Wholesale medical_equipment_wholesale
Services Computers Wholesale computers_wholesale
Services Drugs Wholesale drugs_wholesale
Services Food Wholesale food_wholesale
Services Basic Materials Wholesale basic_materials_wholesale
Services Wholesale, Other wholesale_other
Services Business Services business_services
Services Rental & Leasing Services rental_leasing_services
Services Personal Services personal_services
Services Consumer Services consumer_services
Services Staffing & Outsourcing Services staffing_outsourcing_services
Services Security & Protection Services security_protection_services
Services Education & Training Services education_training_services
Services Technical Services technical_services
Services Research Services research_services
Services Management Services management_services
Services Major Airlines major_airlines
Services Regional Airlines regional_airlines
Services Air Services, Other air_services_other
Services Air Delivery & Freight Services air_delivery_freight_services
Services Trucking trucking
Services Shipping shipping
Services Railroads railroads
Technology Diversified Computer Systems diversified_computer_systems
Technology Personal Computers personal_computers
Technology Computer Based Systems computer_based_systems
Technology Data Storage Devices data_storage_devices
Technology Networking & Communication Devices
networking_communication_devices
Technology Computer Peripherals computer_peripherals
Technology Multimedia & Graphics Software multimedia_graphics_software
Technology Application Software application_software
Technology Technical & System Software technical_system_software
Technology Security Software & Services security_software_services
Technology Information Technology Services information_technology_services
Technology Healthcare Information Services healthcare_information_services
Technology Business Software & Services business_software_services
Technology Information & Delivery Services information_delivery_services
Technology Semiconductor - Broad Line semiconductor_broad_line
Technology Semiconductor- Memory Chips semiconductor_memory_chips
Technology Semiconductor - Specialized semiconductor_specialized
Technology Semiconductor - Integrated Circuits
semiconductor_integrated_circuits
Technology Semiconductor Equipment & Materials
semiconductor_equipment_materials
Technology Printed Circuit Boards printed_circuit_boards
Technology Diversified Electronics diversified_electronics
Technology Scientific & Technical Instruments
scientific_technical_instruments
Technology Wireless Communications wireless_communications
Technology Communication Equipment communication_equipment
Technology Processing Systems & Products processing_systems_products
Technology Long Distance Carriers long_distance_carriers
Technology Telecom Services - Domestic telecom_services_domestic
Technology Telecom Services - Foreign telecom_services_foreign
Technology Diversified Communication Services
diversified_communication_services
Technology Internet Service Providers internet_service_providers
Technology Internet Information Providers internet_information_providers
Technology Internet Software & Services internet_software_services
Utilities Foreign Utilities foreign_utilities
Utilities Electric Utilities electric_utilities
Utilities Gas Utilities gas_utilities
Utilities Diversified Utilities diversified_utilities
Utilities Water Utilities water_utilities
On Mon, Apr 10, 2017 at 3:40 PM, Randy Harmelink
... wrote:
For stocks within a given sector or industry group, this appears to be the
> JSON call format:
>
> https://query2.finance.yahoo.com/v1/finance/screener/
> predefined/saved?scrIds=technology&start=0&count=1000
>
> https://query2.finance.yahoo.com/v1/finance/screener/
> predefined/saved?scrIds=semiconductor_equipment_
> materials&start=0&count=1000
>
> As for the sector and industry group names, I don't see a good list
> anywhere. The best I can find is within the Javascript code for starting a
> new screen:
>
> http://finance.yahoo.com/screener/new
>
>
>
their lookup IDs for the JSON calls:
*Sector* *Industry Group* *scrID*
Basic Materials -- basic_materials
Conglomerates -- conglomerates
Consumer Goods -- consumer_goods
Financial -- financial
Healthcare -- healthcare
Industrial Goods -- industrial_goods
Services -- services
Technology -- technology
Utilities -- utilities
Basic Materials Chemicals - Major Diversified chemicals_major_diversified
Basic Materials Synthetics synthetics
Basic Materials Agricultural Chemicals agricultural_chemicals
Basic Materials Specialty Chemicals specialty_chemicals
Basic Materials Major Integrated Oil & Gas major_integrated_oil_gas
Basic Materials Independent Oil & Gas independent_oil_gas
Basic Materials Oil & Gas Refining & Marketing oil_gas_refining_marketing
Basic Materials Oil & Gas Drilling & Exploration
oil_gas_drilling_exploration
Basic Materials Oil & Gas Equipment & Services oil_gas_equipment_services
Basic Materials Oil & Gas Pipelines oil_gas_pipelines
Basic Materials Steel & Iron steel_iron
Basic Materials Copper copper
Basic Materials Aluminum aluminum
Basic Materials Industrial Metals & Minerals industrial_metals_minerals
Basic Materials Gold gold
Basic Materials Silver silver
Basic Materials Nonmetallic Mineral Mining nonmetallic_mineral_mining
Conglomerates Conglomerates conglomerates
Consumer Goods Appliances appliances
Consumer Goods Home Furnishings & Fixtures home_furnishings_fixtures
Consumer Goods Housewares & Accessories housewares_accessories
Consumer Goods Business Equipment business_equipment
Consumer Goods Electronic Equipment electronic_equipment
Consumer Goods Toys & Games toys_games
Consumer Goods Sporting Goods sporting_goods
Consumer Goods Recreational Goods, Other recreational_goods_other
Consumer Goods Photographic Equipment & Supplies
photographic_equipment_supplies
Consumer Goods Textile - Apparel Clothing textile_apparel_clothing
Consumer Goods Textile - Apparel Footwear & Accessories
textile_apparel_footwear_accessories
Consumer Goods Rubber & Plastics rubber_plastics
Consumer Goods Personal Products personal_products
Consumer Goods Paper & Paper Products paper_paper_products
Consumer Goods Packaging & Containers packaging_containers
Consumer Goods Cleaning Products cleaning_products
Consumer Goods Office Supplies office_supplies
Consumer Goods Auto Manufacturers - Major auto_manufacturers_major
Consumer Goods Trucks & Other Vehicles trucks_other_vehicles
Consumer Goods Recreational Vehicles recreational_vehicles
Consumer Goods Auto Parts auto_parts
Consumer Goods Food - Major Diversified food_major_diversified
Consumer Goods Farm Products farm_products
Consumer Goods Processed & Packaged Goods processed_packaged_goods
Consumer Goods Meat Products meat_products
Consumer Goods Dairy Products dairy_products
Consumer Goods Confectioners confectioners
Consumer Goods Beverages - Brewers beverages_brewers
Consumer Goods Beverages - Wineries & Distillers
beverages_wineries_distillers
Consumer Goods Beverages - Soft Drinks beverages_soft_drinks
Consumer Goods Cigarettes cigarettes
Consumer Goods Tobacco Products, Other tobacco_products_other
Financial Money Center Banks money_center_banks
Financial Regional - Northeast Banks regional_northeast_banks
Financial Regional - Mid-Atlantic Banks regional_midatlantic_banks
Financial Regional - Southeast Banks regional_southeast_banks
Financial Regional - Midwest Banks regional_midwest_banks
Financial Regional - Southwest Banks regional_southwest_banks
Financial Regional - Pacific Banks regional_pacific_banks
Financial Foreign Money Center Banks foreign_money_center_banks
Financial Foreign Regional Banks foreign_regional_banks
Financial Savings & Loans savings_loans
Financial Investment Brokerage - National investment_brokerage_national
Financial Investment Brokerage - Regional investment_brokerage_regional
Financial Asset Management asset_management
Financial Diversified Investments diversified_investments
Financial Credit Services credit_services
Financial Closed-End Fund - Debt closedend_fund_debt
Financial Closed-End Fund - Equity closedend_fund_equity
Financial Closed-End Fund - Foreign closedend_fund_foreign
Financial Life Insurance life_insurance
Financial Accident & Health Insurance accident_health_insurance
Financial Property & Casualty Insurance property_casualty_insurance
Financial Surety & Title Insurance surety_title_insurance
Financial Insurance Brokers insurance_brokers
Financial REIT - Diversified reit_diversified
Financial REIT - Office reit_office
Financial REIT - Healthcare Facilities reit_healthcare_facilities
Financial REIT - Hotel/Motel reit_hotel_motel
Financial REIT - Industrial reit_industrial
Financial REIT - Residential reit_residential
Financial REIT - Retail reit_retail
Financial Mortgage Investment mortgage_investment
Financial Property Management property_management
Financial Real Estate Development real_estate_development
Healthcare Drug Manufacturers - Major drug_manufacturers_major
Healthcare Drug Manufacturers - Other drug_manufacturers_other
Healthcare Drugs - Generic drugs_generic
Healthcare Drug Delivery drug_delivery
Healthcare Drug Related Products drug_related_products
Healthcare Biotechnology biotechnology
Healthcare Diagnostic Substances diagnostic_substances
Healthcare Medical Instruments & Supplies medical_instruments_supplies
Healthcare Medical Appliances & Equipment medical_appliances_equipment
Healthcare Health Care Plans health_care_plans
Healthcare Long-Term Care Facilities longterm_care_facilities
Healthcare Hospitals hospitals
Healthcare Medical Laboratories & Research medical_laboratories_research
Healthcare Home Health Care home_health_care
Healthcare Medical Practitioners medical_practitioners
Healthcare Specialized Health Services specialized_health_services
Industrial Goods Aerospace/Defense - Major Diversified
aerospace_defense_major_diversified
Industrial Goods Aerospace/Defense Products & Services
aerospace_defense_products_services
Industrial Goods Farm & Construction Machinery farm_construction_machinery
Industrial Goods Industrial Equipment & Components
industrial_equipment_components
Industrial Goods Diversified Machinery diversified_machinery
Industrial Goods Pollution & Treatment Controls pollution_treatment_controls
Industrial Goods Machine Tools & Accessories machine_tools_accessories
Industrial Goods Small Tools & Accessories small_tools_accessories
Industrial Goods Metal Fabrication metal_fabrication
Industrial Goods Industrial Electrical Equipment
industrial_electrical_equipment
Industrial Goods Textile Industrial textile_industrial
Industrial Goods Residential Construction residential_construction
Industrial Goods Manufactured Housing manufactured_housing
Industrial Goods Lumber, Wood Production lumber_wood_production
Industrial Goods Cement cement
Industrial Goods General Building Materials general_building_materials
Industrial Goods Heavy Construction heavy_construction
Industrial Goods General Contractors general_contractors
Industrial Goods Waste Management waste_management
Services Lodging lodging
Services Resorts & Casinos resorts_casinos
Services Restaurants restaurants
Services Specialty Eateries specialty_eateries
Services Gaming Activities gaming_activities
Services Sporting Activities sporting_activities
Services General Entertainment general_entertainment
Services Advertising Agencies advertising_agencies
Services Marketing Services marketing_services
Services Entertainment - Diversified entertainment_diversified
Services Broadcasting - TV broadcasting_tv
Services Broadcasting - Radio broadcasting_radio
Services CATV Systems catv_systems
Services Movie Production, Theaters movie_production_theaters
Services Publishing - Newspapers publishing_newspapers
Services Publishing - Periodicals publishing_periodicals
Services Publishing - Books publishing_books
Services Apparel Stores apparel_stores
Services Department Stores department_stores
Services Discount, Variety Stores discount_variety_stores
Services Drug Stores drug_stores
Services Grocery Stores grocery_stores
Services Electronics Stores electronics_stores
Services Home Improvement Stores home_improvement_stores
Services Home Furnishing Stores home_furnishing_stores
Services Auto Parts Stores auto_parts_stores
Services Catalog & Mail Order Houses catalog_mail_order_houses
Services Sporting Goods Stores sporting_goods_stores
Services Toy & Hobby Stores toy_hobby_stores
Services Jewelry Stores jewelry_stores
Services Music & Video Stores music_video_stores
Services Auto Dealerships auto_dealerships
Services Specialty Retail, Other specialty_retail_other
Services Auto Parts Wholesale auto_parts_wholesale
Services Building Materials Wholesale building_materials_wholesale
Services Industrial Equipment Wholesale industrial_equipment_wholesale
Services Electronics Wholesale electronics_wholesale
Services Medical Equipment Wholesale medical_equipment_wholesale
Services Computers Wholesale computers_wholesale
Services Drugs Wholesale drugs_wholesale
Services Food Wholesale food_wholesale
Services Basic Materials Wholesale basic_materials_wholesale
Services Wholesale, Other wholesale_other
Services Business Services business_services
Services Rental & Leasing Services rental_leasing_services
Services Personal Services personal_services
Services Consumer Services consumer_services
Services Staffing & Outsourcing Services staffing_outsourcing_services
Services Security & Protection Services security_protection_services
Services Education & Training Services education_training_services
Services Technical Services technical_services
Services Research Services research_services
Services Management Services management_services
Services Major Airlines major_airlines
Services Regional Airlines regional_airlines
Services Air Services, Other air_services_other
Services Air Delivery & Freight Services air_delivery_freight_services
Services Trucking trucking
Services Shipping shipping
Services Railroads railroads
Technology Diversified Computer Systems diversified_computer_systems
Technology Personal Computers personal_computers
Technology Computer Based Systems computer_based_systems
Technology Data Storage Devices data_storage_devices
Technology Networking & Communication Devices
networking_communication_devices
Technology Computer Peripherals computer_peripherals
Technology Multimedia & Graphics Software multimedia_graphics_software
Technology Application Software application_software
Technology Technical & System Software technical_system_software
Technology Security Software & Services security_software_services
Technology Information Technology Services information_technology_services
Technology Healthcare Information Services healthcare_information_services
Technology Business Software & Services business_software_services
Technology Information & Delivery Services information_delivery_services
Technology Semiconductor - Broad Line semiconductor_broad_line
Technology Semiconductor- Memory Chips semiconductor_memory_chips
Technology Semiconductor - Specialized semiconductor_specialized
Technology Semiconductor - Integrated Circuits
semiconductor_integrated_circuits
Technology Semiconductor Equipment & Materials
semiconductor_equipment_materials
Technology Printed Circuit Boards printed_circuit_boards
Technology Diversified Electronics diversified_electronics
Technology Scientific & Technical Instruments
scientific_technical_instruments
Technology Wireless Communications wireless_communications
Technology Communication Equipment communication_equipment
Technology Processing Systems & Products processing_systems_products
Technology Long Distance Carriers long_distance_carriers
Technology Telecom Services - Domestic telecom_services_domestic
Technology Telecom Services - Foreign telecom_services_foreign
Technology Diversified Communication Services
diversified_communication_services
Technology Internet Service Providers internet_service_providers
Technology Internet Information Providers internet_information_providers
Technology Internet Software & Services internet_software_services
Utilities Foreign Utilities foreign_utilities
Utilities Electric Utilities electric_utilities
Utilities Gas Utilities gas_utilities
Utilities Diversified Utilities diversified_utilities
Utilities Water Utilities water_utilities
On Mon, Apr 10, 2017 at 3:40 PM, Randy Harmelink
... wrote:
For stocks within a given sector or industry group, this appears to be the
> JSON call format:
>
> https://query2.finance.yahoo.com/v1/finance/screener/
> predefined/saved?scrIds=technology&start=0&count=1000
>
> https://query2.finance.yahoo.com/v1/finance/screener/
> predefined/saved?scrIds=semiconductor_equipment_
> materials&start=0&count=1000
>
> As for the sector and industry group names, I don't see a good list
> anywhere. The best I can find is within the Javascript code for starting a
> new screen:
>
> http://finance.yahoo.com/screener/new
>
>
>
Sun Apr 16, 2017 8:11 pm (PDT) . Posted by:
alankc_mok
Randy,
Thanks for your reply.
Following your advice, the add in is working by fetching data from Barchart..
Lately I find that it is taking longer time to get option data from Yahoo (two to three time longer). Is it because of change in data structure with Yahoo ?
Alan
Thanks for your reply.
Following your advice, the add in is working by fetching data from Barchart..
Lately I find that it is taking longer time to get option data from Yahoo (two to three time longer). Is it because of change in data structure with Yahoo ?
Alan
Sun Apr 16, 2017 9:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I hadn't noticed the difference, but I've been using barchart for most of
my options retrievals. Your guess may be correct...
On Sun, Apr 16, 2017 at 8:11 PM, alankc_mok@
...wrote:
>
> Following your advice, the add in is working by fetching data from
> Barchart..
>
> Lately I find that it is taking longer time to get option data from Yahoo
> (two to three time longer). Is it because of change in data structure with
> Yahoo ?
>
>
>
my options retrievals. Your guess may be correct...
On Sun, Apr 16, 2017 at 8:11 PM, alankc_mok@
...wrote:
>
> Following your advice, the add in is working by fetching data from
> Barchart..
>
> Lately I find that it is taking longer time to get option data from Yahoo
> (two to three time longer). Is it because of change in data structure with
> Yahoo ?
>
>
>
Mon Apr 17, 2017 2:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Changes to a few element definitions:
*Date* *Routine* *Description*
2017-04-16 RCHGetElementNumber Various Yahoo changes:
- Obsolete elements #13864/13866/13868 (Industry numbers and symbols
from Yahoo), updated elements #13865 (Sector name) and #13866 (Industry
name on smf-elements-2.txt, because of Yahoo web page changes.
- Fix elements #560 thru #576 (EPS consensus trends from Yahoo) on
smf-elements-2.txt, for label change on updated web page
- Obsolete elements #938 and #939 (Date of 52-week high and low from
Yahoo) on smf-elements-2.txt, for change on web page
- Update elements #958/#961/#963 (from Yahoo Key statistics) on
smf-elements-2.txt, because of label changes on updated web page
- Update elements #1285 (Next Earnings Date from Yahoo) on
smf-elements-2.txt, because of label change on updated web page
2017-04-16 RCHGetElementNumber Fix elements #13878 (EPS(TTM) from Zacks) on
smf-elements-6.txt, for a label change on updated web page
See these web pages:
http://ogres-crypt.com/SMF/Elements/
http://ogres-crypt.com/SMF/Documentation/
Best practice is to update add-in files when EXCEL is closed.
*Date* *Routine* *Description*
2017-04-16 RCHGetElementNumber Various Yahoo changes:
- Obsolete elements #13864/13866/13868 (Industry numbers and symbols
from Yahoo), updated elements #13865 (Sector name) and #13866 (Industry
name on smf-elements-2.txt, because of Yahoo web page changes.
- Fix elements #560 thru #576 (EPS consensus trends from Yahoo) on
smf-elements-2.txt, for label change on updated web page
- Obsolete elements #938 and #939 (Date of 52-week high and low from
Yahoo) on smf-elements-2.txt, for change on web page
- Update elements #958/#961/#963 (from Yahoo Key statistics) on
smf-elements-2.txt, because of label changes on updated web page
- Update elements #1285 (Next Earnings Date from Yahoo) on
smf-elements-2.txt, because of label change on updated web page
2017-04-16 RCHGetElementNumber Fix elements #13878 (EPS(TTM) from Zacks) on
smf-elements-6.txt, for a label change on updated web page
See these web pages:
http://ogres-crypt.com/SMF/Elements/
http://ogres-crypt.com/SMF/Documentation/
Best practice is to update add-in files when EXCEL is closed.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar