家用灯泡瓦特流明比较

watt lumen comparison of led, helogen, energy saving light bulbs
watt lumen comparison of led, helogen, energy saving light bulbs

如今灯泡的种类越来越多。为了便于大家购买灯泡,这里做了一下各种不同电灯泡的光度与用电的比较。

一般房间,台灯用60W(~700lm)的灯泡即可。

 

tractorhelper安卓升级记牌器,拖拉机记牌器

安卓升级记牌器,拖拉机记牌器

记录打出的牌,以及显示所剩的分数。适用于电脑,线下游戏,记牌练习等。

Played-Cards Memory Helper for the famous Chinese card game “tractor”, “level-up” or “shengji” on android

下载

升级记牌器apk:https://tractorhelper.googlecode.com/files/tractorhelper.apk (self-signed)

VPN AutoConnect/AutoReconnect for Cisco AnyWhere Secure Mobility Clients

Cisco AnyWhere VPN自动连接程序

输入服务器,用户名,密码后,这个小程序在后台自动连接VPN。

如需要启动电脑时自动运行,请复制此程序到您的自动启动项里(”所有程序 > 启动”)。

下载 / Download

Windows: http://vpn-autoconnect.googlecode.com/files/vpn-autoconnect-1.0.0.exe

Java (Jar): http://vpn-autoconnect.googlecode.com/files/vpn-autoconnect-1.0.0.jar

注:

1. Cisco AnyWhere? VPN Client必须已安装在电脑上。

2. 只支持Windows系统

3. 程序每十秒检查一次。再输入密码时会开出新的窗口。(登陆大概需要3秒钟时间)

4. 程序启动后会重启vpnui状态显示

5. 状态显示可以通过命令行的–status开启。程序会随状态窗口关闭而关闭

因为Java不支持vpncli里用到的WriteConsoleInput。所以本程序运用JNA以及Java Robot来输入密码。因为Robot的限制,密码只能为字母或者数字。

 

VPN AutoConnect for Cisco AnyWhere Secure Mobility Clients

This program connects / reconnects to the cisco anywhere vpnagent server automatically.

Requirements:

JVM 1.6 and above

Windows

Cisco AnyWhere VPN Client installed

This software stores your vpn configuration (Password in clear text).

Please copy a shortcut of this program to your autorun folder to run it on every computer startup.

解决抓不到SET-COOKIE里HttpOnly Cookie的问题(Java 7)

在sun.net.www.protocol.http.HttpURLConnection.filterHeaderField()里设定如果Cookie为HttpOnly而CookieHandler.getDefault()不是null的话,这个Cookie会被直接过滤掉。

一种解决的方法就是CookieHandler.setDefault(null)。或者使用自己的CookieHandler来读取Cookies。(注:setDefault函数需要new NetPermission(“getCookieHandler”)权限)

public online sources of financial and economic data

World

  • OECD.StatExtracts includes data and metadata for OECD countries and selected non-member economies.
  • EuroNext. Bonds and Equities are available. “Search by Criteria” -> select instrument -> “Data downloads”.

United Kingdom

United States


Foreign Exchange


Equity and Equity Indices


Fixed Income


Options and Implied Volatility


Futures


Commodities


Multiple Asset Classes and Miscellaneous

Example JSON request: The link below asks CME server to return back options data for given strikes:

http://www.cmegroup.com/CmeWS/md/MDServer/V1/Venue/G/Exchange/XCME/FOI/OPT/Product/ES?currentTime=1311084303814&contractCDs=,ESU1%20C1315,ESU1%20P1315,ESU1%20C1320,ESU1%20P1320,ESU1%20C1325,ESU1%20P1325,ESU1%20C1330,ESU1%20P1330,ESU1%20C1335,ESU1%20P1335

Example Yahoo CSV:

http://ichart.finance.yahoo.com/table.csv?s=INTC&a=06&b=9&c=1986&d=2&e=5&f=2008&g=d&ignore=.csv
s: This is where you can specify your stock quote, if you want to download stock quote for Microsoft, just enter it as ‘s=MSFT’
a: start month (’00’ is for January)
b: start day
c: start year
d: end month
e: end day
f: end year
g: interval, ‘d’ for daily, ‘w’ for weekly and ‘m’ is for monthly prices. The default is ‘daily’ if you ignore this parameter.

 

