Spreadsheet builder is a tool for compiling useful tables. It is different from function builder such that we can more easily process larger number of observed companies and order them in rows and columns. We can select from a few most used pre-packaged table structures optimized for different purouses. Bloomberg add-in will adjust the structure based on selected data structure.
Time series table is a useful tool for effectively processing time series data.
In first step select a list of observed securities. It is suggested that in each step you press the Preview button to roughly see how the data is interpreted. This way we make sure to avoid any structural errors.
Next we select data categories for our securities which we want to use. We can select from among a wide spectrum of financial data and metrics. In our simple example we choose the prices of stocks and volume for each observed unit of time .
In our third step we select a time frame. We want to observe changes in prices and Volume from 1st of April until 23th of June. Each unit of time is one day. We can also apply additional parameters, which take care of uniformly presented data without any missing values. This way we can avoid potential errors down the road. We can also select a currency, so that all values can be adjusted to one currency and can be compared if we selected companies from different countries.
In the last step the structure of our data will be shown. We can further change it. We can transpose/rotate our table, change column names, select if we want miscellaneous data to be shown or not etc. By clicking the Insert button our data will be populated in our Excel spreadsheet.
Technical analysis (end of day) is also a useful tool that can be used for analyzing price movements. First we need to download our data into excel and then we will be able to form some charts later.
Again we can select observed elements. For example a few popular companies like Apple, Google, Nvidia. In this case we also decided to compare these stocks to a popular commodity like Gold (XAUUSD).
In the next step we select some indicators using a search bar. Most common ones will be shown by clicking on the search bar. For more complex ones we have to manually search for. In our case we used a popular Bollinger Bands to analize standard deviations and Directional Movement Indicator.
Again the selected time frame will be from 1st of April until 24th of June. To avoid errors in our data that could mess with our charts we can use the option Carry over Last Value. By doing so we eliminate the N/A values in Excel that occur due to breaks in trading durring weekends, off days etc. Empty values could break our charts.
Once we're satisfied with our selection press the Insert button. Bloomberg add-in will automatically compile a data table. At this point we should be careful. Check if the data was inserted correctly or if it was corrupted. If you can notice that there are any date values hidden where there should be only numerical values, use standard Excel tools to correct the mistake and set them to correct value format and adjust decimal points if needed. After doing so data should be fine.
Data can be further analysed. We can now also create charts. We can use standard grahphical Excel tools to do so.
