Page 1 of 108 1234511 ... LastLast
Results 1 to 15 of 1618

Thread: Slopey's BPC Market Tool v3!

  1. #1

    Slopey's BPC Market Tool v3!

    UPDATED TO v4.0.0.0 (0149 UTC 16/12/14) - HAPPY ED LAUNCH DAY EVERYONE!!!!!!!!!!

    THE ONLY WAY TO ADD/UPDATE PRICES IS VIA THE ADD/UPDATE PRICES BUTTON IN THE TOP RIBBON MENU!!!!!!!!!!

    Windows Version: PREFERRED - has price entry: http://www.slopey.com/ED/BPC.exe

    Web version - no price entry just yet: http://elitebpc.com - down for the moment - back soon. (likely Tues 16th)

    Android version - no price entry just yet: http://www.slopey.com/ED/Elite_Companion.apk - will be pointed at the new database tomorrow.

    Hi All,

    The new version (v4) of the BPC is now available, with manual input to populate the data to avoid falling foul of any rules and regs.

    Download from: http://www.slopey.com/ED/BPC.exe

    (Ensure you've uninstalled any previous versions first)

    Run the BPC, and it'll ask you for your ED directory (the FORC-FDEV* one which has the Logs directory in it). It'll then parse the most recent log file to ascertain your current location.

    NB: If the BPC fails to find ED at c:\users\\Local\Frontier_Developments\Products\FORC-FDEV-D-xxxx\Logs then it'll ask. Give it the path to the Logs directory please for your ED install. You can manually edit the path from Options now (no trailing slashes though please).


    Prices are downloaded from the backend database as normal, to add new prices, click on "Add Prices".

    In the Add Prices window, the System should be set automatically if you have VerboseLogging set in the AppConfig, and known stations will be shown. If the station isn't in the drop down list, please add it (nicely - pay attention to capitalisation). Same with the System - if it's not there, add it please.

    Then simply tab and enter data between the commodity field, sell, buy, stock and then click "Add >>" which will add the entry into the below table. It'll focus back on the Commodity drop down.

    Once you've added all the entries you want to, click "Save Data" and they'll be saved to the local database (and uploaded to the cloud).

    The Commodity dropdown supports searching, so to enter something like Coltan, you should only need to type "Col" and it'll match, then Tab and enter sell price, tab to enter buy price, tab to enter stock, and the Tab onto the "Add" button and press Space to trigger it - and it'll jump back to Commodity drop down ready for the next entry.

    I've tried to make it as painless as possible. Still need to do some work on updating existing prices in a simpler fashion, but that'll be in the next update. To correct an entry in the grid, just click on the cell and modify it.

    Anyways,

    Enjoy!

    The Web and Android version will be pointed at this new dataset if people are happy to update it.

    Updates:
    -------------------
    v4.0.0.0

    - the BPC can now adjust your AppConfig.xml for you to add the VerboseLogging="1" if it finds it (in the ../ from the Logs directory), existing one is backed up (as AppConfig.old) in case I make a boo-boo.
    - database persistence (sort of) - the market data is no longer cleared on startup, this will allow entries to persist in your database for evar. Any updates are incremental, but the server only serves the last 72 hours of data still at the maximum. So now data shouldn't "drop off", and the pilot log will be intact. I *MAY* have to re-create the database between updates, but I'll try and do it through scripting, otherwise I'll do something to copy data over.
    - Auto-Update setting is now saved (it wasn't previously)
    - Commodities are again pulled from the server on startup (so I can add new ones)
    - Posting updates to the server is now threaded
    - Added a separate database server - we'll give it a try
    - Backend is now SQL Server, I wasn't getting on well with MySQL and it's unix way of doing timestamps, or it's performance optimising. Over to good olde MS SQL. Yay!
    - Removed the graphs for now - they'll be back when data is more meaningful.




    v3.0.1

    - fixed issue with apostrophes in station names.
    - added a system last update overview grid to the System info tab
    - prevents upload of prices where sell > buy

    v3.0.2

    - you can now set your local timezone in options, and last updated will be displayed in your local time
    - fixed an issue with blank or non-numeric input for prices
    - you can now click on a system in the last updated grid in the System tab to go to that system's prices directly
    - settings should now be preserved when you update the version
    - you can now do an in-place update, no need to un-install/re-install
    - You are now asked if you'd like to download the new version if there is one
    - Distances added in for 750+ systems
    - You can now "stop" a long running search (takes a click or so, persevere!)

    v3.0.3

    - fixed the columns on the grid not hiding/showing properly
    - the distance and return trip no longer fire a search, click the search button to search

    v3.0.4

    v3.0.4 is now up:

    - only the last 72 hours of data are downloaded initially
    - subsequent updates limited to changed data only - far faster!
    - initial population and updates are now threaded, the Search button changes to "Downloading" while updating
    - fixed index out of range error when clicking "Swap"
    - clicking ANY or < Previous no longer starts a search by default
    - the numeric fields on the Add prices screen are now locked to numeric entry only
    - added a "Within Distance" checkbox and value, with this set, only results within distance of To/From are used (it is ignored for Any/Any)
    - Auto-update frequency reduced to 3 minutes (as 1 was a bit overkill), use the Force Data if you really need to
    - Added a toggle for distance from current location on the Commodity data page

    v3.0.5 is now up:

    - fixed bug at launch due to wrongly constructed SQL string (whoops!)

    v3.0.6 is up:

    - fixed another silly SQL bug
    - the BPC should be more tolerant of different regional date formats
    - commodity graphs are working again (but no ANY, and ignore the pie chart for now)

    v3.0.7 is up:

    - squashed a bug with round trip searching
    - even more speed optimisations for updating
    - column ordering in system/commod tabs is now consistent

    v3.0.8

    - in which Slopey learns the value of correctly parametrising SQL queries - Doh!!!!

    v3.0.9

    - Fixed the date/time bug on startup
    - Fixed an issue whereby the BPC would crash if there was no new data update
    - Added "Current" system button to System data page
    - Added checkbox option to make system page auto update
    - put the Any <> Any search prompt back in (warning about duration)
    - Grid formatting is now saved and restored between launches for the BPC, System and Commod grids
    - To reset the grids back to the default use the button on the Options page

    v3.0.9.2

    - Removed the edit context menu which is irrelevant until local mode is back
    - Better handling of downloading the dataset if it fails on the first attempt.

    v3.0.9.3

    - Fixed an issue when downloading an update fails after a while.

    v3.0.9.4

    - No idea, but it was probably good.

    v3.0.9.5

    - Added a different server to improve download times.


    v3.0.9.6

    - Use the faster web server
    - Use the bigger database server
    - Added distances released by Micheal Brookes.

    v3.0.9.7

    - fixed the issue with distances not showing
    - the add/update price now populates with the last data for the commodity if there is one

    v3.0.9.8

    - Updated the add prices routine to hopefully make it far faster

    v3.0.9.9

    - Fixed missing commodity types when updating
    - Re-indexed the local database to add missing indicies (thanks for the heads up Cyb)
    - increased auto-update time to 5 mins
    - The BPC will no longer auto-update while you're adding prices

    v 3.1.0.0

    - Moved the database off of Amazon RDS - far too slow, and consumes all the connections at 3AM for no reason???
    - added the PilotLog of visited systems (not saved between updates for the moment, just testing it works)
    - sped up the Add prices code by an order of magnitude (hopefully)
    - fixed a bug with duplicate entries showing
    - fixed an issue with updates not recording the timestamp

    C:\> Cannot find Reality.sys. Universe Halted.

    Slopey's Elite: Dangerous Best Profit Calculators!:
    Now retired - other market tools are available.
    Alleged destroyer of the entire Universe economy.

  2. #2
    CMDR DeadPorkins is offline
    This user was unable to follow the forum rules and ended up banned or suspended! :(
    CMDR DeadPorkins's Avatar
    Just when I thought I was doing pretty good today trading.

    Well, I hope it works for the benefit of the community at large. As long as the market doesn't suddenly dry up in my town, it's fine with me.

  3. #3
    Nice work, thanks for all you do for the community! Can't wait to download and check it out.

  4. #4
    Originally Posted by CMDR DeadPorkins View Post (Source)
    Just when I thought I was doing pretty good today trading.

    Well, I hope it works for the benefit of the community at large. As long as the market doesn't suddenly dry up in my town, it's fine with me.
    It won't. It was proved multiple times in Beta/Alpha that it had no impact (as the market fluctuated even when the BPC wasn't even working!). Anyways, there seems to be significant stock of the more interesting items, and it's crowdsourced, so it's only as good as the last manual input, which dilutes it's usefulness further.

    Forgot to mention in my posts above, but for advocacy or otherwise of such tools, please use a different topic and leave this one to people who are using it for bug reports, queries etc. Also, I'm not the only one with such tools, so feel free to hassle the other authors (Thrudd etc) to - theirs have been running for the past few months while the BPC has been hibernating, and the market hasn't imploded on itself.
    C:\> Cannot find Reality.sys. Universe Halted.

    Slopey's Elite: Dangerous Best Profit Calculators!:
    Now retired - other market tools are available.
    Alleged destroyer of the entire Universe economy.

  5. #5
    CMDR DeadPorkins is offline
    This user was unable to follow the forum rules and ended up banned or suspended! :(
    CMDR DeadPorkins's Avatar
    Thanks, Mr. Slopey.

  6. #6
    Excellent stuff, look forward to the web based version for easier access on my iPad.

  7. #7
    I made some good money off of your first version, thanks for the hard work
    Elite: Dangerous - Metacritic 80/100 - 2014 High Score Tier

  8. #8
    Uninstalled 1.8.7 (I think), installed 3, ran it and get this. Can't find any path option in Options either?

    Code:
    See the end of this message for details on invoking 
    just-in-time (JIT) debugging instead of this dialog box.
    
    ************** Exception Text **************
    System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Users\fred\AppData\Local\Frontier_Developments\Products'.
       at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
       at System.IO.FileSystemEnumerableIterator`1.CommonInit()
       at System.IO.FileSystemEnumerableIterator`1..ctor(String path, String originalUserPath, String searchPattern, SearchOption searchOption, SearchResultHandler`1 resultHandler, Boolean checkHost)
       at System.IO.Directory.GetDirectories(String path, String searchPattern)
       at A.ce60847a8ca1358480ac48a994b33eaa6.cc3f3fdc577cd0d3071163f2e06ef4523()
       at A.ce60847a8ca1358480ac48a994b33eaa6.c12723b1ad8f9de2ad560c75f58721efc(Object cf31c6b95f279e766a628123301769734, EventArgs c685f2fe3e56b15489d3a72ae97ae0d12)
       at System.EventHandler.Invoke(Object sender, EventArgs e)
       at System.Windows.Forms.Form.OnLoad(EventArgs e)
       at DevExpress.XtraEditors.XtraForm.OnLoad(EventArgs e)
       at System.Windows.Forms.Form.OnCreateControl()
       at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
       at System.Windows.Forms.Control.CreateControl()
       at System.Windows.Forms.Control.WmShowWindow(Message& m)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
       at System.Windows.Forms.ContainerControl.WndProc(Message& m)
       at System.Windows.Forms.Form.WmShowWindow(Message& m)
       at System.Windows.Forms.Form.WndProc(Message& m)
       at DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
       at DevExpress.XtraBars.Ribbon.RibbonForm.WndProc(Message& msg)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    
    
    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
    ----------------------------------------
    ED_BPC
        Assembly Version: 3.0.0.0
        Win32 Version: 3.0.0.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/ED_BPC.exe
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    System
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34238 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    DevExpress.BonusSkins.v13.2
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.BonusSkins.v13.2.DLL
    ----------------------------------------
    DevExpress.Utils.v13.2
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.Utils.v13.2.DLL
    ----------------------------------------
    DevExpress.XtraBars.v13.2
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraBars.v13.2.DLL
    ----------------------------------------
    DevExpress.XtraEditors.v13.2
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraEditors.v13.2.DLL
    ----------------------------------------
    DevExpress.Data.v13.2
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.Data.v13.2.DLL
    ----------------------------------------
    System.Speech
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Speech/v4.0_4.0.0.0__31bf3856ad364e35/System.Speech.dll
    ----------------------------------------
    System.Data
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    System.Core
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
    ----------------------------------------
    System.Xml
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.Algorithms
        Assembly Version: 1.0.0.0
        Win32 Version: 1.0.0.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/System.Algorithms.DLL
    ----------------------------------------
    Microsoft.VisualBasic
        Assembly Version: 10.0.0.0
        Win32 Version: 11.0.50938.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
    ----------------------------------------
    DevExpress.XtraCharts.v13.2
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraCharts.v13.2.DLL
    ----------------------------------------
    DevExpress.Charts.v13.2.Core
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.Charts.v13.2.Core.DLL
    ----------------------------------------
    DevExpress.XtraGrid.v13.2
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraGrid.v13.2.DLL
    ----------------------------------------
    DevExpress.XtraCharts.v13.2.UI
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraCharts.v13.2.UI.DLL
    ----------------------------------------
    DevExpress.Printing.v13.2.Core
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.Printing.v13.2.Core.DLL
    ----------------------------------------
    DevExpress.XtraCharts.v13.2.Wizard
        Assembly Version: 13.2.9.0
        Win32 Version: 13.2.9.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/DevExpress.XtraCharts.v13.2.Wizard.DLL
    ----------------------------------------
    System.Data.Linq
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll
    ----------------------------------------
    System.Configuration
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    Devart.Data.SQLite
        Assembly Version: 5.2.264.0
        Win32 Version: 5.2.264.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/Devart.Data.SQLite.DLL
    ----------------------------------------
    System.Transactions
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
    ----------------------------------------
    Devart.Data
        Assembly Version: 5.0.1056.0
        Win32 Version: 5.0.1056.0
        CodeBase: file:///C:/Program%20Files%20(x86)/Slopeys%20ED%20BPC/Devart.Data.DLL
    ----------------------------------------
    System.Numerics
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
    ----------------------------------------
    WindowsBase
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
    ----------------------------------------
    System.EnterpriseServices
        Assembly Version: 4.0.0.0
        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL
        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
    ----------------------------------------
    
    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.
    
    For example:
    
    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>
    
    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.
    me thinks, therefore I is.

  9. #9
    Thank You Commander, first version of Tool was very helpful in early days.

    Downloading as we speak.
    COMMANDER INTEL

  10. #10
    @Severian, Hmm, if it can't find the path, it should ask you for it. Let me check and see.

    - - - - - Additional Content Posted / Auto Merge - - - - -

    Originally Posted by Severian View Post (Source)
    Uninstalled 1.8.7 (I think), installed 3, ran it and get this. Can't find any path option in Options either?
    Can you try going into options, then select "Reset Settings to Default", then quit and relaunch the BPC? See if that helps.
    C:\> Cannot find Reality.sys. Universe Halted.

    Slopey's Elite: Dangerous Best Profit Calculators!:
    Now retired - other market tools are available.
    Alleged destroyer of the entire Universe economy.

  11. #11
    Hey, Slopey, are you using the crowdsourced system coords?

  12. #12
    Originally Posted by DaveB View Post (Source)
    Hey, Slopey, are you using the crowdsourced system coords?
    No - because they're all wrong since B3 (the universe was regenerated).
    C:\> Cannot find Reality.sys. Universe Halted.

    Slopey's Elite: Dangerous Best Profit Calculators!:
    Now retired - other market tools are available.
    Alleged destroyer of the entire Universe economy.

  13. #13
    Originally Posted by Slopey View Post (Source)
    @Severian, Hmm, if it can't find the path, it should ask you for it. Let me check and see.

    - - - - - Additional Content Posted / Auto Merge - - - - -



    Can you try going into options, then select "Reset Settings to Default", then quit and relaunch the BPC? See if that helps.
    Tried that while phaffing about already thanks. No luck.
    me thinks, therefore I is.

  14. #14
    Hmmm, ok. I've tidied up the code about around that function, and I'll add a Path box into options so you can set it manually if all else fails. New version with that in tomorrow I guess
    C:\> Cannot find Reality.sys. Universe Halted.

    Slopey's Elite: Dangerous Best Profit Calculators!:
    Now retired - other market tools are available.
    Alleged destroyer of the entire Universe economy.

  15. #15
    Awesome. I tried running my own spreadsheet with B2.06, sucked all the life out of the game. This at least will make it a bit more interesting again, and hopefully I can make enough money to get a decent ship soon.
    CMDR Slugsie flying the good ship GetTheHellOuttaMyWay

    I'm a loner. I don't compete, and I don't cooperate. I just play my own way. I neither seek out nor avoid others, if you find me I'll say 'Hi', maybe exchange a few words; but I'll soon move on. I don't get involved in any of the politics, I pledge my allegiance to no-one other than myself. My cockpit is my home, not a star, not a planet, and not a station. Off to the Black once again.

Page 1 of 108 1234511 ... LastLast