For those who use spreadsheets..

[bballcardkid]

If anyone wants a copy of the spreadsheet, pm me your email address and I'll send them out later on tonight. You'll have to delete all of my stuff from it, but the cells and columns will still work.

 

[Jurgy25]

Looking at all this stuff, I have decided I should be doing this. Is there a way, I can look at past ebay purchases (maybe past year), to see everything I have bought?

Thanks, Eric

 

[bballcardkid]

Looking at all this stuff, I have decided I should be doing this. Is there a way, I can look at past ebay purchases (maybe past year), to see everything I have bought?

Thanks, Eric

paypal history

 

[Jurgy25]

thaaank you.

 

[pigskincardboard]

Eric -- I'll fire together sumfin, just gimme an hour.

 

[pigskincardboard]

..now I'm confused,

Do you need one, or not?

 

[rico08]

All I know...it looks like you are going to make some nice dough off Stanton my friend!

Messier?

 

[Jurgy25]

..now I'm confused,

Do you need one, or not?

You talking to me or EricCT?

I don't need one made, but thanks though.

-Eric

 

[EricInCT]

there are two erics lol.

[email protected]

I will check it out, thanks.

Eric

 

[Jurgy25]

Anybody care to help a Excel newb out?

Just trying to figure out how to get the profit, but minusing the sold amount from the purchased amount.

Thanks, Eric

 

[EricInCT]

Anybody care to help a Excel newb out?

Just trying to figure out how to get the profit, but minusing the sold amount from the purchased amount.

Thanks, Eric

Eric I have a very nice one here I can send you.

Email me your addy.

 

[Topnotchsy]

I just like to see how much I make before fees, and then see how much each of the filthy bandits like to take from me . So far ebay is robbing me 3 times more than paypal.

Not really. Since eBay owns Paypal they are pretty much just robbing you 4 times.

 

[Jurgy25]

Is there a way where it automatically takes what I sell and minus what I paid for every one.

I understand that I can do "=SUM(E5-D5) " for them, but is there one a certain formula that does that to every row?

Thanks, Eric

 

[weavermania]

Question for you guys,
If you acquire a card by trade, what do you put as the buy in price?

 

[Jurgy25]

Question for you guys,
If you acquire a card by trade, what do you put as the buy in price?

I don't know about the other guys, but I have been doing the SV at the time of trade. I guess you could also do the value of the card you gave up?

 

[EricInCT]

Question for you guys,
If you acquire a card by trade, what do you put as the buy in price?

current ebay value at the time acquired.

 

[pigskincardboard]

Is there a way where it automatically takes what I sell and minus what I paid for every one.

I understand that I can do "=SUM(E5-D5) " for them, but is there one a certain formula that does that to every row?

Thanks, Eric

Yup,

Edit -> Fill Down or Fill Right, or Left.

Basically, Fill.

That's how you do it in open office, in excel, just look around for Fill.

 

[Jurgy25]

Is there a way where it automatically takes what I sell and minus what I paid for every one.

I understand that I can do "=SUM(E5-D5) " for them, but is there one a certain formula that does that to every row?

Thanks, Eric

Yup,

Edit -> Fill Down or Fill Right, or Left.

Basically, Fill.

That's how you do it in open office, in excel, just look around for Fill.

I thought there was a certain formula you could do so it would be automatic. Like "=SUM(E5-D5)", but to every column for F

 

[baseballguy350]

Question for you guys,
If you acquire a card by trade, what do you put as the buy in price?

Price you paid for the card you traded. If that isn't available, take the current sell value of the card you are acquiring.

 

[pigskincardboard]

Is there a way where it automatically takes what I sell and minus what I paid for every one.

I understand that I can do "=SUM(E5-D5) " for them, but is there one a certain formula that does that to every row?

Thanks, Eric

Yup,

Edit -> Fill Down or Fill Right, or Left.

Basically, Fill.

That's how you do it in open office, in excel, just look around for Fill.

I thought there was a certain formula you could do so it would be automatic. Like "=SUM(E5-D5)", but to every column for F

Okay, let's say you're adding E5-D5 and you want it to go all the way down to E95-D95.

start your highlight at Row 5 (wherever the cell is) and highlight down to 95.

Click, edit -> fill down

and you'll get

e5-d5
e6-d6
e7-d7
e8-d8
e9-d9
...
e95-d95
etc, etc.

I think that's what you're trying to do.