Intraday and Tick data

Google Finance

In Google Finance, intra-day data is available free for several stock markets. The complete list can be found here.

Data is available in several frequencies with the lowest one being one-minute time frame.

The URL format is: http://www.google.com/finance/getprices?i=%5BPERIOD%5D&p=%5BDAYS%5Dd&f=d,o,h,l,c,v&df=cpct&q=%5BTICKER%5D

Example: http://www.google.com/finance/getprices?i=60&p=10d&f=d,o,h,l,c,v&df=cpct&q=IBM

[PERIOD]: Interval or frequency in seconds
[DAYS]: The historical data period, where “10d” means that we need historical stock prices data for the past 10 days.
[TICKER]: This is the ticker symbol of the stock

Symbol Lookup: http://www.google.com/finance

More information: Intraday Data for US Stocks

  • The base url is http://www.google.com/finance/getprices
  • q is the symbol (AAPL)
  • x is the exchange (NASD)
  • i is the interval in seconds (120 = seconds = 2 minutes)
  • sessions is the session requested (ext_hours)
  • p is the time period (5d = 5 days)
  • f is the requested fields (d,c,v,o,h,l)
  • df ?? (cpct)
  • auto ?? (1)
  • ts is potentially a time stamp (1324323553 905)

Yahoo Finance

As with Google Finance, Yahoo allows you to download intraday data for several stock markets. You can get data for 62 exchanges.

Format : http://chartapi.finance.yahoo.com/instrument/1.0/%5BTICKER%5D/chartdata;type=quote;range=1d/csv

Example: http://chartapi.finance.yahoo.com/instrument/1.0/GOOG/chartdata;type=quote;range=1d/csv

[TICKER]: This is the ticker symbol of the security

Symbol Lookup: http://finance.yahoo.com/q?s=&ql=1

More information: More information: Intraday Quotes for Major Stock Exchanges

NetFonds

NetFonds is a Norwegian website. It is THE website you should use if you need tick and bid/ask history data for stocks listed on U.S. stock exchanges.

To get tick data:

http://hopey.netfonds.no/tradedump.php?date=20120423&paper=AAPL.O&csv_format=txt

To get bid/ask price and volume data:

http://hopey.netfonds.no/posdump.php?date=20120423&paper=AAPL.O&csv_format=txt

Type the ticker symbol next to “paper=” parameter followed by the exchange code:
NASDAQ: O
NYSE: N
AMEX: A

The data format (“date” parameter) is YYYYMMDD

The good news is that you can get historical tick data for more than 20 days.
The bad news is that … sorry there is no bad news; there is however another great news: The above link allows you to retrieve real-time tick data too (From BATS exchange).

Stooq

Two periods are proposed here: 5-Minutes and Hourly. The big advantage however is that all the data is available in one compressed file.

http://stooq.com/db/h/

You can also choose to download intra-day data for some specific dates: http://stooq.com/db/

If you do not need low period data then this website will probably become your best source of intra-day data.

Dukascopy

Dukascopy, the Swiss Forex Bank has a nice CSV DATA Export tool. You will not get data for the entire U.S. stock market but you will be able to export CSV data of several ones and for different periods (1 minute, 10 minutes, and 1 hour).

Dukascopy has also intra-day data for several currency pairs and indices (Japan Topix index, Canadian TSX Indiex, VIX, Russell 2000, Russian RTS Index, CAC 40, Futsee 100…)

http://www.dukascopy.com/swiss/english/data_feed/csv_data_export/

 

Historical stock quotes data

FinancialContent
Several websites use historical data provided by financial content.
chron.com is one of them and here is the URL to get the eod data.
http://markets.chron.com/chron/?Method=gethistoricalcsv&Month=7&Page=HISTORICAL&Year=2009
&Range=3&Ticker=[Symbol name]
Just change ‘Symbol name’ with the ticker symbol of the company that interests you.

Yahoo
Yahoo has historical quotes and dividend data for US and many international stock markets.
This is the URL that let you download these quotes.
http://ichart.finance.yahoo.com/table.csv?d=6&e=1&f=2009&g=d&a=7&b=19&c=2004
&ignore=.csv&s=[Symbol name]

