Hi. Im quite new to bloomberg and using the excel add in.
I have a question regarding WTI Crude Oil, but it can be for any given stock or security.
I want to pull out historical data, preferably in a table.
I want to see the price of the comdty (CL1) at a given time period, and price at a exact given "opening" and "closing" time. This on a day to day basis.
For example between 09:00-15:30 NY time, so "opening" price (the prise at 09:00) at 09:00, and "closing" price at 15:30. And in between the period knowing the high, low and average during the timeperiod i select. Extended back as far as possible.
Here is a table i manually created.
Regards Nick
I have a question regarding WTI Crude Oil, but it can be for any given stock or security.
I want to pull out historical data, preferably in a table.
I want to see the price of the comdty (CL1) at a given time period, and price at a exact given "opening" and "closing" time. This on a day to day basis.
For example between 09:00-15:30 NY time, so "opening" price (the prise at 09:00) at 09:00, and "closing" price at 15:30. And in between the period knowing the high, low and average during the timeperiod i select. Extended back as far as possible.
Here is a table i manually created.
| CL1 Comdty | ||||
| Dates | Open at 09:00 | Close at 15:30 | High (between 09-1530) | Low (between 09-1530) |
11.10.2020 9:00 | 40,4 | 40,13 | 40,45 | 39,93 |
12.10.2020 9:00 | 39,41 | 39,47 | 39,64 | 39,3 |
13.10.2020 9:00 | 40,26 | 40,25 | 40,35 | 40,05 |
14.10.2020 9:00 | 41,01 | 41,07 | 41,29 | 40,92 |
15.10.2020 9:00 | 40,8 | 40,96 | 41,05 | 40,66 |
Regards Nick
