Excel VB Macro: Process transactions to create portfolio (VBA)


The script will process Buy/Sell of financial securities (Stocks, Options etc.) in order to create a table displaying the current status of the portfolio (open positions and cash).

There are currently 8 possible Transaction types:

1. Buy

2. Sell

3. Deposit (Cash in)

4. Withdraw (Cash out)

5. Forex (Convert between two currencies)

6. Dividend (Cash in)

7. Fee deduction (Cash out)

8. Tax deduction (Cash out)

In the example file, transaction data is in columns B-L while the rest of the columns (and colors) are used for explanation.

The result table (the portfolio table) is placed in row 23 downwards but in the actual macro it should be placed in a new sheet.

The "tricky" part is that in the portfolio table, the "Average Cost" field for the security needs to be calculated using FIFO.

So, for example,

if I buy a certain security in two different transactions ("layers") first is 100, second is 500 and Sell 150 stocks afterwards,

the first layer sold is from the 100 trans. and the remaining 50 from the 500 trans.

The script also needs to do a lookup in a table stored in the "Symbols" sheet, and populate the NewField1..NewField5 columns with the right value (a default value is also provided).

Cash balances are recorded on rows 30 downwards.

Thank you for your time!

Evner: Excel, Software Arkitektur, Visual Basic for Apps

Se mere: software write mq4, software write chip epson, useful software write book, software write web specs, excel vba create process message, free software write user guide, software write edid, excel vba create installer macro, free software write company profile, software write websites idea, software write book images, software write books, software write protection, vba macro choose excel paste, vba create excel file 2007, excel 2003 vba create xml file, free software write book, vba code macro word excel, excel vba create expense report, software write book, excel vba create data file, vba create xml excel, excel vba create xml file, excel vba create xml document, vba word macro refrence excel range

Om arbejdsgiveren:
( 3 bedømmelser ) Tel Aviv, Israel

Projekt ID: #12543982

Tildelt til:


Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and Flere

$100 USD in 3 dage
(1 bedømmelse)

12 freelancere byder i gennemsnit $202 på dette job


Hi, my name is Sevinc. I read your "Excel VB Macro: Process transactions to create portfolio (VBA)" project descriptions carefully before bidding. I checked the fields required as well... I got what you need and rea Flere

$400 USD in 5 dage
(190 bedømmelser)

Hello Sir Im excel VBA macro and formula Expert :) i can make macro like u need Sir :) please give me a chance for doing your project and im able to start doing your project right now THank You Sincerely Prames Flere

$155 USD in 3 dage
(277 bedømmelser)

Hi there. I have checked your file. What will I do is write the macro for stock options calculation to process stepped in order to calculate FIFO correctly. As being one of the highest rated Excel & VBA expert in this Flere

$347 USD in 5 dage
(120 bedømmelser)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Flere

$250 USD in 2 dage
(81 bedømmelser)
$250 USD in 3 dage
(6 bedømmelser)

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating data from multiple sheets and creating consolidate reports. Flere

$250 USD in 5 dage
(35 bedømmelser)

please clarify deadlines & possible next steps .

$250 USD in 14 dage
(5 bedømmelser)

Hi Employer, I have gone through the requirement. I have pretty much experience with excel reporting, formulas and VBA. I am ready to start work on it immediately also. Please let me know if interested. Tha Flere

$35 USD på 1 dag
(30 bedømmelser)

I can fix this. I need little more time to do it. Since this involve lot of testing. If you are ok with time then please provide the files and I will do it.

$220 USD in 5 dage
(8 bedømmelser)
$155 USD in 3 dage
(4 bedømmelser)
$45 USD på 1 dag
(2 bedømmelser)

I'm expert developing VBA code for Excel spreadsheets. I will be delivering exactly what you need. I'm looking forward to work with you.

$222 USD in 4 dage
(0 bedømmelser)

Hi, I have just read your request. I am an expert with web development experiences of PHP, JSP, Java, C++, Wordpress, jQuery, javascript, kendoUI, ext and so on. Please let me contact with you. Carl

$111 USD in 2 dage
(0 bedømmelser)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have c Flere

$188 USD in 6 dage
(0 bedømmelser)