Forum

An easy way to track IP address when when using multiple stealth's.
 

This is a very easy way to make sure that you never use the same IP address twice.

At the top of excel select the column A.


Select the conditional formatting button at the top of the page under the home tab

Select highlight cell rules, then duplicate values.

Make sure the left drop down cell says duplicate, and then select what ever works best for you on the right, I choose light filled red with dark red text personally. Then click ok.

After that is done, click column A again, conditional formatting, select highlight cell rules, then duplicate values again. This time change the left hand drop down value to unique, then the right hand drop down menu to again what ever suits you. I choose green filled with dark green text.

If the cell lights up red, you need to get a new IP, if it lights up green your good to go

Hope this helps

:typing:


DOWNLOAD THIS AS A ZIP FILE HERE

Great tip, James.

Your stealth knowledge is seriously impressive for someone that has only been here for 20 days.

I could pretend I am a fast learner.... But actually I have been doing stealth for a fair few years, never thought to look for a forum dedicated to it until about a month ago. I have learned a number of new things since I have been on here, it is an incredibly knowledgeable place.

Perfect tip for Excel newbies such as myself. Pair this with some of the pre-made spreadsheets floating around and you'll have yourself an easier time.

We already have a very suitable sample excel sheet

http://www.aspkin.com/forums/multipl...cel-sheet.html


:canada:

Thanks for sharing, great tip.

Also, if you want to check your IP quickly here is a good way:

1. Enter your IP address associated with your Account

2. Click on "Find & Select" at the top right hand corner of Excel

3. Either Copy/Paste, or enter manually your IP in the search field

4. Click on "Find All"

This will find all the cells with the same IP, here's a little example.



http://i41.tinypic.com/33l0a48.jpg

You certainly appear to have learned a lot on your own, just you versus ebay.

Anyway, it's far better to have a place where ideas and support can be shared.

All the best. :)

great tip thanks for the share

There is an iPhone APP called IP VIEW I know I mentioned this a lot but it really works great u can instantly see if your IP was used as long as you use it every time it keeps a log of all IPs and will tell u instantly if it is new or used, I use this along with excel to be xtra careful

More ways the merrier, cannot be too careful.

I thought using apps on iPhone or iPad was a big no no for stealth ?

It is a big no no to use the EBAY APP.

Just those related to ebay/paypal.

Consider using ATOMIC WEB.

MM78 has made some excellent posts on the successful use of iphones, ipads etc.

http://www.aspkin.com/forums/cookies...p-address.html

http://www.aspkin.com/forums/ebay-tr...questions.html

http://www.aspkin.com/forums/cookies...p-android.html

A few contributions from MM78 to set you on your way.
Good Luck.
:thumb:

I have used this method for years now.

Thanks for sharing MM.

MM is full of little bits of info like this.

Hidden COMPUUUTTER genius MM is.

I recently purchased a Samsung Galaxy and from all the stories I wont even touch the app.

Is there a way to be able to do this but only highlight duplicates in different columns but not ones in the same?

Sorry I don't entirely understand what you mean by this.

I have columns set up from G through P with each account as the header for each column. I log the IP down the column for whichever account I am using.... So if an IP matches up with another one in its own column it doesn't matter, so I was wondering how I could just have the IP highlight if it mismatches with one from another column.

I'm having the same problem utilizing this method of checking ip addresses. For those of us (assuming most of us) that are doing stealth with multiple accounts, it doesn't really matter if the ip address is a duplicate of an address that was used before for that same account.

Example: column A is date logged in, and column B is ip address used. Both columns are under Stealth Account X. Using this method, red would flash for the entire column B if the ip address was used before in that column, and green would flash for the column if the ip address was not ever used before for this particular Account X. Even if it flashes red indicating a duplicate ip, it doesn't matter because that ip is linked already to the particular account anyways. We would be able to use it without fear of any linkage to begin with.

We are more interested in cross-referencing these ip addresses with OTHER stealth accounts, in order to make sure that a different ebay/paypal has never before used the ip address we want to use. So using the excel spreadsheet, if Stealth Account X has columns A (for date logged in) and B (for ip address used), then Stealth Account Y has columns C (for date logged in) and D (for ip address used), and Stealth Account Z has columns E and F. We want to check if the ip address we put into column B has been used in columns D and F for the other accounts.

Much more useful would be something that flashes in the other columns for ip address. I hope this makes sense!

I have my spreadsheet set up the same as MM78's. You can see the screenshot a couple posts above.

It is possible, but it is a lot more complex and error prone.

Much easier to just use 'Control H' to locate a previous IP and see which account that IP was used with in the past.

Yeah that's what I thought. I know it's possible using excel but it gets real complicated at some point. Thanks for confirming!

as stupid as it sounds i usually just write the ip down in a note book and if i cant see the same ip for the last 50 odd log ins i dont worry.

i should track them constantly i suppose.

considering using this type of spreadsheet but where would you locate the file?

for example on my mac i have 10+ log in accounts that im in and out of all the time.

where would i save the excel file to bring it open every time?

cheers

USB stick, or a master account that you can access from all the other user accounts, cloud storage, ect ect

Need to make sure that IP has never been used before, be it 50 or 500 previous IP's.

Re: An easy way to track IP address when when using multiple stealth's.
 

Just created it and it works :)

Can't thank you enough JN101! :)

Re: An easy way to track IP address when when using multiple stealth's.
 

for people like myself who don't have a clue about excel and spreadsheets would it be easier to just buy the upgreded version of ip burger? does this work as good? thanks

Re: An easy way to track IP address when when using multiple stealth's.
 

Not used it myself, but it was created by Aspkin, so I have no doubt that it will work an absolute treat.

Re: An easy way to track IP address when when using multiple stealth's.
 

thanks for the fast reply mate think i will give it a go

Re: An easy way to track IP address when when using multiple stealth's.
 

Thanks! Good stuff.

Re: An easy way to track IP address when when using multiple stealth's.
 

Is there any way I can *pay* to get the IPTracker from IP Burger vs. having to do a trial that I cannot cancel? I don't have a new version of Excel (I have Excel 2003) and therefore cannot follow JamesNorth's instructions. Thanks.

Re: An easy way to track IP address when when using multiple stealth's.
 

@90210
Just added this to your thread.

Can you not use a free download of a newer version of excel? I did that without problems.

:mod:

Re: An easy way to track IP address when when using multiple stealth's.
 

Have a look at LibreOffice Calc

Re: An easy way to track IP address when when using multiple stealth's.
 

Yeah, it is good to use with LINUX


Here's the URL

Calc Features » LibreOffice

:juggle:

Re: An easy way to track IP address when when using multiple stealth's.
 

Shortcut to find & select press ctrl+F :p

Re: An easy way to track IP address when when using multiple stealth's.
 

that is helpful tips thanks

Re: An easy way to track IP address when when using multiple stealth's.
 

is it possible to upload a sample for us?

appreciated!!

Re: An easy way to track IP address when when using multiple stealth's.
 

Uploaded as a zip file.

Re: An easy way to track IP address when when using multiple stealth's.
 

Awesome James!

How did the antiques you found do?

Re: An easy way to track IP address when when using multiple stealth's.
 

In a museum storage at the moment waiting to be inspected by one of their far eastern experts. Looking forward to seeing what they have to say when they get around to hopefully in the next month or so

Re: An easy way to track IP address when when using multiple stealth's.
 

My spreadsheet for IP tracking looks like this! Conditional formatting used, when IP is entered, you can tell by color code.

http://www.aspkin.com/forums/members...p-tracking.jpg