EVE Technology Lab

First I began doing this manually in notepad in game: For example this is what I want to do in Excel and have it as automated as possible

B) Jita Sell C) Buy P/U Average D) Profit Per Unit E)Units Bought F)Total Isk Spent G)Total Earned In Sell
H)Total Profit I)Profit Margin


Tripped Power Circuit
B)$79,000.00 C)$58,512.00 D)$20,488.00 E)201 F)$11,760,912.00 G)$15,879,000.00 H)$4,118,088.00 I)25.9341772152

Basic Math
Tripped Power Circuit: bought 201 @ 58512 = 11,760,912
Jita Sell @ 79000 x 201 = 15,879,000 - 11,760,912 = 4,118,088 Per day
D/B = Profit Margin of 25%

Now I can do this manually in excel as you can see but having a couple hundred orders will be too tedious. Because to do this I have to go to my wallet and count the number of units bought and at "X" price. I also need to find the average buy price, for example: if I buy tripped power circuit at different price points lets say in different regions I have to manually find the average then plug it into excel before I can see the results. Then I have to find the average Jita sell.

Since the market fluctuates I don't see how I can do this manually and maintain my insanity.

TLDR:
Is there a way to import my character's orders into excel as well as the refreshed market data to pull the average Jita sell price.

I have researched the forums but the information out their is either inconsistent or cryptic. For example one person described creating a macro button in excel that pulled your wallet and api information into excel. Yet he described it as though you already know how to do this. And another person talked about using Autodumping and their own C+ program however the thread has been closed and still very hard to understand can be viewed here

I currently use evementat and am familiar with using its functions but I need something to show my profit margins.