Terminé

Create VBA code as a macro (or some way) to calculate automatically

A small job. Need someone to make a excel-macro (or any other way it can be done) to do a series of calculations on a sheet of excel workbook. It's a small job. Details will be discussed.

Look into the file
Turnover Calculation:
TurnOver (as per Income Tax) = Sum of ((abs(Profits)) + (abs(Losses)))
Profit or Loss = Sell Value - Buy Value
Buy / Sell Value = Quantity x Rate

A trade is 1 Buy transaction + 1 Sell Transaction.
On a particular date, either there's 1 trade or many.
To calculate TURNOVER trade-wise, QUANTITIES of Buy and Sell need to match.
(As one can only sell what one has bought!)

A trade is 1 Buy transaction + 1 Sell Transaction
but 1 transaction may not have happened in 1 step

take sum of G2 to G13
then
match the total you got with G14

ALso, if you noticed F2 to F13 says "S" meaning Sell
BUT F14 says "B" meaning Buy

Numbers won't match necessarily by dates. Because a person can buy today sell tomorrow or even later.

If total "S" quantity is matched to total "B" quantity then that's 1 trade.

The attached file has been updated.

Please refer to column "I" in blue and to its right

I have tried to calculate TURNOVER for total of 2 trades in the attached file.
Click on cell to understand formulas used

1. Calculate Amount (column "Quantity" x column "Rate")
2. Get a total of entries in column "Quantity" while referring to column "Type". So, if data starts with "S" go on adding "Quantity" until "B" is found in "Type"
3. If "B" is found in "Type" - refer to column quantity
4. Is the total "Quantity" column which has "S" = "Quantity" found for "B"
5a. If yes, populate columns "Total S" and "Total B"
5b. Calculate "Profit or Loss" in column L. Where, Profit or Loss = Total S - Total B
5c. Take the "Absolute Figure" from column L to column M
5d. Trade 1 complete
6. Move to row 15 to begin calculation for Trade 2
7. Notice -- entry F15 is "B" and G15 = 75
8. Notice -- entry F16 is "S" and G16 = 75
9. As quantities matched this becomes a complete trade. Trade number 2.

Compétences : Traitement de Données, Excel, VBScript, Visual Basic

en voir plus : vba code create xml, vba code create pdf file access 2007 report, vba code create xml files, excel vba calculation automatic, excel turn off auto calculate vba, excel macro tutorial for beginners, how to use macros in excel, excel macros for beginners, excel macros, excel macros 101, excel vba calculation mode, vba code calculate critical path, excel data create xml vba code, create domain class excel vba code, vba code macro word excel, vba code automatically generate xml file, vba code create sql database open sql database, create thumbnail code sample vba, create xml format file vba code, vba code calculate early start early finish

Concernant l'employeur :
( 3 commentaires ) New Delhi, India

Nº du projet : #17814715

Décerné à:

AkilaArun

Hi, I can get this done right away. A macro with an execute button should do the job. Looking forward to hear from you to proceed. Best Regards, Akila.K

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% INR en 0 jours
(37 Commentaires)
4.9

21 freelance font une offre moyenne de ₹1174 pour ce travail

paulodayto08

Hi Good day! A serious freelancer here! I have a lots of available time to this work. I can help you to complete this work, but need to know the full requirements to assess how long would it take to complete Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 0 jours
(16 Commentaires)
3.5
Mokshith30

Hi I am "VBA Developer". Expert in Web Scraping & VBA Macros.. Outlook Automation i can scrape any website.. & Python programming, Google Apps Script coding, Wordpress Developement, HTML, VB.Net I will do Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(9 Commentaires)
2.7
abhaya2

Hi, I am an expert in excel and will do this perfectly

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(1 Évaluation)
2.7
maguirrer

Hello, I can help you with this job, please send me a message with a little more information and I can do it inmediately and send you back asap

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(7 Commentaires)
2.4
srijanagrawal21

I have been working on the excel and VBA for more than 4.5yrs. I have good working experience on VBA coding. I have worked from scratch and also modified various VBA codes. I can work on tight deadlines with high accur Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(7 Commentaires)
2.4
noyonuzzamanmout

Dear Hiring Manager, This letter is to express my interest in discussing this position posted on freelancer.com. The opportunity presented in this listing is very appealing, and I believe that my experience and accura Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
MgtEng

Dear Sir/Madam, I have done Macros and I can do this task, Please share the details further. Thank you,

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
Jpg1807

I can work on project with an exceptional amount of energy . I have previously executed many projects which required excellent knowledge of and experience in MS-Excel.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
ksudr1990

I may be new to this site, but I have good experience in this work I will deliver with high quality and ontime delivery.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
vakash628444

I have more than 6 years experience and currently working as a VBA Developer in American Express. It's a global brand name so you can aspect good work within the time frame. I am excellent in vba/macro, excel, sql, ms Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
dhruvsuri

Hello, I am Dhruv Suri and I have been working as a Business Analyst for the past 2 years with a manufacturing company in California. I have professional knowledge of analyzing data on Excel pretty easily and I have al Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
abhi13tri

I have worked on several excel VBA projects and have created files for maintaining inventory, error logging and computing availability of a software based on error logging.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(0 Commentaires)
0.0
suditp

I am good at VBA and logic building. I can build code with good performance

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 4 jours
(0 Commentaires)
0.0
MarcoACV

ill work on this and share a preview with you once ready

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(0 Commentaires)
0.0
nishitgala89

I have created an Excel Macro with GUI that is used for managing Expenses between peoples or Groups. It shows the settlement amount to be shared between people in the group. Its on the same lines as popular expense S Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 14 jours
(0 Commentaires)
0.0