AGG Software Forums
May 16, 2021, 03:20:58 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
   Home   Help Search Login Register  

Pages: [1]
  Print  
Author Topic: Log data from different IP addresses to IP Data Logger and export to Excel  (Read 1602 times)
stevenvdv
Jr. Member
**

Karma: +0/-0
Posts: 6


View Profile
« on: September 28, 2020, 08:55:10 PM »

Hi,

I want to log live streaming data from different trading accounts and combine the data in excel for live analysis of all accounts combined.

Every second 10 servers send the following account data that needs to be logged for each account: Acct number, Equity, and Open Profit. Each data item should go into a separate column in an Excel sheet that is updated on the fly using OLE.

I'm trying to combine all data from all servers into 1 data packet so I can export the data to Excel using variables that I parse out.
 
When I only log 1 account it works, but when I send info from multiple sources to the IP Data Logger it only parses data correctly from 1 source.

Can I log all data from the 10 source IPs to 1 IP Data Logger or do I need to create a separate IP data logger for each source IP?

Looking forward to your feedback, and thanks in advance!
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #1 on: September 29, 2020, 07:24:07 AM »

Hello,

Yes, the logger can receive data from multiple data sources. Did you create a separate configuration for each data source in our logger?
Logged
stevenvdv
Jr. Member
**

Karma: +0/-0
Posts: 6


View Profile
« Reply #2 on: September 29, 2020, 10:06:23 AM »

Hi Arthur,

Thank you for the quick reply.
I did not try using multiple configurations yet. I saw a post from someone else where you explained redirecting output from one IP logger to other ones to consolidate data into one package.

Is it necessary to use multiple IP logging configurations?

In any case, I want to make sure all incoming data from the 10 sources is consolidated into 1 data packet each second. From that packet I want to parse all 30 variables (3 from each source), so they can be exported to Excel.

Thank you.
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #3 on: September 29, 2020, 10:27:10 AM »

I'm not sure that it is a good idea to consolidate data from 10 data sources. If one data source pauses, all other data streams will be paused too.

I think you need one configuration, but write data to a new row in Excel for each data packet.
Logged
stevenvdv
Jr. Member
**

Karma: +0/-0
Posts: 6


View Profile
« Reply #4 on: September 29, 2020, 11:06:47 AM »

Hi Arthur,


I'm going to use the Excel to monitor the sum of equity and open profit in all ten 10 trading accounts combined from second to second.
I have attached a screenshot of what the exported data should look like in Excel.

The easiest way would be if each different variable is in a separate column and written to a new row every second.
The approach you suggested with writing each packet to a new row would make the Excel harder to use for analysis.
If I understand correctly, using your approach, the data from each source would be treated as a separate data packet and needs to be parsed separately and I don't see how the parser from one IP Data logging configuration can do that.

Can you give some pointers on how to configure this so I get the final results in Excel?

Thank you.



* Excel layout.PNG (12.64 KB, 1559x137 - viewed 2 times.)
« Last Edit: September 29, 2020, 11:09:39 AM by stevenvdv » Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #5 on: September 29, 2020, 11:26:50 AM »

In this case, you should create 10 configurations.

1. In the first configuration, you should enable and configure the Aggregator plugin
1.1 Enable and configure the Excel data export plugin.

2. In other configurations, you should redirect data to the first configuration.
Logged
stevenvdv
Jr. Member
**

Karma: +0/-0
Posts: 6


View Profile
« Reply #6 on: September 29, 2020, 11:31:13 AM »

Great, I'll try to set that up.

Thank you very much Arthur!
Logged
stevenvdv
Jr. Member
**

Karma: +0/-0
Posts: 6


View Profile
« Reply #7 on: September 29, 2020, 08:40:29 PM »

Hi Arthur,

I just cannot make it work. I have spent several days struggling with the software configuration.
Is there any way someone can help me set this up?  I'm prepared to pay for the help.
I'm sure that for a specialist this would take maybe 15 minutes to set up. I have spent 30+ hours on this already and cannot justify putting more effort into this to my boss.  

As an aside, how performant is the logger?  Would it be possible to log info from 100 different IP sources using one instance of the software running 100 IP data loggers, aggregating it correctly and exporting it to 10 different Excel workbooks?

Thank you.
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #8 on: September 30, 2020, 07:22:48 AM »

Can I connect to your computer remotely?

If yes, please open a ticket here:

https://support.aggsoft.com/
Logged
stevenvdv
Jr. Member
**

Karma: +0/-0
Posts: 6


View Profile
« Reply #9 on: September 30, 2020, 08:44:49 AM »

Great, I will do that!

Thank you Arthur.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines