PrevHomeNext

Problem Solver Answers: Problem Solver, Chapter 17: Bringing Data into Excel from XMIM

Problem Solver, Chapter 17: Bringing Data into Excel from XMIM

Question

Populate an Excel Spreadsheet with the last month of closing prices for the continuous Crude Oil futures contract.

Answer

The following shows the query:

   SHOW 
     1: Close of CL 
   WHEN 
       Date is within 1 month

The following shows a portion of the answers in Excel:

Prev Up Next
Problem Solver, Chapter 16: Using "My Queries" to Store Frequently Used Queries Home Glossary