Fetch (Big) by Tucker McClure

Fetch command useful for SELECT queries on large data sets. (fetch, database, query)

fetch_big(connection, query, varargin)

getargin(args, index, default)

Loading MIMIC II data using windows, matlab and postgre SQL by Shuang Wang

Loading MIMIC II data using matlab and postgre SQL (mimic ii, database, postgre sql)

import_mimicII_data.m

upsert - automatically handles database inserts/updates by Sven

If a data row already exists, UPDATE that row! If it doesn't exist, INSERT that row! (database, insert, update)

upsert(conn,tableName,fieldNames,keyFields,data, varargin)

Mining Economics with MATLAB by David Willingham

Simulates a distribution of Net Present Values of a mine via a forecasting model for Iron Ore Prices (commodities, mining, economics)

FitNPV(NPV)

cashflow(data,NTrials,SYear)

discounting(data,capex,NTrials,sales,discFactorY,salesb)

Pxy Generator for Binary Ideal Solutions - w/Database by David Hagan

The Pxy generator plots the Pxy diagram for a binary ideal solution. (pxy, vle, vapor)

Pxy_GUI(varargin)

Automated Trading with MATLAB - 2012 by Stuart Kozola

Files from the Automated Trading webinar showing X_Trader and QuickFIX/J integration. (algorithmic trading, x_trader, genetic programming)

Algorithmic Trading with MATLAB: Intraday trading

Algorithmic Trading with MATLAB: Moving Average Rule

Algorithmic Trading with MATLAB: Pairs trading

SCOPE: interactively tabulate SEER excel variables by Rex Cheung

This takes SEER excel column data interactively, tabulate them, write back in table format. (data import, data export, optimization)

output=xls2tabulate2xls(xlsfilename)

Credit Risk Modeling with MATLAB by Ameya Deoras

These are the supporting MATLAB files for the MathWorks webinar of the same name. (treebagger, bond, var)

...

Credit_Rating(newData)

GetMigrationFtsCell(id,date,numRating)

a bug-fixed runstoredprocedure.m by Zhiqiang Zhang

There is a bug in the official runstoredprocedure. This file fixed the bug. (database)

runstoredprocedure(c,spcall,inarg,typeout)

Electricity Load and Price Forecasting Webinar Case Study by Ameya Deoras

Slides and MATLAB® code for the day-ahead system load and price forecasting case study. (artificial intelligen..., electricity load, electricity)

Electricity Load Forecasting using Neural Networks

Electricity Price Forecasting with Neural Networks

Load Forecasting using Bagged Regression Trees

Energy Trading & Risk Management with MATLAB Webinar Case Study by Ameya Deoras

MATLAB code for the generation asset risk analysis case study (market risk, cashflow at risk, model)

Calibrating Simulating Natural Gas Spot Prices

Modeling Simulating Hourly Electricity

Modeling Simulating Hourly Temperature

Efficient Frontier GUI by Ameya Deoras

Efficient frontier from Yahoo or database data. (finance, analysis, modeling)

dfdb_port_opt(varargin)

cleanMe.m

Financial Seminar Demos by Ameya Deoras

Demos commonly used at The MathWorks financial modeling seminars. (finance, modeling, portfolio var risk ma...)

PortVaRmc(nsim)

blsimpv(so,x,r,t,call,maxiter,q,tol)

blsvis(varargin)

dbBulkInsert by Willow Yang

fast bulk insert data into database, hundreds of rows per second (database, data output, sql)

cell2list(items, q)

dbBulkInsert(db_srvr, db_table, fieldNames, fieldTypes, var...

dbClose(conn)

Query a database by Matthew Simoneau

Provides a simple call for getting data out of a database. (query, database, error checking)

queryDatabase(db,query)

dynamic_sql_question by Peter Lindberg

How to create dynamic SQL questions. (sql, date, querybuilder)

dynamic_sql_question(choice,startdate,enddate)

MS SQL JDBC connection by Oleg Komarov

Establishes JDBC connection to MS SQL Easier to use than "database(…)" NEW! Windows authentication (sql, microsoft, database)

MSSQLconn(dbname, userpassmethod, varargin)

Multivariate Data Analysis and Monitoring for the Process Industries by Sam Roberts

Files from the webinar Multivariate Data Analysis and Monitoring for the Process Industries (statistics, probability, process)

Multivariate Statistical Process Monitoring of a Copper Pro...

ProcessMonitor

getCurrentProcessStateAsImage()

mysql by Jozef

very simple mysql class file for working with mysql databases. (database, mysql)

mysql<handle

MATLAB no Desenvolvimento de Modelos para Financas by Elia Matsumoto

Slides and demo files using Brazilian market data. (webinar, matlab, financial modeling)

GP(varargin)

GP_Aversao( )

GP_Inic( )

fft by ustc huan

fft code written my me (fft, signal processing)

xn=myfft(x)

Chinese Matlab Digest: Matlab Technical Bulletin by Hong Zhang

Chinese Matlab Digest is the first matlab digest published in Chinese by www.iLoveMatlab.cn (digest, matlab digest, chinese digest)

ECB Statistical Data Warehouse by Wu

Download econometric time series from the ECB Statistical Data Warehouse. (data acquisition, european central bank, macroeconomic)

fECBcsv(cKey)

Energy Bid Stack Viewer by Paul Taylor

Energy Bid Stack Viewer for Australian electricity market (finance, modeling, analysis)

build_data(daily_data,period_data)

create_area_plot(handles)

create_surf(handles)

Library Management using GUI by Prakash Vijapur

Library for storing books and cds. (application, books, management)

DatabaseCell2Mat by Michael Robbins

Converts the cell matrix that the Database Toolbox provides into a numeric matrix and a structure. (data import, data export, database)

[mdata,s]=DatabaseCell2Mat(GSData,attrval)

txt2db by Michael Robbins

Takes a delimited text file and populates a database table with it. (data import, data export, table)

txt2db(sfilename,scoldelim,sdbname,sdbuser,sdbpassword,stln...