Quant Lego

Sometime we need to make Eclipse compatible simultaneously for both 32-bit and 64-bit versions of R. For example, we may have the 64-bit R a...

Background Eclipse is an open source Integrated Development Environment (IDE). As with Microsoft's Visual Studio product, Eclipse is ...

Package RODBC can be used not only for ODBC database connectivity, but also for importing Excel spreadsheet data into R, as shown in followi...

As preparation, first create an ODBC driver connection for SQL Server by Control Panel >> Administrative Tools >> Data Sou...

Environment Windows 7, 64-bit R 2.15.1 (32- & 64-bit) Microsoft SQL Server 2008 Installation & Usage Download JDBC ...

Suppose we retrieve a variable 'Valuation_Date' from SQL database and get following number 2012-01-22 00:00:00.000 We can use c...

Suppose all elements in array1 are contained in array2, now we want to get the indices of array1's elements in array2. Here is a simpl...

Some common commands # Quit R q() q(save="no") # Setting the default working directory setwd(file="c:\\AnyDirectory\\...

Sometimes we want to align, in Excel spreadsheet, a chart with a cell which, for example, may contain a label for the chart. We can easily d...

\documentclass[8pt,onecolumn,letterpaper]{article} \usepackage[top=0.5in, bottom=0.5in, left=1.0in, right=1.0in]{geometry} \setlength{\colum...

Unlike regions with independent power grids, power in the Southern states is provided by integrated power companies. Each of these compan...

There is only a single trading hub in the New England region. The price at thsi hub are based on selected nodes around the Boston area. ...

The New York power grid is self-contained in the state of New York. The southeastern part of this region the most heavily concentrated a...

The Midwest ISO coordinates power for the north-central United States The eastern part of the MISO region is heavily industrial...

The Mid-Atlantic region contains many large population centers, like Washington D.C., Baltimore, and Philadelphia, on the eastern seaboar...

In most years, the Pacific Northwest sells surplus power into California and the Southwest. About two-thirds of all the electricity in t...

The desert southwest has moderate winter and prolonged hot summers Mush of the year, the area has a surplus of generation capacity and i...

California is a heavily populated state that is divided into two major zones: NP-15 and SP-15. Most of the year, the daily temperatures ...

There are three major integrated power grids in the United States: Eastern Interconnect --- east of the Rocky Mountains Western Interconne...

Heat rates Heat rate represent the efficiency of a power plant to convert fuel into electricity ==> Lower heat rate implies a more effi...

Spot vs forward power markets The forward power market is where the bulk of speculative tradings occur, while the spot power market is whe...

It is hard to store electricity and expensive to transmit electricity over long distance ==> No unified national electricity market, ins...

Natural gas prices are a function of market supply and demand. Because of limited alternatives for natural gas consumption or production in ...

The price that residential consumers pay for natural gas has two main parts (all cost components include a number of taxes): Commodity c...

Natural Gas Is a Major Energy Source for the United States About 25% of energy used in the United States came from natural gas in 2011. The...