|
PureBytes Links
Trading Reference Links
|
I have a free open-source add-in that can grab that information for you. The add-in, documentation on its functions, and sample templates can be found in the files area of this Yahoo group:
http://finance.groups.yahoo.com/group/smf_addin/
For example, one function allows you to grab table cells on a webpage. I used this formula on the English version of that page to grab each element of the table:
=RCHGetTableCell("http://www.tse.or.jp/english/market/STATISTICS/e06.html",G$12,"bt_print.gif",,,,$F13)
...where G$12 is a cell I was referring to to tell it which column of the table to pick up and $F13 is a cell I was referring to to tell it which row of the table to pick up. The "bt_print.gif" is just a string it searches for on the page to position itself before it starts looking for the nth table row on the page. The end result, using row numbers from 1 to 34 and columns numbers from 1 to 4 for each row, was:
| Industry | Index | Change |
|
|---|
| Fishery, Agriculture & Forestry | 444.57 |
-5.56 | -1.2% |
| Mining | 760.42 | -11.67
| -1.5% |
| Construction | 783.39 |
-18.74 | -2.3% |
| Foods | 1176.34 | 4.5
| 0.4% |
| Textiles & Apparels | 779.08 |
-15.86 | -2.0% |
| Pulp & Paper | 603.31 |
-11.01 | -1.8% |
| Chemicals | 1331.15 |
-28.12 | -2.1% |
| Pharmaceutical | 2194.61 |
-21.49 | -1.0% |
| Oil & Coal Products | 1695.65 |
-36.23 | -2.1% |
| Rubber Products | 1926.38 |
-18.37 | -0.9% |
| Glass & Ceramics Products | 1532.06 |
-29.47 | -1.9% |
| Iron & Steel | 1507.31 |
-68.93 | -4.4% |
| Nonferrous Metals | 1460.79 |
-53.42 | -3.5% |
| Metal Products | 1259.51 |
-35.12 | -2.7% |
| Machinery | 1458.77 |
-41.78 | -2.8% |
| Electric Appliances | 2266.92 |
-30.03 | -1.3% |
| Transportation Equipments | 2918.27 |
-44.25 | -1.5% |
| Precision Instruments | 4237.37 |
-22.02 | -0.5% |
| Other Products | 2308.51 |
-18.67 | -0.8% |
| Electric Power & Gas | 1073.11 |
-25.66 | -2.3% |
| Land Transportation | 1662.61 |
-47.96 | -2.8% |
| Marine Transportation | 1261.05 |
-46.93 | -3.6% |
| Air Transportation | 613.28 |
-14.85 | -2.4% |
| Warehousing & Harbor Transportation Services | 1922.35 |
-49.39 | -2.5% |
| Information & Communication | 2139.74 |
-26.22 | -1.2% |
| Wholesale Trade | 1304.46 |
-44.48 | -3.3% |
| Retail Trade | 862.03 |
-9.65 | -1.1% |
| Banks | 378.7 | -5.31
| -1.4% |
| Securities & Commodity Futures | 1012.61 |
-15.68 | -1.5% |
| Insurance | 1267.2 |
-21.75 | -1.7% |
| Other Financing Business | 989.71 |
-12.65 | -1.3% |
| Real Estate | 2201.35 |
-80.11 | -3.5% |
| Services | 1113.76 |
-7.75 | -0.7% |
On 4/2/07, Yuki Taga <yukitaga@xxxxxxxxxxxxx> wrote:
>
> At the following link: (if you have a Japanese capable browser)
>
> http://www.tse.or.jp/market/STATISTICS/06.html
>
> you can find the 33 TSE industry groups, how they closed both the
> morning and afternoon sessions.
>
> For years, I have been quickly copying and pasting this data into a
> .csv file that I then import to AB. I copy all four columns, then
> paste into Excel, then copy only the closing value column from inside
> Excel, and paste it over the other three columns. (Something about
> the table prevents copying of individual columns, but I easily put up
> with the tiny extra bit of work.) This gives me a line chart in AB
> by the way, because OHLC are then the same.
>
> Over the weekend, however, they have apparently revamped this site. I
> can copy just like I used to, but when I paste, I am alerted by my
> firewall that my computer wants to connect, repeatedly, to some TSE
> computer (as well as to localhost).
__._,_.___
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
![]()
__,_._,___
|