How to get Fundamentals Company Geographic Sales Breakdown with Eikon Data APIs | Refinitiv

    	
            
df,err = ek.get_data('AMD.OQ', ['TR.BGS.GeoTotalRevenue.segmentName', 'TR.BGS.GeoTotalRevenue','TR.CompanyName'])
df

        
        Copy
    

    	
            
df.set_index('Segment Name',drop=True,inplace=True)
fig = plt.figure()
df.plot(kind='barh', ax = fig.gca())
plt.show()

        
        Copy
    

    	
            
df_graph = df.copy()
 
df_graph.rename(columns={
                   'Segment Name':'Geographic',
                   'Geographic Total Revenues (Calculated)':'Revenues'},
         inplace = True)
 
df_graph

        
        Copy
    

    	
            
total_sale = df_graph.iloc[df_graph.shape[0] - 1]['Revenues']
 
company_name = df_graph.iloc[0]['Company Name']

        
        Copy
    

    	
            
df_graph = df_graph[df_graph['Geographic'] != 'Segment Total']
df_graph = df_graph[df_graph['Geographic'] != 'Consolidated Total']

        
        Copy
    

    	
            
def format_revenues_number(tick_val, pos):
    """
    Turns large tick values (in the trillions, billions, millions and thousands) such as 4500 into 4.5K 
    and also appropriately turns 4000 into 4K (no zero after the decimal).
    """
    if tick_val >= 1000000000000: # Add support for trillions
        val = round(tick_val/1000000000000, 1)
        new_tick_format = '{:}T'.format(val)
    elif tick_val >= 1000000000:
        val = round(tick_val/1000000000, 1)
        new_tick_format = '{:}B'.format(val)
    elif tick_val >= 1000000:
        val = round(tick_val/1000000, 1)
        new_tick_format = '{:}M'.format(val)
    elif tick_val >= 1000:
        val = round(tick_val/1000, 1)
        new_tick_format = '{:}K'.format(val)
    elif tick_val < 1000:
        new_tick_format = round(tick_val, 1)
    else:
        new_tick_format = tick_val
 
     # make new_tick_format into a string value
    new_tick_format = str(new_tick_format)
    """
    code below will keep 4.5M as is but change values such as 4.0M to 4M since that 
    zero after the decimal isn't needed
    """
    index_of_decimal = new_tick_format.find(".")
    
    if index_of_decimal != -1:
        value_after_decimal = new_tick_format[index_of_decimal+1]
        if value_after_decimal == "0":
            # remove the 0 after the decimal point since it's not needed
            new_tick_format = new_tick_format[0:index_of_decimal] + new_tick_format[index_of_decimal+2:]
            
    return new_tick_format

        
        Copy
    

    	
            
# Plotting a Graph
 
df_graph.set_index('Geographic',drop=True,inplace=True)
fig = plt.figure()
 
#Format Total Sale display unit as a graph footer.
fig.text(.5, -.05, 'Total Sale %s' %(f'{total_sale:,.2f}'), ha='center',fontsize='large')
 
# Create graph title from Company and RIC names dynamically.
plt.ticklabel_format(style = 'plain')
plt.title('%s (%s) Geographic Sale Breakdown' % (company_name, 'AMD.OQ'), color='black',fontsize='x-large')
ax = fig.gca()
 
#Apply Sale data into millions function.
formatter = FuncFormatter(format_revenues_number)
ax.xaxis.set_major_formatter(formatter)
 
df_graph.plot(kind='barh', ax = fig.gca())
plt.show()

        
        Copy
    

    	
            
df,err = ek.get_data('0#.DJI',['TR.CompanyName'])
 
# Get a list of RICs for the first 5 rows of returned Dataframe object.
rics = data.head()['Instrument'].tolist()
 
# Get Geographic Revenue Data
df,err = ek.get_data(rics[0], ['TR.BGS.GeoTotalRevenue.segmentName', 'TR.BGS.GeoTotalRevenue','TR.CompanyName'])
 
# Continue Dataframe and graph process
...

        
        Copy