requirement = LV 96
100 transaction per day = 50 buy + 50 sell = 100 transactions
Link to read up more about trading post:
trading post
I made this file a long time ago to help me maximize the profit from daily trading post.
The calculations are all done already for you.
Excel sheet explanation:
At the top is the list of origins for the items. If you buy from the origin city, it tends to be alot cheaper.
The bottom is the city and this is where you need to do your own leg work. You need to find out how much the items would sell in every city.
Of course the higher you can sell in the city the better your profit would be. Commission and tax is already calculated for you, just change column B every week. The prices change as you complete transaction in that city.
Profit From C : Profit from D : Profit From E
on the end tells you how much profit would be gained from buying from certain origin city. The letters match up with the origin city in that specific city.
You do have to change and update the prices for the origin city and the sell price at each city.
The only row meant to be manually changed by you is:
row 2 for the origin city
column B for the sell price of each city.
everything else has all the formulas inserted.
There is a worksheet for every single regional items in Atlantica. All you gotta do is just fill in the prices yourself. None of the prices I have on this file is current, since I stopped doing this a long time ago.
Good luck.
The file is virus free.
link to download excel file
excel file
100 transaction per day = 50 buy + 50 sell = 100 transactions
Link to read up more about trading post:
trading post
I made this file a long time ago to help me maximize the profit from daily trading post.
The calculations are all done already for you.
Excel sheet explanation:
At the top is the list of origins for the items. If you buy from the origin city, it tends to be alot cheaper.
The bottom is the city and this is where you need to do your own leg work. You need to find out how much the items would sell in every city.
Of course the higher you can sell in the city the better your profit would be. Commission and tax is already calculated for you, just change column B every week. The prices change as you complete transaction in that city.
Profit From C : Profit from D : Profit From E
on the end tells you how much profit would be gained from buying from certain origin city. The letters match up with the origin city in that specific city.
You do have to change and update the prices for the origin city and the sell price at each city.
The only row meant to be manually changed by you is:
row 2 for the origin city
column B for the sell price of each city.
everything else has all the formulas inserted.
There is a worksheet for every single regional items in Atlantica. All you gotta do is just fill in the prices yourself. None of the prices I have on this file is current, since I stopped doing this a long time ago.
Good luck.
The file is virus free.
link to download excel file
excel file