These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Spreadsheet help
Author
Previous Topic Next Topic
Grayclay
Derp Company
Get Off My Lawn
#1 - 2017-01-05 03:13:13 UTC
Hello,

I'm trying to make a spreadsheet for station trading in a single station. My goal is to identify strong opportunities and keep track of them through both profit spread and volume.

I've figured out how to import max buy, min sell, and 7 day average volume, as well as calculate raw spread, % spread, buy order quantity, and sell order quantity.

Is there a ratio I can build with any of the above stats to encapsulate both low volume, high price and high volume, low price items into one catchall performance metric? I've tried a few, but they inevitably fail.
Reibey
Science and Trade Institute
Caldari State
#2 - 2017-01-05 03:19:50 UTC
Grayclay wrote:
Hello,

I'm trying to make a spreadsheet for station trading in a single station. My goal is to identify strong opportunities and keep track of them through both profit spread and volume.

I've figured out how to import max buy, min sell, and 7 day average volume, as well as calculate raw spread, % spread, buy order quantity, and sell order quantity.

Is there a ratio I can build with any of the above stats to encapsulate both low volume, high price and high volume, low price items into one catchall performance metric? I've tried a few, but they inevitably fail.


Exactly what sort of indicators would you like to determine? There are multiple indicators that can be calculated from that data, but it all depends on what you want to make apparent.
Grayclay
Derp Company
Get Off My Lawn
#3 - 2017-01-05 03:31:10 UTC  |  Edited by: Grayclay
Reibey wrote:
Grayclay wrote:
Hello,

I'm trying to make a spreadsheet for station trading in a single station. My goal is to identify strong opportunities and keep track of them through both profit spread and volume.

I've figured out how to import max buy, min sell, and 7 day average volume, as well as calculate raw spread, % spread, buy order quantity, and sell order quantity.

Is there a ratio I can build with any of the above stats to encapsulate both low volume, high price and high volume, low price items into one catchall performance metric? I've tried a few, but they inevitably fail.


Exactly what sort of indicators would you like to determine? There are multiple indicators that can be calculated from that data, but it all depends on what you want to make apparent.


Well, the idea is to have a ratio that shows me the relative ranking of an item's profit ratio weighted against it's volume, while accounting for the actual amount of raw profit so as not to overweight minerals and such. Ideally, a ratio like a QBR - something that generally gathers the overall economic health of an item.
Reibey
Science and Trade Institute
Caldari State
#4 - 2017-01-05 17:07:56 UTC
You're unlikely to get a lot of people, if any, to be forthcoming about an all-encompassing universal indicator and the reason is two-fold:

1. Opsec. This may or may not seem silly but those who have developed indicators of performance have done so through effort and at the expense of both a lot of time and a lot of isk in trial and error. Relying on anything beyond the more simple statistics means that many investments, not all profitable, were behind the refinement of a formula that works for them. Which leads me to the second reason.

2. The relevancy of any performance indicator is completely dependent on your individual trading strategy. There are many opportunities that I personally scoff at that others relish, and vice versa. There are a lot of factors to consider and the idea of an universal indicator that can tell you the potential of any given tradeable good is, unfortunately, a very impractical concept.

That said, you have to ask yourself what sort of data you need in order to make an informed decision based on your particular trading style and risk profile. It's not going to be one convenient number that you can rank (or at least shouldn't be), but a combination of indicators that you will weigh on a case by case basis to judge the desirability of an opportunity.

Identify what you need to know, then work out the math using the data available at hand. The math itself is not the complicated part.
Grayclay
Derp Company
Get Off My Lawn
#5 - 2017-01-05 19:15:36 UTC
Reibey wrote:
You're unlikely to get a lot of people, if any, to be forthcoming about an all-encompassing universal indicator and the reason is two-fold:

1. Opsec. This may or may not seem silly but those who have developed indicators of performance have done so through effort and at the expense of both a lot of time and a lot of isk in trial and error. Relying on anything beyond the more simple statistics means that many investments, not all profitable, were behind the refinement of a formula that works for them. Which leads me to the second reason.

2. The relevancy of any performance indicator is completely dependent on your individual trading strategy. There are many opportunities that I personally scoff at that others relish, and vice versa. There are a lot of factors to consider and the idea of an universal indicator that can tell you the potential of any given tradeable good is, unfortunately, a very impractical concept.

That said, you have to ask yourself what sort of data you need in order to make an informed decision based on your particular trading style and risk profile. It's not going to be one convenient number that you can rank (or at least shouldn't be), but a combination of indicators that you will weigh on a case by case basis to judge the desirability of an opportunity.

Identify what you need to know, then work out the math using the data available at hand. The math itself is not the complicated part.


Thank you for taking the time to write that up and respond to me. I appreciate it, especially given point 1 and understanding how secretive EvE marketeers are (for fear of losing ze profits).

As I poured over this last night, I realized that you're right in that I will basically need to do away with the hope of one overall ranking, and instead find 2-3 indicators that I like, and then do some spreadsheet magic to filter for opportunities that hit the sweet spots for each.

Thanks again for helping :)