Archive

Posts Tagged ‘pivot’

Fx Winning Method Pro

January 19th, 2012 Comments off

FOREX WINNING METHOD PRO
Execution Rules.
The trading method works as follows:
1. The system work with daily pivot, Resistant, and Supports.
2. Sell Order Signal
From the daily pivot line the EA calculates 20 pips down, after the 20pips, the 21st pips bellow the pivot will start the selling signal as indicated on the attached picture.
3. Buy Order Signal
From the daily pivot line the EA calculates 20 pips up, after the 20pips, the 21st pips above the pivot will start the buy signal as in…

Categories: Programming Tags: , , , , , ,

Help With Sql Server Pivot (cross-tab) View

July 25th, 2011 Comments off

Need immediate help with a complex Pivot View in Sql Server. Details will be given upon acceptance of job

Categories: Server, SQL, SQL Server Tags: , , , , , ,

Modify & Create An Ea

February 23rd, 2010 Comments off

Need to modify an existing EA with Ichimoku and EMAs and also need to develop a simple EA using zigzag & fractals points.

For some understanding about the ichimoku please visit the following website:
http://www.forexfactory.com/showthread.php?s=fbc29921c55af7a9824ce23413b2c2f3&t=190646

I’ve already developed the EA but need to change some functions and remove certain unnecessary codes.

For zigzag and fractals calculation please check
https://www.scriptlance.com/f/?126692824587121839.

It’s a pure mathamatical formula. Need to identify the pivots points base on the ZigZag and Fractals.

When u check the excel sheet you will get the exact information about the calculations base on the Pivot 1,Pivot 2,Pivot 3.

Mt4 Pivot Xover Ma Indicator

January 23rd, 2010 Comments off

I am looking for a MT4 programmer to code a Pivot crossover moving average custom indicator to work with Metatrader 4.

I am also looking to create a consolidation breakout indicator.

Patrick

Javascript Extjs

January 14th, 2010 Comments off

- expert in javascript
- must know extjs 3.
- build a pivot table using extjs.
- you can use existing components in extjs such as grid ( column header grouping ) and gridtree.
- the data will be supplied to you via a xml format e.g. http://somedomain/pivot_data.xml which you will need to parse.
- I can email xml format if need to know.
- the pivot table should also be able to display within the portal component of extjs or just standalone ( but still within the extjs environment )
- This is the beginning of a big project, so please build the component with extensibility in mind. e.g. see http://www.extjs.com/learn/Tutorial:Writing_a_Big_Application_in_Ext
- you must have some examples of previous extjs projects.

Mt4 Ea Required. Pivot Trader

December 24th, 2009 Comments off

Hi There

I require an MT4 EA programmed that includes the following:

- The strategy uses Elliot Oscillator and Pivots Points (monthly, weekly, daily) – i have code for these in ninjaTrader
- Strategy basially enters buy/sell at a pivot point based on Elliot oscillator (level, colour,gradient), using both limit and stop orders for entry
- Every entry has a Limit and stop order which are placed with the entry and are based on the pivot lines
- It uses 4hlyr and hrly time frames
- The strategy can have multiple trades open at one time, and the limit orders of open trades are updated daily based on pivot points
- The strategy only trades at 18:00 Sydney time, but updates its limits (targets) at 00:00 Sydney time daily
- Requires back testing over 4 years accross 1hr and 4hrly bars
- Requires chart visuals on all enters and exits of the trade (to see where enters and exists are)
- The required EA needs to be able to place actualy trades on a live account. Its not just an indicator i want build, but an actualy auto-trader

Payment terms:
1/3rd upfront
1/3rd on delivery of a working time locked demo
1/3rd on finalisation of bug testing.

Delivery date required:
I think this is really only about an 4 – 8hr job for an experience developer, so delivery within 1 weeks from 1st payment is plenty of time.
If you think it will take longer then thats fine as well, as long as its not too much longer.

