In the picture below, I checked for the P/E ratios of Facebook and Amazon: You’ll use the following formula to obtain the P/E ratio for a certain stock: =GOOGLEFINANCE(stock symbol, “pe”) Now, let’s see how to download P/E ratios in GSheets: The Price-to-Earnings ratio (P/E ratio) is calculated by dividing the company’s stock price by its earnings. How to retrieve Price-to-Earnings ratio using Google Finance API? » Learn how to retrieve price and non-price data from Quandl. To view all of its functionalities, feel free to check out the following link: When filled with our historical data request it looks like this: The overall structure of the required code looks like this: We can pull data for certain stocks with specified start and end days. How to collect historical data using Google Finance API? The good news is that we can use Google Finance API directly via Google Sheets using simple “Excel formulas”. Thus, we can’t retrieve Google Finance data via code. The API is now integrated with Google Sheets. Google Finance API was a tool which allowed us to extract data about stocks and financial assets from Google Finance. What are the alternatives to Google Finance API?.How to retrieve Market Beta using Google Finance API?.How to retrieve Earnings-per-Share data using Google Finance API?.

How to retrieve Price-to-Earnings ratio using Google Finance API?.How to collect historical data using Google Finance API?.I am wondering if this is the best way to accomplish my goal and want to know if Application. if they are done, then paste as values, save and close 4) if not, check 30 minutes later again.the code checks every 30 minutes if all BDH formulas are done.

So the way it should theoretically work is: If Application.CalculationState = xlDone Then With Worksheets( 'Sheet1').UsedRangeĪpplication.OnTime Now + TimeValue( '00:30:00'), 'CheckFormulas'ĪctiveWorkbook.Close Savechanges:= True End If End Sub I have written VBA, but not sure if it works:

However, I do not know when Excel finishes populating Bloomberg data, so it's difficult to determine the time to do 2) and 3). I have an Excel sheet with ~300,000 BDH formulas to download securities prices.

Bloomberg api vba