问Django导入-导出用户Foreignkey & M2M导入逻辑检查

EN

class Trade(models.Model):
    user = models.ForeignKey(User, on_delete=models.CASCADE, blank=True)
    status = models.CharField(max_length=2, choices=STATUS_CHOICES, default='cl')
    type = models.CharField(max_length=5, choices=TYPE_CHOICES, default=LONG)
    broker = models.ForeignKey(Broker, on_delete=models.CASCADE, blank=True, null=True)
    asset = models.ForeignKey(Asset, default=DEFAULT_ASSET_ID, on_delete=models.CASCADE, null=True)
    symbol = models.ForeignKey(Symbol, on_delete=models.CASCADE, blank=True, null=True)
    patterns = models.ManyToManyField(Pattern, blank=True)
    notes = RichTextUploadingField(blank=True, null=True)
    created = models.DateTimeField(editable=False)
    modified = models.DateTimeField(editable=False)
    associated_portfolios = models.ManyToManyField(Portfolio, blank=True)
    image = models.FileField(default='no-image-available-icon.jpg', upload_to=user_directory_path, null=True, blank=True)

  
class Entry(models.Model):
    trade = models.ForeignKey(Trade, on_delete=models.CASCADE)
    date = models.DateTimeField(null=True, blank=True, default=datetime.datetime.now)
    amount = models.FloatField(null=True)
    price = models.FloatField(null=True)
    fee = models.FloatField(null=True, blank=True)
    entry_type = models.CharField(max_length=5, choices=ENTRY_TYPE_CHOICES, default=ENTRY)
    reg_fee = models.FloatField(null=True, blank=True)
    transaction_id = models.CharField(max_length=100, null=True, blank=True)

Date/Time               Description                 Amount  Commission  RegFee  NetCashBalance  
07/17/2020 7:42:39      Bought 40 APDN @ 14.56      -582.4      0       0       25,755.84
07/17/2020 7:47:16      Bought 40 APDN @ 14.78      -591.2      0       0       25,164.64
07/17/2020 7:53:36      Bought 20 APDN @ 14.27      -285.4      0       0       24,879.24
07/17/2020 8:04:01      Bought 100 VRNA @ 9.58      -958        0       0       23,921.24
07/17/2020 8:05:01      Bought 20 VRNA @ 9.47       -189.4      0       0       23,731.84
07/17/2020 8:05:27      Sold 21 APDN @ 14.885       312.58      0       0.01    24,044.42
07/17/2020 8:05:27      Sold 79 APDN @ 14.87        1,174.69    0       0.04    25,219.11
07/17/2020 8:06:43      Sold 120 VRNA @ 10.08       1,209.56    0       0.04    26,428.67

1. Create an Entry class object (user may need to manually make csv file for cleaner data import)
2. find Trade object where Status == Open and symbol == symbol
3. if step 2 == None then create a new Trade class & assign status to open
4. Def & set Set Symbol_Share_Count == 0
5. Increment or Decrease Symbol_Share_Count by shares
6. Once Symbol_Share_Count == 0 close the trade

3. if step 2 retuns a Trade object then..
4. Def & set Set Symbol_Share_Count == "# of total open shares"
5. Increment or Decrease Symbol_Share_Count by shares of newly imported transaction
6. Once Symbol_Share_Count == 0 close the trade

7. At this point the new or found Trade object is done and a new Trade object can be created or found based on the next transaction