I have about 5 other projects available after the successful delivery of this project.

Thank-you and happy bidding!

Categories: C/C++ Tags: , , , , , ,

Excel Vba Pivot Table

December 11th, 2009 Comments off

Hello

I have a workbook with multiple Pivot Tables.
The name of each Pivot table contains the word “week” or the word “month”.
I need you to do a form for year, month, week, “company” and “type”, selection.
With this selection, you must:
1- fill a cell with selected
2- apply selection in many pivot tables. If pivot table contains the word “week”, then you must apply “week” selection, and if contains “month”, then apply month selection.
3- apply company and type selection to all the Pivot Table.

One of the sheets, will contain the list of years, month, week, company and type.
In all the if statement, if a field does not exist, then resume next.

The form must open with a button.
Must run in Office 2007 and XP.
You must do it using VBA (open code).
Scrow Payment.

If you are Excel expert, then this may take max 4 hours

Thanks

Excel – Vba – Pivot Table

December 9th, 2009 Comments off

Hello

I have a workbook with multiple Pivot Tables.
The name of each Pivot table contains the word “week” or the word “month”.
I need you to do a form for year, month and week selection
With this selection, you must:
1- fill a cell with selected
2- apply selection in many pivot tables. If pivot table contains the word “week”, then you must apply “week” selection, and if contains “month”, then apply month selection.
One of the sheet will contain the list of years, month and week.

The form must open with a button.
Must run in Office 2007 and XP.
I have to be able to adjust it to 2 or 3 different cases (minor changes to open source).
Scrow Payment.

Thanks

Forex Metatrader Ea Mq4

August 12th, 2009 Comments off

Metatrader EA Required to place trades (pending orders) on pivot levels if a moving average has already crossed a level. Alert me when it next crosses a level.

Please note, the EA comes alive or I turn it on, it then must look back and work out if MA has crossed up or down a level.

And I do expect you to test this EA works before sending me the file.

Detail:

Place pending order trades at pivot levels above and/or below one or 2 moving average lines. So I want to use either one or 2 Moving averages.

Places pending orders ready to open at Pivot levels if x moving average (x being number I enter so for exmaple 5 MA or a 13 MA)

Option to have 2 MA crossing pivot levels so have one or other or both.

If it (MA) has crossed pivot point level place a pending order above MA at the pivot level if it is going down or if MA is rising and crosses pivot level place a pending buy at the immediate pivot below the MA so that when the price candle touches it it opens. Then it closes the other. (OCO)

I will include the indicator code for pivot levels for you to use.

I need to be able to turn levels on or off and be customisable, i.e allow buy sell at H3, H4, R2, R1, M2 etc in other words I need to be able to individually select which pivots I want to use/be live levels.

My thought is once this is coded for one it will be a case of repeating the code for each pivot. More repetitive than complicated.

Need to enable buy or sell on pivot depending on direction of MA so if MA has crossed and is going down (one or both the MAs) then sell at pivot above MAs
or if MAs are rising then buy at pivot below MA(s)

Also need time constraint avalable so I can specify when the EA should run, i.e run between 09:00 and 1400 hrs GMT

I also need a option buy or sell depending on MA direction, or, buy and sell. I will call this “momentum or both”.
Explain: So if MA is going up and has crossed R1 level then the momentum option will place a buy at R1 (behind MA). If “both” option is selected then another pending order would be placed at the pivot above the MA line as well (so one above and below) at (presumably) PP line.

Once one is hit the option to OCO must be available (so i can choose whether OCO or not)

To to explain this in a real scenario:

Imagine a box. The top of the box is H2 and the bottom is H3. Price MAs are in the middle of the box going up, they crossed H3 going up an hour ago. At 0900 gmt I enable the EA. It calculates MA is rising (one or both MAs are rising up through level) and has entered the box travelling upwards.
If option “momentum” is selected then a pending buy order is placed at the pivot level BELOW the MA (the bottom of the box). This pending order is good until the next pivot level is breached by MA.

