Database Admin

30.0 GBP

30.0 GBP peopleperhour 技术与编程 海外


I have a combined spreadsheet of invoice charges from October 2021 to February 2023.
This is approx. 650 rows of data. This is shown in the attachment (Example of Original Data).
I need 5 columns populated on a separate tab from this data with the following headings:
1. Date2. Description3. Time/Duration4. Rate5. Amount
This is to be organised like the attachment 'Centralised Costing Sheet'.
The date format on some rows moves between UK (DD/MM/YYYY) and US (MM/DD/YYYY), which would need to be standardised to UK format.








MAKE SURE TO CHECK ALL THE LINKS AS THERE ARE CHART ANNOTATIONS 1- Strucutre retest entry: The Structure Retest Entry Indicator uses a Zigzag indicator to identify high and low points. For a bullish trend, the indicator will draw a line at the peak of the first leg. When the price breaks this peak and then retraces after a specified number of minimum candles, the indicator will give a signal to enter. In a bullish trend where higher highs are consistently being broken, we expect this trend to continue. However, if the high does not break and the low is instead broken, we adjust our approach. In this case, we wait for the price to retrace back to the downside line, following the same principle as in a bullish trend. This approach ensures that the indicator adapts to both continuation and potential reversals in the trend, providing reliable entry signals based on the Zigzag indicator's high and low points. 2- Order Block and Fair Value Gap: OrderBlock: YT Video if further clarification is needed: Supply and Demand indicator source code which is similar to what I want Fair Value Gap: YT Video if further clarification is needed: FVG & OB Combined Use: - The indicator identifies an Order Block using the selected OB Algorithm. - Keep in mind that the Orderblock must be bellow FVG in a bullish trend and above FVG in a bearish trend. - Simultaneously, it identifies a Fair Value Gap based on the defined FVG parameters. - The indicator calculates the distance between the Order Block and the Fair Value Gap. - If the distance is less than or equal to the specified `Maximum Distance Between OB & FVG`, the setup is considered valid. Structure based confirmation: INPUTS (They may vary): 1. Use OB & FVG: True/False 2. Filter: Only Buys/Only Sells 3. Use: Only OB/Only FVG/OB & FVG 4. Entry Type: Middle of the Zone/Start of the Zone/End of the Zone 5. Maximum FVG Size: [Numeric Input] (in Pips/Points) 6. Minimum FVG Size: [Numeric Input] (in Pips/Points) 7. Maximum Distance Between OB & FVG: [Numeric Input] (in Pips/Points) 8. Signal type: on touch, on candlestick close or touch. 9. Structure brake confirmation. 3- Candle Stick Patterns & M and W pattern: The Candlestick Patterns and M/W Pattern Indicator identifies key reversal and continuation patterns to provide trading signals. For candlestick patterns, the indicator detects various formations, such as Rail Track, Cord of Woods, Evening and Morning Star, and generates an entry signal based on pattern completion or confirmation. For M and W patterns, the indicator identifies these formations and provides entry signals either on the breakout of the neckline or on a retest of the neckline. The indicator also allows filtering by pattern strength and size, ensuring that only significant patterns are considered. This approach ensures that the indicator adapts to various market conditions, providing reliable entry signals based on established candlestick patterns and M/W formations. INPUTS (They may vary): 1. Use Candlestick Patterns & M/W Patterns: True/False 2. Filter: Only Buys/Only Sells 3. Pattern Type: Only Candlestick Patterns/Only M & W Patterns/Both 4. Entry Type: 5. For Candlestick Patterns: For Candlestick Patterns: On pattern completion On pattern confirmation (next candle) For M & W Patterns: On breakout of neckline On retest of neckline 6. Pattern Strength Filter: Minim candle count of the M & W pattern 7. Minimum Pattern Size: [Numeric Input] (in Pips/Points) 8. Maximum Pattern Size: [Numeric Input] (in Pips/Points)
80.0 GBP 技术与编程 peopleperhour 海外