Skip to Content
0
Former Member
Mar 06, 2008 at 04:36 PM

How to Load Data from WebSite / Email..

73 Views

Hi Experts,

our client is tacking the daily oil market prices from Platts Company.

http://www.platts.com/Market%20Prices/

the above one is the website of Platts, Generally my client will get the oli prices in mail from the Platts Company,

i have seen those mail , it is simple text whey are receiving in mail not in the file format.

How can i load this type of information in BI, for this i have to use web Services ?

if yes, what are the impartent steps i have to take to load data from the website ( or Email )

out client have user id / password for the Platts website, ... Plz some one give me the solution on this how can i achieve this.

here the below is the sample mail what they are receiving .....

PC0320--NWE Benzene: March contract at Eur787/mt, up Eur50/mt- 29FEB08

London (Platts)--29Feb08/0147 pm EST/ 1847 GMT

SPOT BARGES ($/MT) FRIDAY WEEKLY AVERAGE

Fob Rdam 1197.70-1199.80 1193.64-1195.86

CIF ARA 1187.70-1189.80 1183.64-1185.86

CIF ARA M1 (Mar) 1188.00-1190.00 1183.70-1185.90

CIF ARA M2 (Apr) 1180.50-1183.50 1177.00-1179.40

CONTRACT PRICE FD NWE (FEB ) 737.00 (EURO/MT)

The March contract discussions, which were concluded in the last ten

minutes of the assessed week, occupied market thoughts throughout the week.

In a slow build-up, the buying and selling sides partook in an early cease

fire Monday and Tuesday. A short market ensured they would try to keep

their bullets for the Thursday showdown. Trades concluded in the

penultimate day of the month are used by the benzene market to determine a

contract price for the following month. Therefore, the market eased on

Monday, taken lower by the US markets, but then firmed a touch Tuesday.

"When we get in the $1,170s, the buyers step up, but when we get near

$1,190s, the sellers bring it back down," one player said. However, the

pattern of the week was established by Wednesday, when the market was

Contact:(44 20) 7176 6126

www.platts.com/petrochemicals

let me know...any one have any idea on this..

Regards,

SHAIK.

plz need help .....

Edited by: shaik on Mar 7, 2008 4:04 PM

Edited by: shaik on Mar 9, 2008 6:26 PM

Plz .. hope some one have Idea on this.. let me know...

Edited by: shaik on Mar 13, 2008 2:14 PM

let me know...any one have any idea on this..

Edited by: shaik on Mar 15, 2008 10:33 AM

Edited by: shaik on Mar 17, 2008 7:00 AM

Need Help...