If option “Both” is selected then as above but the EA will place a pending order at the bottom of the box on H4 to buy and ALSO at the top of the box (H3) to sell. Both pending orders remain good until one is touched and opened. If I have selected OCO as true then it wll close the other pending order.
I need to tell it how many trades it can do while it is on.

I need to set the TP/SL level as a number or next level.

This is a long explanation but in essence place a buy or sell or both at pivot levels on the pivot levels I have decided I want live.

Once it has done a trade thats it, no more for the time period allowed, I don’t want it opening multiple trades unless I have enabled 2, 3, 4 etc.

So allow x live trades by EA while it is on or unlimited option please.

More real life example:

EA starts at say 08:00 gmt. The MA 13 and and MA 30 have both already crossed DOWN through H3 pivot line. The EA looks back and calculates this and places a pending sell order at the pivot level ABOVE MAs (in this case H4 assuming mid pivots have not been enabled). TP will be the next pivot/cam/mid pivot level. SL is user eneterd.

Pending order is placed and stays in place until the next level is broken by MA.

This will work on a 5 minute chart. I will use visual backtesting so it needs to leave a marker on the screen of where it enetered.

Lot size entered by user

I have a manage trade EA which code is also available. I would like the option to use this incorporated into the EA, so if the manage trade EA was enabled then TP would be infinite. This needs the option to change whether close 1/3 or half or all at first level.

Any more Qs please ask. I know it reads lot but it is quite simple, MA cross level, when EA come on look back and place order at level. To look back might be difficult.

I would expect you to check it works before sending me the EX4 file. I then check as well. I own source at the end of this.

The above description will be the test document. I will test this via backtest visual and in a demo account.

Metatrader Ea

August 12th, 2009 Comments off

Metatrader EA Required to place trades (pending orders) on pivot levels if a moving average has already crossed a level. Alert me when it next crosses a level.

Please note, the EA comes alive or I turn it on, it then must look back and work out if MA has crossed up or down a level.

And I do expect you to test this EA works before sending me the file.

Detail:

Place pending order trades at pivot levels above and/or below one or 2 moving average lines. So I want to use either one or 2 Moving averages.

Places pending orders ready to open at Pivot levels if x moving average (x being number I enter so for exmaple 5 MA or a 13 MA)

Option to have 2 MA crossing pivot levels so have one or other or both.

If it (MA) has crossed pivot point level place a pending order above MA at the pivot level if it is going down or if MA is rising and crosses pivot level place a pending buy at the immediate pivot below the MA so that when the price candle touches it it opens. Then it closes the other. (OCO)

I will include the indicator code for pivot levels for you to use.

I need to be able to turn levels on or off and be customisable, i.e allow buy sell at H3, H4, R2, R1, M2 etc in other words I need to be able to individually select which pivots I want to use/be live levels.

My thought is once this is coded for one it will be a case of repeating the code for each pivot. More repetitive than complicated.

Need to enable buy or sell on pivot depending on direction of MA so if MA has crossed and is going down (one or both the MAs) then sell at pivot above MAs
or if MAs are rising then buy at pivot below MA(s)

Also need time constraint avalable so I can specify when the EA should run, i.e run between 09:00 and 1400 hrs GMT

I also need a option buy or sell depending on MA direction, or, buy and sell. I will call this “momentum or both”.
Explain: So if MA is going up and has crossed R1 level then the momentum option will place a buy at R1 (behind MA). If “both” option is selected then another pending order would be placed at the pivot above the MA line as well (so one above and below) at (presumably) PP line.

Once one is hit the option to OCO must be available (so i can choose whether OCO or not)

To to explain this in a real scenario:

Imagine a box. The top of the box is H2 and the bottom is H3. Price MAs are in the middle of the box going up, they crossed H3 going up an hour ago. At 0900 gmt I enable the EA. It calculates MA is rising (one or both MAs are rising up through level) and has entered the box travelling upwards.
If option “momentum” is selected then a pending buy order is placed at the pivot level BELOW the MA (the bottom of the box). This pending order is good until the next pivot level is breached by MA.

