Fundamental Data: FCFPerShareGrowth 13020 - is it available?

kc975943

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?

ptunney

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))   

kc975943

Thanks! Will give it a spin