439782 Simple Screen Scraping - repost

Main Project: Scrape the data from ForexFactory and reformat into a custom format.

Possible enhanced project options.

1. Provide ability for ongoing update through a macro process. i.e.. on an ad hoc basis append/update the days/weeks events / results.

2. Provide ability to populate future months events in advance and then sync results separately when available on ad hoc basis

The timezone should be set to (GMT +10:00) Eastern Australia.

Note: Daylight Saving Time Shift needs to be taken into account to ensure times are accurate.

[url removed, login to view]

End Daylight Saving: 1 April 2012

Start Daylight Saving: 7 October 2012

End Daylight Saving: 7 April 2013

Start Daylight Saving: 6 October 2013


For enhanced project options ability to configure future Daylight Savings Settings for future data.

Start with Jan 1st 2012 [url removed, login to view]

And increment the month/year until the present day. This will give you all the data to scrape for main project. All the data from 1/1/2012 until the present day is required. The output required is as follows:

Start with a header line as follows:

Date, Time, CurrencyAffected, Impact, About, Actual, Forecast, Previous

The file is then a comma delimited file with a line for each event on forex factory.

"Date" is in format YYYYMMDD and must be present for every entry

"Time" is in a 24hour format HHMM (or otherwise "All Day", for those entries) and must be present for every entry.

"CurrencyAffected" is the same as the "Currency" field from ForexFactory

"Impact" is the colour of the impact field from ForexFactory e.g. either "White", "Yellow, "Orange", or "Red".

"About" is the next field from ForexFactor and is the same as the description from them.

The "Actual", "Forecast" and "Previous" fields are from ForexFactory.

If these three fields are blank, please leave blank. However, if any one of these three fields is present, but one or both of the others are blank, please set the blank field to "-1000000".

E.g. some examples from Jan 2012, and how they should appear in the output field:

Date, Time, CurrencyAffected, Impact, About, Actual, Forecast, Previous

20120101, 11:00, CNY, Red, Manufacturing PMI, 50.3, 49.3, 49.0

20120102, All Day, NZD, White, Bank Holiday, , , ,

20120102, All Day, AUD, White, Bank Holiday, , , ,

20120103, 15:30, AUD, Orange, Commodity Prices y/y, 10.0%, -100000, 17.5%

I have now included an example of the data and formatting that I am after. Please provide a sample file based on the same date range (2013/03/01 to 2013/04/30) to confirm you have a way to handle the Daylight Saving Time Shift.

Row 433 can be used to compare with Row 519 to validate data. Time changes from 1:30am to 00:30am for Crude Oil Inventories due to Row 480 - AUD Daylight Saving Time Shift.

Note: this part of the request is no longer required. Just format as per attached example. (if any one of these three fields is present, but one or both of the others are blank, please set the blank field to "-1000000".)

Beceriler: Her şey Kabul, Excel, Web Scraping

Daha fazlasını gör: web scraping process, reformat data, line manufacturing process, eastern bank, data entry screen examples, custom web scraping, advance excel 2013, excel advance, bank account on line, simple macro, advance manufacturing, advance excel, excel macro scrape data, excel colour, 100000 account, screen scraping php, custom delimited, data entry forex, php daylight, scrape start date web, append line file, excel scrape screen, excel 2013 macro, simple calendar project, excel data update macro

İşveren Hakkında:
( 1 değerlendirme ) Brighton, Australia

Proje NO: #4404597



I have developed a demonstration Excel based ForexFactory scraping solution that silently automates Internet Explorer which meet your requirements. However, I have not examined the Day Light Savings Time issues that y Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 99%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(4 Değerlendirme)

Bu iş için 14 freelancer ortalamada $129 teklif veriyor


Hi sir, please check PM, thx Kimi.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(74 Değerlendirme)

Seasoned web scraper. I worked on many similar projects, I have big experience in data mining projects. I can finish this task in short time, with the best quality.

in %bids___i_period_sub_35% gün içinde225%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)

I have great experience at this [login to view URL] discuss and start off.

in %bids___i_period_sub_35% gün içinde105%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(68 Değerlendirme)

Expert of Excel,ready to start,see PMB please.

in %bids___i_period_sub_35% gün içinde99%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(31 Değerlendirme)

I've a scraper that scrape data from [login to view URL],saved in CSV [login to view URL] check your PMB.

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)

Hello, I can do this work for you and I'm ready to start. Please see pmb for more details. Regards Raul

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)

Hi.. Expert web scraper and excel expert here. Interested in your project. I assure you 100% accurate and good quality work. Ready to start. Regards

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(21 Değerlendirme)

Dear kmac153, I can quickly and cost effectively develop and run a Windows client based automated system to quickly and accurately scrape the data from ForexFactory and reformat into your custom format. for you. Daha Fazla

in %bids___i_period_sub_35% gün içinde126%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

consider it done... please see PMB... regards

in %bids___i_period_sub_35% gün içinde55%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I'll provide the ForexFactory data from 1st Jan' 2012 till April' 2013 in your customized format in both EXCEL and csv. Enhanced project options will be an automation project (can be done as a separate project). 15 mon Daha Fazla

in %bids___i_period_sub_35% gün içinde165%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I'm interested in that project. I experienced perl web developer.

in %bids___i_period_sub_35% gün içinde147%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I am ready to get the work

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I have developed an automated app in .Net which will extract the data in specified format. Also attached data for Jan 2012. Please check my PM.

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)