How can I get this in readable format

The war between wetware and hardware.
ed
Posts: 42474
Joined: Tue Jun 08, 2004 11:52 pm
Title: That Firebrand

How can I get this in readable format

Post by ed »

https://www.rockislandauction.com/catal ... erPage=200

I am curious about firearm prices over time. Auction houses have prices realized as you can see from the link. In this cae the problem is that the price is an image. OK you might say, that is why god invented OCR. For reasons that I cannot fathom I cannot get the image to be read.

I can copy/paste the pages ... viz.
https://i.imgur.com/2L0aEd2.jpg

But I am left with the task of reading prices in. It is more than 1500 numbers and I am lazy.

n.b. I am taking an iconic weapon (a luger) grabbing the prices by auction, taking the median price realized then dicking around with a bunch of covariates to see what sort of relationship I can come up with.

It will also be interesting to see how $1000 invested in a variety of places would perform over 10 years or more.

Yes, I have time on my hands, why do you ask?

<if you were good guys, you'd just do it for me>
ed
Posts: 42474
Joined: Tue Jun 08, 2004 11:52 pm
Title: That Firebrand

Re: How can I get this in readable format

Post by ed »

Poulon auctions has reports that are readable.

This is a pain in the ass. I am rethinking.
asthmatic camel
Posts: 20455
Joined: Sat Jun 05, 2004 1:53 pm
Title: Forum commie nun.
Location: Stirring the porridge with my spurtle.

Re: How can I get this in readable format

Post by asthmatic camel »

You may find this article, (and others), from Investopedia helpful. I primarily use Trustnet and Morningstar to evaluate investments but Trustnet doesn't appear to have a USA equivalent.
Hotarubi
Posts: 6209
Joined: Fri Feb 14, 2020 2:12 am
Title: Enchantress
Location: This septic Isle.

Re: How can I get this in readable format

Post by Hotarubi »

Are you trying to "read" from a pdf?
ed
Posts: 42474
Joined: Tue Jun 08, 2004 11:52 pm
Title: That Firebrand

Re: How can I get this in readable format

Post by ed »

No. The link I provieded shows you the data in question. the Price Realized is an image.
Hotarubi
Posts: 6209
Joined: Fri Feb 14, 2020 2:12 am
Title: Enchantress
Location: This septic Isle.

Re: How can I get this in readable format

Post by Hotarubi »

Fuck's sake ed.

I am not interested in the data. I am interested in the format you cut it from and the format you pasted it to. Then I might have a solution for you.
Hotarubi
Posts: 6209
Joined: Fri Feb 14, 2020 2:12 am
Title: Enchantress
Location: This septic Isle.

Re: How can I get this in readable format

Post by Hotarubi »

Lets put it another way, are you reading the data from the webpage itself or from one of the downloadable formats from the link.

Because, an iota (17 seconds) of research will tell you that some/many/all OCR software packages cannot read some/many/all web based PNG files. Why? For example, the text on web based PNGs is possibly not in the right location or sometimes has images hidden behind the file that make it impossible for a particular OCR software to read.

A possible solution would be to download the .pdf from the link and OCR the fuck out of that. Failing that, convert the .pdf to a format that your OCR works on.

Or, download ten different OCR packages and see which one works.

Or, stop being a lazy fuck and type it in. Which you could have done in the time it took you to respond to my first post.

The choice....is yours.
Hotarubi
Posts: 6209
Joined: Fri Feb 14, 2020 2:12 am
Title: Enchantress
Location: This septic Isle.

Re: How can I get this in readable format

Post by Hotarubi »

You're welcome. Again.
Pyrrho
Posts: 34112
Joined: Sat Jun 05, 2004 2:17 am
Title: Man in Black
Location: Division 6

Re: How can I get this in readable format

Post by Pyrrho »

At work I use the paid version of Acrobat to OCR images. Sometimes I have to correct some things but it is easier than typing in rows and columns of numbers.
Hotarubi
Posts: 6209
Joined: Fri Feb 14, 2020 2:12 am
Title: Enchantress
Location: This septic Isle.

Re: How can I get this in readable format

Post by Hotarubi »

Wise words.
Pyrrho
Posts: 34112
Joined: Sat Jun 05, 2004 2:17 am
Title: Man in Black
Location: Division 6

Re: How can I get this in readable format

Post by Pyrrho »

ed, is that an image of a spreadsheet? If the text is editable text, there are spreadsheet formula methods that can be used to extract the prices from the text strings.

Or you hire a cafone to retype it for you.
ed
Posts: 42474
Joined: Tue Jun 08, 2004 11:52 pm
Title: That Firebrand

Re: How can I get this in readable format

Post by ed »

Need to get it typed in. I can copy/paste from the screen (at the link) but the price is an image.

Not worth dicking around with it.
Thank you though.