Fundamental Data: FCFPerShareGrowth 13020 - is it available?

An example here https://app.cloudquant.com/#/glossary/1714 and my own attempts several months ago show that despite being listed as available, this piece of data seems to be missing. Is there possibly a bug in parsing MS data on the backend, or is this not available in reality?

Comments

  • ptunneyptunney Posts: 246

    Liberator was updated last week and I am working my way through the scripts and documentation to update them...

    The data set you are interested in is 'Earnings Ratios'

    This code should help you...

    from cloudquant.interfaces import Strategy
    
    import sys
    import json
    import liberator as b24
    from liberator import *
    from liberator.util import *
    from datetime import datetime as dt
    import numpy as np
    import pandas as pd
    pd.set_option('display.max_rows', 500)
    pd.set_option('display.max_columns', 500)
    pd.set_option('display.width', 1000)
    
    class Morningstar_Fundamental_Demo(Strategy):
    
        @classmethod
        def on_strategy_start(cls, md, service, account): #
            mySyms = ['IBM','TWTR']
            backto = service.time_to_string(service.get_market_hours(date_offset=-60)[0],"%Y-%m-%d") # 60 trading days 
            today = service.time_to_string(service.get_market_hours(date_offset=0)[0],"%Y-%m-%d")
    
            res = b24.query(symbols=mySyms, as_of=today, back_to=backto, name='Earnings Report')        
    
            print("\n--------- PIVOT TABLE Data Frame Output -------------")
            df=b24.get_dataframe(res, pivot=True, to_datetime=False)
            print(df)
    
            print("\n--------- Data Frame Output -------------")
            df=b24.get_dataframe(res, to_datetime=False)
            print(df)
    
            print("\n--------- json dump Output -------------")
            print(json.dumps(res, indent=4))   
    
            res = b24.query(symbols=mySyms, as_of=today, back_to=backto, name='Earnings Ratios')        
    
            print("\n--------- PIVOT TABLE Data Frame Output -------------")
            df=b24.get_dataframe(res, pivot=True, to_datetime=False)
            print(df)
    
            print("\n--------- Data Frame Output -------------")
            df=b24.get_dataframe(res, to_datetime=False)
            print(df)
    
            print("\n--------- json dump Output -------------")
            print(json.dumps(res, indent=4))   
    
    
  • kc975943kc975943 Posts: 55

    Thanks! Will give it a spin

Sign In or Register to comment.