Five Excel security issues

Five Excel security issues
Today we will talk about Excel security issues. In the first part we tried to investigate what kind of mistakes you can face with, using Excel in commodity trading. In the previous part we saw what obstacles can Excel propose for scaling of the company.   #excelshouldbeeliminated   Commodity traders never associate word 'security' with a data security. It is always about the cargo. Thus they insure vessels but not the data about them. However, losing each of those could cause dramatic issues for the company.     Let's figure out how that could happen? Exce...
Read More

Read this carefully if you use Excel #2

Read this carefully if you use Excel #2
In the previous article, we were convinced that if we want to find an extra 10,000 tons in a trade position at a good price, this can easily be done using Excel. However, they will only exist in Excel, and when you need them in real life, you will look for them in the warehouse for a long time until you find out that they were only included in the formula. If this sounds unrealistic to you, be sure that Commodity Technology Advisory (ComTech) knows at least one such real case, which caused a company loss of $ 2,000,000. And how many more preferred not to talk about such “successes” ...   ...
Read More

Case study – LNZ Group

Case study – LNZ Group
Company profile: LNZ Group — Ukrainian vertically integrated agro-industrial holding, specializing in trade in seeds and plant protection products, growing cereals and industrial crops, livestock and grain trading. Formed on the basis of Lebedyn Seed Plant. The company develops agricultural production, seed production and distribution. It cultivates 83 thousand hectares of land and has more than 3 thousand employees per season.   The LNZ Group includes 47 agricultural firms, as well as a specialized plant for the production of corn, a multifunctional plant for the production of whe...
Read More

Excel errors in commodity trading

Excel errors in commodity trading
Imagine, you have two-floor apartment, Lamborghini and high-speed internet, but, instead, of phone you a still using telegraph or Morse language to call people. Such images come to my mind every time I see commodity traders, use Excel to manage operations.Yes, you got it right, these are people, with more than 1 million tones annual turnover still use Excel to manage data that costs millions. But the most interesting thing they don’t think there is something wrong about it, and excel errors can cost them thousands. It’s easy and fast, they say. Okay, here we go. I will write a couple of ar...
Read More

Syngenta – Case study

Syngenta – Case study
Company profile: Syngenta LLC in Ukraine is part of the Syngenta Group - a world leader in the production of plant protection products and seeds. Syngenta Group's goal is to help feed the world safely while caring for the planet, and to increase the sustainability, quality and security of agriculture through world-class science and innovative industry solutions. The group's technologies allow millions of agricultural producers around the world to make more efficient use of limited agricultural resources. In more than 100 countries, the Syngenta Group is working to transform crops and, toge...
Read More

Not to drown in Excel: how a grain trader can move trading to online

Not to drown in Excel: how a grain trader can move trading to online
Digitalization - behind this complicated word lies a process that has changed the world beyond recognition in just a decade. Retail is one of the areas that has benefited the most from new technology, moving more and more online. Today, digitization is beginning to penetrate the field of agro-products trading, but with some difficulty. The leaders of the conservative industry, which historically lags behind other areas of the economy in the use of modern technology, are increasing their IT budgets every year in search of solutions that can increase their income. However, as long as the m...
Read More

Excel slows down the development of grain trading business in Ukraine – Dmytro Mykhalchuk

Excel slows down the development of grain trading business in Ukraine – Dmytro Mykhalchuk
In 2020, influenced by the COVID-19 pandemic, CME (the Chicago Mercantile Exchange Group) abandoned the use of "open protest" in favor of electronic trading. It became the last U.S. grain exchange to take this step. Thus, the entire grain futures trade became computerized. This is just one fact that demonstrates the global trend of recent years in grain trading: the desire of industry participants to maximally computerize the entire trade cycle, from the procedure of entering into transactions to the post-sale execution of contracts related to the delivery of goods, documentatio...
Read More

Use case – Management accounting automation for Omni Partners (Kazakhstan)

Use case – Management accounting automation for Omni Partners (Kazakhstan)
Company profile Omni Partners is a service company providing financial, accounting and IT infrastructure services to a number of legal entities in Kazakhstan. The number of clients serviced by the company - more than 20 legal entities, about 500 employees, more than 6 thousand counterparties. The main activities of the enterprises, which are the clients of Omni Partners LLP, are the production, storage and sale of grain and oilseeds. The aim of the project implementation: To optimize the management accounting for grain trading, to organize its maintenance in a unified system Through th...
Read More

Use case – Maxgrain LTD

Use case – Maxgrain LTD
Company profile Dynamic and growing grain trading company from Black sea region.   MAXGRAIN LTD company has been using GrainTrack for two years, and today it is our main program for accounting in the company. It is very convenient to keep records due to the wide range of functional capabilities. Accounting can be done in the context of contracts, counterparties, invoices and so on. Here GrainTrack makes our work much easier. A big advantage is also the option of exporting contracts, letters and invoices from the system. It's quick and easy to do. We like the flexibility of the ...
Read More

GrainTrack is trusted by grain market leaders in Kazakhstan

GrainTrack is trusted by grain market leaders in Kazakhstan
GrainTrack helps simplify and automate many processes in large agricultural holdings specializing in grain production and sales. A good example is our case for one of Kazakhstan's grain market leaders - a large agricultural producer and international trader.   The firm is one of the top 100 companies of Kazakhstan, its total crop area amounts to more than 270 thousand hectares, and it is a recognized market leader in digitalization and automation of processes.   Client profile: The client is an agricultural producer: farms grow grain, then this grain is sold to their resident an...
Read More