You can automatically download quotes from yahoo using the following downloader Yahoo EOD historical quotes .

Google
Google let you download daily and weekly eod quotes for US, Canada, UK, China and Hong Kong stock markets.
Here is the URL to grab this data:
http://www.google.com/finance/historical?output=csv&q=%5BSymbol name]

Investopedia
Investopedia provides end of day quotes, dividends and splits data for the US market.
http://simulator.investopedia.com/stocks/historicaldata.aspx?Download=1&s=%5BSymbol name]

Quotemedia
Quotemedia has US and Canadian stocks historical data.
http://app.quotemedia.com/quotetools/getHistoryDownload.csv?&webmasterId=501&startDay=02&startMonth=02
&startYear=2002&endDay=02&endMonth=07&endYear=2009&isRanged=false&symbol=[Symbol name]

You can automatically download quotes from quotemedia using the following downloader: Quotemedia Historical Quotes.

Dukascopy
Download historical and intraday quotes data.
Click on the dukascopy link, select settings, and then click on ‘Get Data’.

Kumo swcp
Get historical data for the S&P500 stocks in one file.

AOL
Daily, weekly and monthly historical quotes that can be exported in multiple formats.
http://finance.aol.com/.module/download/pfweb/historical/%5BSymbol name]?type=2&symbol=[Symbol name]
&tf=m&gran=d&fromdate=%24%7Bhist.fromdata%7D

MSN
MSN provides eod data for the US stock exchanges.
http://moneycentral.msn.com/investor/charts/chartdl.aspx?D4=1&DD=1&MA0=0&MA1=0&CF=0&PT=7&SZ=0&D5=0&
DCS=2&C1=0&C2=1&width=612&height=258&D2=0&CE=0&filedownloadbt.x=59&filedownloadbt.y=12&symbol=[Symbol name]

 

Historical intraday forex quotes data

Finam

Finam is a Russian website that allows you to get at least two months worth of one-minute Forex data.
You can use Finam to export data for 12 currency pairs, including EURUSD, EURCHF, EURJPY, EURRUB…

http://export.finam.ru/file.txt?d=d&m=5&p=2&df=1&mf=7&yf=2010&dt=22&mt=9&yt=2010&f=file&e=.txt&dtf=4…

Here is how to get Finam data automatically in QuantShare:
One-Minute Intraday Data for Currency Pairs

Forexite

If you are looking for free intraday quotes that goes back several years ago then you should use Forexite. This website provides data for 16 currency pairs and the data goes back to 2001.

Periodicity is one-minute.

URL Example: http://www.forexite.com/free_forex_quotes/2011/11/011111.zip

You can get this data directly into QuantShare by using the following item:
Forex Intraday Data

Stooq

Stooq allows you to download intraday quotes for Forex and commodities very quickly by collecting all data in a compressed file.

– Go to http://stooq.com/db/h/
– Click on the link under “5Minutes -> ASCII” to download Forex, commodities and indices quotes in a zip file

Example:
http://s.stooq.com/db/h/5_world_txt.zip

And here is the corresponding QuantShare downloader:
5-Minute Historical Intraday Data for Forex, Indices and Futures/Commodities

GAIN Capital

GAIN Capital is a leading provider of online foreign exchange trading, asset management, and B2B Forex services.

Gain Capital archive contains historic rate tick data for several currencies. The data contains the following fields: Currency Pair, Date, Bid Price and Ask Price.

Example: http://ratedata.gaincapital.com/2012/04%20April/AUD_CAD_Week1.zip

Dukascopy

Dukascopy is a Swiss Forex bank. It provides free tick data for several FX majors and crosses (Euro vs. Pound Sterling, Canadian Dollar vs. Swiss Franc, Australian Dollar vs. Yen, US Dollar vs. Singapore Dollar…)

You can download tick data here:
http://www.dukascopy.com/swiss/english/data_feed/historical/

You can also download Forex data compiled in other periods (1 minute, 10 minutes, 1 hour, 1 day, 1 week and 1 month)
http://www.dukascopy.com/swiss/english/data_feed/csv_data_export/

The above URL lets you also download quotes for US Stocks and indices.