|
PureBytes Links
Trading Reference Links
|
Hi Randy,
Two questions please:
1) Which of the many add-ins is the one you used?
2) How can I identify cells? (For example, I don't want the headers,
in fact I actually want the final price column, and that's it.)
Best,
Yuki
Tuesday, April 3, 2007, 12:55:19 AM, you wrote:
RH> I have a free open-source add-in that can grab that information for
RH> you. The add-in, documentation on its functions, and sample templates can
RH> be found in the files area of this Yahoo group:
RH> http://finance.groups.yahoo.com/group/smf_addin/
RH> For example, one function allows you to grab table cells on a webpage. I
RH> used this formula on the English version of that page to grab each element
RH> of the table:
RH> =RCHGetTableCell("http://www.tse.or.jp/english/market/STATISTICS/e06.html
RH> ",G$12,"bt_print.gif",,,,$F13)
RH> ...where G$12 is a cell I was referring to to tell it which column of the
RH> table to pick up and $F13 is a cell I was referring to to tell it which row
RH> of the table to pick up. The "bt_print.gif" is just a string it searches
RH> for on the page to position itself before it starts looking for the nth
RH> table row on the page. The end result, using row numbers from 1 to 34 and
RH> columns numbers from 1 to 4 for each row, was:
RH> IndustryIndexChange Fishery, Agriculture & Forestry444.57-5.56-1.2% Mining
RH> 760.42-11.67-1.5% Construction783.39-18.74-2.3% Foods1176.344.50.4% Textiles
RH> & Apparels779.08-15.86-2.0% Pulp & Paper603.31-11.01-1.8% Chemicals1331.15-
RH> 28.12-2.1% Pharmaceutical2194.61-21.49-1.0% Oil & Coal Products1695.65-36.23
RH> -2.1% Rubber Products1926.38-18.37-0.9% Glass & Ceramics Products1532.06-
RH> 29.47-1.9% Iron & Steel1507.31-68.93-4.4% Nonferrous Metals1460.79-53.42-
RH> 3.5% Metal Products1259.51-35.12-2.7%
RH> Machinery1458.77-41.78-2.8% Electric
RH> Appliances2266.92-30.03-1.3% Transportation
RH> Equipments2918.27-44.25-1.5% Precision
RH> Instruments4237.37-22.02-0.5% Other Products2308.51-18.67-0.8% Electric
RH> Power & Gas1073.11-25.66-2.3% Land
RH> Transportation1662.61-47.96-2.8% Marine
RH> Transportation1261.05-46.93-3.6% Air Transportation613.28-14.85-2.4%
RH> Warehousing
RH> & Harbor Transportation Services1922.35-49.39-2.5% Information &
RH> Communication2139.74-26.22-1.2% Wholesale Trade1304.46-44.48-3.3% Retail
RH> Trade862.03-9.65-1.1% Banks378.7-5.31-1.4% Securities & Commodity Futures
RH> 1012.61-15.68-1.5% Insurance1267.2-21.75-1.7% Other Financing Business989.71
RH> -12.65-1.3% Real Estate2201.35-80.11-3.5% Services1113.76-7.75-0.7%
RH> 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
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/amibroker/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:amibroker-digest@xxxxxxxxxxxxxxx
mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|