Excel macros workbook

Task

This project needs to be done today.
You will need to be ready to start work upon being hired on 1/12/2020 @ 8am PST (California time).
Please ignore the budget of $999 and bid what you believe is fair.

Excel VBA expert needed to add calculations script/macros to the attached file.
This is a pricing tool.

The user inputs data into the green column headers of the first tab (“input” tab).
The user is interested in 4 items (marked with an “x” in “Check” column A.
Of these 4 items, the user knows the quantity he needs for 3 of them (cells B2, B5, B6)
The user had ordered 1 of the 4 items before at the price and quantity specified (cells I5 and I6).

The user inputs quantity discounts in the “discounts” tab.
There are only four rows here, but the user can add as may as he wants with different quantity ranges.

The “output” tab takes the 4 items the user wants and attempts to calculate pricing based on the quantity requested.

When your script is run it will take the 4 items requested in the “input” tab and create a table in the “output” tab.
It will then attempt to calculate the quantity pricing for the items that had not been purchased in the past (rows 2, 3, and 5 of the “Output” tab). Look inside the calculations to see how the quantity pricing was calculated (F2:I2, F3:I3, F5:I5).
The “Total” (column J of “output” tab) is calculated based on the quantity desired.
Next, your script will calculate the quantity pricing for items that had been ordered in the past (row 4).
Look at rows F4:I4 of the “output” tab to see how it was calculated. Please note, these cell formulas refer to the “discount” tab’s text that is grayed out. The reason it is grayed out is that, the actual workbook will not show any of this gray text. I am only showing it to show you how it was calculated.
After all the rows are calculated in the “Output” tab, the “Total” (row 6) of the “Output” tab is calculated.
Finally, the columns K and L of the “input” tab are populated from the resulting data from the “Output” tab. Feel free to look inside the formulas to see where it comes from.

So, in summary, your script will use the data from the “Input” and the “Discount” tabs to generate the table from scratch in the “Output” tab. Once the “Output” tab is populated, the “Input” tab’s columns K and L will be populated referencing the data in the “Output” tab.

Attachment

price generator 3

Forex Software

Task

Forex Software that can automatically copy trades from my telegram channel

 

Creating an MT4 platform Expert Advisor (EA) Strastegy with management system.

looking to develop an EA on MT4
I need Entries and Exists,
Stop loss and take profit, Draw Down…
Money management System two (Alembex management system and Martingale management system option.
Drawings on chart and Notification Email and pop up.
Details of EA in the attachment
Please disregard the price mentioned below,
A fixed prices for this project will be agreed on with the programmer who will be providing a competitive quotation.

Attachments

EA Details

Alembex System Q&A

DEVELOPER/PROGRAMMER needed Complicated EA or indicator “SIGNAL ALERT” for STOCKS OPTIONS TRADING

I need to build a complicated EA or indicator “SIGNAL ALERT” for STOCKS OPTIONS TRADING (not forex, not binary, not MT4). I use ThinkorSwim, but we would need some MARKET DATA API service. Searching on the web I found this explanatory video on how to scan for Unusual Volume using Market Chameleon. https://youtu.be/PCWD89bq7Cw

Then I learned on SWEEP OPTIONS and the tell, “Aggressiveness” when the buyer is willing to pay near or at the ask price. I found that Bezinga Pro has a great tool for this. https://youtu.be/-WfrYa7ESQo
After watching this Unusual Options Scanner, I need something similar to  this: https://neuromastersoftware.com/optionscanner_special/special_offer.html but it seems it provides last trading day activities, not live.

We would need to optimize or automate my Options trade preference, So I would like an ALERT SIGNAL with the following criteria:
• Order Type
• Expiration
• Bid, near Ask, or Ask Price
• IN % Rank
• IV30
• Volume Level
• Volume vs. Open Interest
• Relative Opt. Volume
• 1 Day Volatility

Check this API services:
https://www.xignite.com/product/global-real-time-option-price-data#/productoverview

https://datashop.cboe.com/web-api

https://product.intrinio.com/financial-data/opra-realtime-options-prices

http://www.iqfeed.net/index.cfm?displayaction=data&section=services

http://www.nanex.net/2019/

https://www.orats.com/options-data-products/

https://cloud.benzinga.com/

https://developer.tdameritrade.com/apis

 

Attachment

STOCKS OPTION TRADING EA

Mt4 EA needed to open and close trades by day of week and time, not price.

Would like to have an MT4 EA that can open and close trades on the basis of time and day of the week.

For instance, “open long Monday 01:30  close Wednesday 13:00, open short, Wednesday 13:00, close trade Friday 09:00″… I would be able to input how many lots… I found this bit of code that might work:

enum daysOfWeek {Monday,Tuesday,Wednesday,Thursday,Friday};
extern daysOfWeek dayOfWeek1=Monday;   extern string timeSlot1=”00:00-00:00″;
extern daysOfWeek dayOfWeek2=Tuesday;  extern string timeSlot2=”00:00-00:00″;
extern daysOfWeek dayOfWeek3=Wednesday;extern string timeSlot3=”00:00-00:00″;
extern daysOfWeek dayOfWeek4=Thursday; extern string timeSlot4=”00:00-00:00″;
extern daysOfWeek dayOfWeek5=Friday;   extern string timeSlot5=”00:00-00:00”;

int OnInit(){
dayOfWeek1 +=1;dayOfWeek2 +=1;dayOfWeek3 +=1;dayOfWeek4 +=1;dayOfWeek5

if ((!isSlotOK(1,timeSlot1)) || (!isSlotOK(2,timeSlot2)) || (!isSlotOK(3,timeSlot3)) || (!isSlotOK(4,timeSlot4)) || (!isSlotOK(5,timeSlot5)) ||

return (INIT_PARAMETERS_INCORRECT);

return(INIT_SUCCEEDED);

Can you help?  My hope is that this would be a small job.

Single excel sheet->break it up into different tabs based on what in a single column.

Source: 1 single xlsx file with one sheet(see below TESTDATA.xlsx).
Goal:
Part 1-I want to have your program be able to have a browse file so I can import the sheet into your program
Part 2-Scan a single column(TypeCode) and make a tab for each TypeCode(about 7-10).  Then copy source data(TESTDATA.xlsx) from the main sheet into those new tabs.
Part 3-Create a tab at the end called Statistics.(See FiNALSampleOutput.xlsx)  On this sheet, I need each of the Part Numbers.(you will need to remove duplicate part numbers(see FAB Tab-source 5 duplicate, remove down to 1)
Then sum the number of the part numbers and put count under Part numbers. (see attached FINALSampleOutput-Tab Statistics)

FINALSampleOutput

TESTDATA

The Most Traded Currency Pairs in Forex ({{current-year}})

More than 50% of trades in Forex market somehow involve the US dollar.

In fact, EURUSD is the most traded currency pair in the world that takes about 30% of the total multi-billion dollar Forex turnover. And it is not surprising, since the economies of the US and the European Union are the largest ones.

Traders prefer such currency pairs because their liquidity and thereby trading conditions are better than that of other pairs.

Probably, everyone would keep trading EURUSD only, if there was no need for diversification.

That is why traders also use other currency pairs. Moreover, their trading volume correlates with the size of the economy in corresponding countries.

So, the British pound, the Japanese yen, the Swiss franc, the Australian, and the Canadian dollars will make up the most actively traded currency pairs together with the US dollar and the Euro.
[ads slot=”ssi-in-article”]

What are the Most Actively Traded Currency Pairs in Forex?

The top 10 most popular currency pairs include the Major ones, as well as several Cross currency pairs.

The most traded pairs broken down by categories:

  • Among the Major pairs and in general – EURUSD;
  • Among the Minor pairs – EURJPY;
  • Among the Exotic pairs – USDHKD.

The full list of top traded currency pairs, as well as their approximate trading volume, is available in the following table:

The most traded currency pairs by volume (2019)
# Currency Pair Volume, %
1 EURUSD 27.95%
2 USDJPY 13.34%
3 GBPUSD 11.27%
4 AUDUSD 6.37%
5 USDCAD 5.22%
6 USDCHF 4.63%
7 NZDUSD 4.08%
8 EURJPY 3.93%
9 GBPJPY 3.57%
10 EURGBP 2.78%
11 AUDJPY 2.73%
12 EURAUD 1.8%
13 EURCHF 1.73%
14 AUDNZD 0.96%
15 NZDJPY 0.93%
16 GBPAUD 0.89%
17 GBPCAD 0.81%
18 EURNZD 0.78%
19 AUDCAD 0.76%
20 GBPCHF 0.73%
21 AUDCHF 0.7%
22 EURCAD 0.7%
23 CADJPY 0.67%
24 GBPNZD 0.64%
25 CADCHF 0.58%
26 CHFJPY 0.57%
27 NZDCAD 0.48%
28 NZDCHF 0.38%

Interestingly, USD/DEM was the most widely traded currency pair before the Euro was introduced. The Deutsche Mark was the second-largest reserve currency in the world at the time, which attracted traders’ interest.

What Does Popularity of Currency Pair Affect?

First of all, actively traded pairs have high liquidity. Since more people are interested in an asset, the easier it is to buy and to sell.

High currency pair liquidity, in turn, enables trades with lower commission costs. The traders call them the trading conditions.

Thus, the EURUSD pair will commonly have the best trading conditions:

  • The lowest spread;
  • Minimum commission for rolling over open positions to the next trading day (swap);
  • No or small commission for opening a trade;
  • Fast trade execution.

Here we should also mention clearer candlestick chart formation (without gaps). It significantly influences the accuracy of the readings of all indicator kinds.

In addition to the trading conditions, the popularity of a currency pair also affects its informational visibility:

  • All sorts of analytics and expert opinions;
  • Trading forecasts and signals are preferably published for the most popular pairs;
  • Regular coverage of events in the news media and reviews;
  • Most guides provide examples specifically for major currency pairs;
  • And so forth.

It is often argued that the top traded pairs are also the most predictable ones. However, this fact is not supported and is based mainly on guesses.
[ads slot=”ssi-in-article”]

The Most Traded Pairs by Region

Most Traded Currency Pairs

The chart shows the currency pairs activity depending on the time of the day. The pairs were selected in such a way as to visually demonstrate the influence of a region on the “tradability” of a pair.

What’s interesting about the chart?

  • The most active trading hours in the Forex market are 7:00-16:00 (UTC). You can expect to achieve the goals within this period. While the lowest level of currency pairs movement is from 3:00 to 7:00 (UTC).
  • The peak of currency pairs’ activity is observed when the London and the New York trading sessions overlap. The most “traded time” is 15:00 (UTC).
  • If countries have the same trading sessions (working hours), the currency pair will be actively traded only within the given session. As you can see in the chart above, USDCAD ignores the London session opening. Other pairs – EURGBP and AUDNZD – do the same.

Install the trading session indicator directly in MT4. By doing so, you won’t have to constantly look at your watch or measure the trading session duration to determine the most active trading time for the selected pair.

The Least Traded Pair

We have listed the most traded currency pairs, but can we identify the least traded ones?

Each list has its first and last number. However, things aren’t that simple when it comes to currency pairs.

To date, there are about 180 different currency names in the world. So, the number of possible currency pair combinations is 16,110.

Hypothetically, we can assume that the SZL/VUV (the Eswatini Lilangeni/the Vanuatu Vatu) pair may be the world’s least traded one. We can also say the same for hundreds of other extremely exotic pairs. However, it’s not possible to determine exactly which one is traded the least.

If we limit the list only to Forex pairs (available in the trading terminal), the least traded ones will be the following:

  • Among the Major pairs – NZDUSD;
  • Among the Minor pairs – NZDCHF;
  • Among the Exotic pairs – GBPHUF.

These pairs have shown the minimum trading volume at the time of this writing.

In Conclusion…

The popularity of a currency pair provides the best trading conditions. Therefore, to start, you better use such pairs.

When choosing a currency pair, make sure to analyze its intraday activity. Some of them are traded only at a specific time of the day.

The trading volume of a currency pair is not a constant value. The numbers and values given in the article were gathered during the writing and may change over time.

title: Most Traded Currency Pairs by Volume ({{current-year}}) – Pie Chart

description: What are the most commonly traded currency pairs in the world? List of 20 the most heavily traded Forex pairs by volume in {{current-year}}. How does the popularity of a currency pair affect trading results? Also, find out which currency pairs are the least traded.

Merging Excel Files, Removing Duplicates

Task:

Column A “Source” labeled “GrowthList” starting on row 7472
I only want to keep records with source GrowthList if the record doesn’t already exist in prior 7472 rows.
(match/de-depe using CEO email address, CEO name as backup)

Deliverable is Master File excel with records removed where Source (Column A) = GrowthList, and where CEO Email OR CEO Name already exists in prior 7472 rows.

Attachment
Master File Use

In-Depth Industry & Ecosystem Analysis

Whether you are building an enterprise web portal or a state-of-the-art website, you always need the right modern tools. Well-built and maintained PHP frameworks provide those tools in abundance, allowing maintained PHP frameworks provide those tools in abundance, allowing developers to save time, re-use code, and streamline the back end. As software development tools continuously change to follow the latest. Despite the competition from startups and the ever-present economic challenges, the banking industry is gradually adopting what the latest technologies have to offer.

From cloud technology to cyber risk management to machine learning in investment banking, join us as we explore the banking industry trends for 2019 and beyond. Cloud is one of the current banking industry trends as well. It is expected that the technology will serve as a foundation for core modernization of banking organizations.

Cloud Technology as New Foundation

Cloud has become the new normal for nine of ten enterprises across industries. The average IT environment in both SMBs and larger companies is becoming increasingly cloud-based. Companies also diversify their delivery models, with Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) gaining more and more traction. Plus, a slew of new job positions have emerged to manage different aspects of cloud in the enterprise, including architecture and safety.

One of the new trends in the banking industry, ensuring fail-safe security will also be a core question regardless of the type of a cloud solution and its scale. Cloud is one of the current banking industry trends as well. It is expected that the technology will serve as a foundation for core modernization of banking organizations.

Risk Management Banking Industry Trends

Existing risk management systems at banking organizations might not be ready to face the challenges of the rapidly changing world. Poised to become the top banking industry trends for 2019 and years to come, AI-driven solutions with machine and deep learning algorithms provide a solution. As for cyber risk management, experts at Deloitte point at the following trends in the banking industry:

  1. Strengthen basic controls like IT asset, patch, and vulnerability management to identify and manage risks related to implementation of cloud and migration to open architecture.
  2. Use analytics tools and AI with security in mind.
  3. Build an IT infrastructure with security as a top priority: it should be able to withstand systematic attacks and long stress periods.
Risk Management Banking Industry Trends

Fintechs and nonbanks now have a substantial influence in the banking industry. They are highly agile, innovative, and aim at exceeding the demands of modern customers in banking services and experiences. Established retail banks need to compete and often play catch-up. Still, they acknowledge the need to change, and change fast.

There are no secrets to success. It is the result of preparation, hard work, and learning from failure.

– Paul Tournier

Thus, adopting the same approach is a potent solution for retail banks that aim at adopting the latest trends in the banking industry quickly and impactfully.

5 Questions for Connected Product UX

Whether you are building an enterprise web portal or a state-of-the-art website, you always need the right modern tools. Well-built and maintained PHP frameworks provide those tools in abundance, allowing maintained PHP frameworks provide those tools in abundance, allowing developers to save time, re-use code, and streamline the back end. As software development tools continuously change to follow the latest. Despite the competition from startups and the ever-present economic challenges, the banking industry is gradually adopting what the latest technologies have to offer.

From cloud technology to cyber risk management to machine learning in investment banking, join us as we explore the banking industry trends for 2019 and beyond. Cloud is one of the current banking industry trends as well. It is expected that the technology will serve as a foundation for core modernization of banking organizations.

Cloud Technology as New Foundation

Cloud has become the new normal for nine of ten enterprises across industries. The average IT environment in both SMBs and larger companies is becoming increasingly cloud-based. Companies also diversify their delivery models, with Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) gaining more and more traction. Plus, a slew of new job positions have emerged to manage different aspects of cloud in the enterprise, including architecture and safety.

One of the new trends in the banking industry, ensuring fail-safe security will also be a core question regardless of the type of a cloud solution and its scale. Cloud is one of the current banking industry trends as well. It is expected that the technology will serve as a foundation for core modernization of banking organizations.

Risk Management Banking Industry Trends

Existing risk management systems at banking organizations might not be ready to face the challenges of the rapidly changing world. Poised to become the top banking industry trends for 2019 and years to come, AI-driven solutions with machine and deep learning algorithms provide a solution. As for cyber risk management, experts at Deloitte point at the following trends in the banking industry:

  1. Strengthen basic controls like IT asset, patch, and vulnerability management to identify and manage risks related to implementation of cloud and migration to open architecture.
  2. Use analytics tools and AI with security in mind.
  3. Build an IT infrastructure with security as a top priority: it should be able to withstand systematic attacks and long stress periods.
Risk Management Banking Industry Trends

Fintechs and nonbanks now have a substantial influence in the banking industry. They are highly agile, innovative, and aim at exceeding the demands of modern customers in banking services and experiences. Established retail banks need to compete and often play catch-up. Still, they acknowledge the need to change, and change fast.

There are no secrets to success. It is the result of preparation, hard work, and learning from failure.

– Paul Tournier

Thus, adopting the same approach is a potent solution for retail banks that aim at adopting the latest trends in the banking industry quickly and impactfully.