If option “Both” is selected then as above but the EA will place a pending order at the bottom of the box on H4 to buy and ALSO at the top of the box (H3) to sell. Both pending orders remain good until one is touched and opened. If I have selected OCO as true then it wll close the other pending order.
I need to tell it how many trades it can do while it is on.

I need to set the TP/SL level as a number or next level.

This is a long explanation but in essence place a buy or sell or both at pivot levels on the pivot levels I have decided I want live.

Once it has done a trade thats it, no more for the time period allowed, I don’t want it opening multiple trades unless I have enabled 2, 3, 4 etc.

So allow x live trades by EA while it is on or unlimited option please.

More real life example:

EA starts at say 08:00 gmt. The MA 13 and and MA 30 have both already crossed DOWN through H3 pivot line. The EA looks back and calculates this and places a pending sell order at the pivot level ABOVE MAs (in this case H4 assuming mid pivots have not been enabled). TP will be the next pivot/cam/mid pivot level. SL is user eneterd.

Pending order is placed and stays in place until the next level is broken by MA.

This will work on a 5 minute chart. I will use visual backtesting so it needs to leave a marker on the screen of where it enetered.

Lot size entered by user

I have a manage trade EA which code is also available. I would like the option to use this incorporated into the EA, so if the manage trade EA was enabled then TP would be infinite. This needs the option to change whether close 1/3 or half or all at first level.

Any more Qs please ask. I know it reads lot but it is quite simple, MA cross level, when EA come on look back and place order at level. To look back might be difficult.

I would expect you to check it works before sending me the EX4 file. I then check as well. I own source at the end of this.

The above description will be the test document. I will test this via backtest visual and in a demo account.

Excel Pivot Table Project

August 10th, 2009 Comments off

Create a bottom up budget from existing Database info in excel with pivot tables. By customer, with history info from previous years, split by Net value, Replenishment and total. Viewable by Sales Representative. The pivot table layout should then be copied to a static worksheet with columns where the sales reps can manualy enter their budgets/ forecasts.

Excel Vba Pivot Table

April 5th, 2009 Comments off

Hello
I need a user form in Excel which allows searching and selecting Pivot Items of Pivot Field in Pivot Table.

I posted this before. I have the macro that does almost all I need (one in excel 2003 and another in excel 2007), but have some problems that need to be solved and a little change in Excel 2007 version.
It has been developed with msflxgrd.ocx and msdatagrd.ocx controls, but windows update (KB960715) is causing me problems with those ocx.
If I uninstall that update, this works fine in xp but is not working in 2003 server (don

Excel Pivot Table Search/selec

March 20th, 2009 No comments

I need a user form in Excel which allows you to search and selection of items Pivot Field in Pivot Table.

I have Pivot TableS with pivot fields such as “book” or “customer” or “Invoice”. Each of these pivot field may have 20000 Pivot Item.

The User Form must:

deploy a combination of keys

allow searching in any of these fields (the user selects that pivot field will search)

the search must allow the use of wildcards (eg “book” contains “owne * manu).

display a list of all the pivot item containing “owne * manu”

Allow selection of 1 or more of the pivot item shown in the list

confirm selection

return to the Pivot Table by selecting the items marked on the user form and hiding the rest

Must work quickly, keep in mind that the pivot item may be several thousand.

It must work in Excel 2003 or 2007 .

The user must form a mark that achieves this selection to every pivot table of the active sheet or sheets of the active workbook.

The userform will be stored in a book in the XLStart folder.

I use Excel 2003 or 2007 with a Spanish version . I have to be able to adjust it to 2 or 3 different cases (minor changes to open source).

I will deliver a dynamic table in 2003 and another version in 2007 for testing verion.

Scrow payment

Bear