|
|
|
Roz
|
 |
« Reply #21 on: November 12, 2004, 05:14:26 AM » |
|
I put much stuff in. Many work for you now.  There have been at least 85 entries into the price guide today and they are all now verified... so guys... BRING IT ON!Fantastic price guide. That must have taken a hell of a lot of work to put together.
a good couple of weeks and 2 such late nights that Mark overslept and was late for work - *waves hand in dismissive gesture* pfft it was nothing  |
|
|
|
« Last Edit: November 12, 2004, 06:18:09 AM by Roz »
|
Logged
|
|
|
|
morenomark
Calf
 Offline
Posts: 49
I'm a llama!
|
|
« Reply #22 on: November 12, 2004, 06:15:51 AM » |
|
Just incredible! Cheers to you. Major cheers!!!
|
|
|
|
|
Logged
|
|
|
|
|
ztaylork
Guest
|
|
« Reply #23 on: November 12, 2004, 06:48:04 AM » |
|
I think the price guide is brilliant, and after a few weeks of auctions from the new set, it will be amazingly useful!!!! Two thumbs up!!!
|
|
|
|
|
Logged
|
|
|
|
|
MakTheYak
|
|
« Reply #24 on: November 12, 2004, 05:09:51 PM » |
|
Hooray! Everyone loves it! Well I have a few things I'm going to be improving on it... 1. I will make it so that you can check if an auction has been entered BEFORE you enter all the details for it. I don't know how many of you have been entering auctions and being told that it was already in the database, but if you get that a lot this should make things a lot easier for you  2. After it has been running a few weeks / months (depending on what I decide on, or what you guys think would be more useful) I will make it display graphs showing how the average price has changed over the weeks / months. Tell me which would be better - weeks or months? Cheers! |
|
|
|
|
Logged
|
|
|
|
|
Tower
|
|
« Reply #25 on: November 12, 2004, 05:49:12 PM » |
|
1. Oh yes, that´s much better. That was the only thing i didn´t like. It´s a very good improvement, a very good idea to change it this way. 2. Very nice. I think a month would be better, a week is not enough in my opinion. |
|
|
|
|
Logged
|
|
|
|
|
sonarghost
|
|
« Reply #26 on: November 12, 2004, 07:38:50 PM » |
|
I too second the idea for a month, a week is too short!
GREAT JOB MARK & ROZ!!
|
|
|
|
|
Logged
|
|
|
|
|
Tower
|
|
« Reply #27 on: November 13, 2004, 04:13:36 AM » |
|
1. I will make it so that you can check if an auction has been entered BEFORE you enter all the details for it. Hi Mark. What do you think? When will this be done? Should i wait a day with new input or will it take much longer time so waiting for a day would make no sense? |
|
|
|
|
Logged
|
|
|
|
|
Tower
|
|
« Reply #28 on: November 13, 2004, 04:57:03 AM » |
|
I didn´t wait and have put some stuff in. |
|
|
|
|
Logged
|
|
|
|
|
MakTheYak
|
|
« Reply #29 on: November 14, 2004, 03:26:54 AM » |
|
I've done the first part I've also streamlined the card list so it isn't so hard to read. The cards are listed in the same order as on the "card list" page now and under subheadings. Let me know if this is better or worse! It should all be error free but as usual let me know if you find anything dodgy about it. Part 2 comes when we have a few months worth of data! |
|
|
|
|
Logged
|
|
|
|
|
MakTheYak
|
|
« Reply #30 on: November 14, 2004, 04:22:41 AM » |
|
Added a convert function to the cards when you view them! If you want to see the prices in Pounds, Euros or AU$ you can select from the list and it'll bring up a Yahoo! Finance conversion for that amount. It's the best I can get for free |
|
|
|
« Last Edit: November 14, 2004, 05:24:15 AM by MakTheYak »
|
Logged
|
|
|
|
|
savage727
|
|
« Reply #31 on: November 14, 2004, 04:33:16 AM » |
|
Outstanding piece of programming Mark! Behind every great man there is a great woman - in this case Roz!! |
|
|
|
|
Logged
|
|
|
|
|
MakTheYak
|
|
« Reply #32 on: November 14, 2004, 05:24:58 AM » |
|
Yes it's true Roz is my 'Ghost (Website) Writer'!
|
|
|
|
|
Logged
|
|
|
|
|
samwise16
|
|
« Reply #33 on: November 14, 2004, 05:28:23 AM » |
|
How did you do it By the way, just using Microsoft access?
|
|
|
|
|
Logged
|
|
|
|
|
Roz
|
|
« Reply #34 on: November 14, 2004, 05:32:55 AM » |
|
opps!
Un-say it Ben ... take it BACK!
|
|
|
|
|
Logged
|
|
|
|
|
MakTheYak
|
|
« Reply #35 on: November 14, 2004, 05:36:08 AM » |
|
No no no it's much more complicated than that. The first steps of preparation involve a mixture of milk, sugar and an extract of the cocoa plant and a cup of hot tea. These are for my benefit only, and nothing to do with the creation of the website.
Then I took a computer and sat down for days on end writing in complicated languages such as XHTML, PHP, CSS, mySQL and JavaScript.
That's pretty much it, nothing more complicated than that! None of your Microsoft do-dahs though...
|
|
|
|
|
Logged
|
|
|
|
icat2000
Calf
Offline
Posts: 36
I'm a llama!
|
|
« Reply #36 on: November 14, 2004, 04:21:47 PM » |
|
Okay I think your done a fantastic job.
I only have one little nit picking thing. When you go to print the pages out like I did the other night it cuts the images off on the right had side. Would you be able to code it so it printed to fit on an a4 page.
That would be my only thing I would recommend as a possible enhancement.
Other than that I appreciate how much time and effort you have put into doing this project and us collectors will certainly use it.
|
|
|
|
|
Logged
|
|
|
|
|
Roz
|
|
« Reply #37 on: November 14, 2004, 05:22:15 PM » |
|
Hmm good plan, we hadn't thought about printing!
Which pages particularly do you want to print because I was wondering about putting the recent average prices on the index page... that might enhance the printing off too - what do you think?
|
|
|
|
|
Logged
|
|
|
|
abraxas
Calf
Offline
Posts: 21
I am not a Yak.... I'm almost positive..
|
|
« Reply #38 on: November 17, 2004, 02:06:52 PM » |
|
Well guys I think your HP list is brilliant. Beautifully done. Did you use Access? I have a growing collection of pics on a database using excel. But you have done a wonderful job!! 3 rousing HOOTS to ya!!!
|
|
|
|
|
Logged
|
|
|
|
|
garage
|
|
« Reply #39 on: November 17, 2004, 02:32:50 PM » |
|
When the first set came out I tracked the "Big 4" fairly closely - unfortunately I didn't keep auction ids or dates so I haven't included them in the database but the figures were as follows.
Granger Auto - Up to the 25th of May - Avg Price 360 - 11 cards
Sirius Auto - Up to the 6th of June - Avg Price 151 - 12 cards
Dubledore Auto - Up to the 6th of June - Avg Price 108 -11 cards
Lupin Auto - Up to 6th of June - Avg Price 85 - 11 cards
It looks like the Lupin card is the only one to greatly increase its price up to around the 130 mark. Given that there were only between 100 - 150 of these made I thought a greater variation may have been expected. If the trend continues then the Harry, Ron and Hermonie cards will probably even out pretty quickly.
The Price Guide is Fantastic!
|
|
|
|
|
Logged
|
|
|
|
|
