DataIs it possible to obtain data on stock trades in Excel? Ideally format would be date and time, stock name, volume and price. I can get this data for my own trades through History, but I can't get it for all trades in the stocks I'm following.
/forum/read.php?20,5133,5133#msg-5133
Thu, 22 Jan 2015 09:15:54 +1300Phorum 5.2.10/forum/read.php?20,5133,27040#msg-27040Re: http://myfilmbiznetwork.com/user_blog.php,
/forum/read.php?20,5133,27040#msg-27040
-------------------------------------------------------
> hilarious mismatching of target and market!
>
???]]>Alan3285Ask A QuestionFri, 31 Jan 2014 17:34:23 +1300/forum/read.php?20,5133,20700#msg-20700Re: http://myfilmbiznetwork.com/user_blog.php,
/forum/read.php?20,5133,20700#msg-20700
MilosevicAsk A QuestionWed, 14 Aug 2013 00:15:52 +1200/forum/read.php?20,5133,5595#msg-5595Re: Data
/forum/read.php?20,5133,5595#msg-5595
-------------------------------------------------------
> Well, I'm using Neo Office Calc instead of Excel
> and using the principle of of "Learn by Blundering
> Around" I have arrived here from the Forum link in
> the Calc spreadsheet. So yes pipe42, the links in
> the spreadsheet work, the stock title to the
> trading page and the other to the details page.
>
> Alan, as I'm using Calc I looked around on the net
> and found this I used the bit about "Saving with
> synchronization" . I don't know if it's helpful or
> if it can be applied to Excel, if it can be used
> that's great.
>
> Thanks to both of you.
Hi,
Sorry - I have no experience with NeoCalc, but I'm sure there is the ability to make it work.
I have it working in Excel 97, and Excel 2007, so my best guess would be to see if there is a reference that gives a mapping from Excel function to NeoCalc (there is likely to be something like that around).
If you can find it, then look for the equivalent of the HYPERLINK function that I mentioned. It takes a string, and turns it into a hyperlink, so if you had, say:
Obviously if you had a list of contract codes down column B you could make a list of hyperlinks by copying down (for example).
No idea if any of that will help, but good luck!
Alan.]]>Alan3285Ask A QuestionSun, 07 Mar 2010 21:57:33 +1300/forum/read.php?20,5133,5594#msg-5594Re: Data
/forum/read.php?20,5133,5594#msg-5594
Alan, as I'm using Calc I looked around on the net and found this I used the bit about "Saving with synchronization" . I don't know if it's helpful or if it can be applied to Excel, if it can be used that's great.
Thanks to both of you.]]>ORACLEAsk A QuestionSun, 07 Mar 2010 21:29:10 +1300/forum/read.php?20,5133,5593#msg-5593Re: Data
/forum/read.php?20,5133,5593#msg-5593
I get the same, but I would not expect it to work directly (based on my past experience with such things).
What I usually do (and am doing in this case), is have a sheet for the data connection (to Pipe's site), and don't have anything else on there at all - it is just the 'input' location.
Then I have another sheet that takes the data from the connection page, and re-works it into whatever is useful.
In the case of the links, I haven't tried to get them working, but it shouldn't take too much to use the HYPERLINK function in excel to re-create a working link from the data that comes in.
If you can't get it to work, post back here with what you have, what it is doing, and what you would like it to do, and I'll try to help if I can.
Alan.]]>Alan3285Ask A QuestionSun, 07 Mar 2010 15:20:22 +1300/forum/read.php?20,5133,5592#msg-5592Re: Data
/forum/read.php?20,5133,5592#msg-5592
-------------------------------------------------------
> Alan, I've changed the page back to how it was
> previously, and made the new functionality appear
> on a separate page.
Hi Pipe,
That has fixed it.
Just in case it helps or is of interest, I was using Excel to directly import from your page, rather than copy / paste.
Either way - THANKS!
Alan.]]>Alan3285Ask A QuestionSun, 07 Mar 2010 15:16:47 +1300/forum/read.php?20,5133,5591#msg-5591Re: Data
/forum/read.php?20,5133,5591#msg-5591
I have made the stock names link to the trading page for that stock. Do those links work for you?
I can make a more 'plain' version for the page if that would make things easier for you spreadsheet-import-inclined people.]]>pipe42Ask A QuestionSun, 07 Mar 2010 15:13:59 +1300/forum/read.php?20,5133,5588#msg-5588Re: Data
/forum/read.php?20,5133,5588#msg-5588
ORACLEAsk A QuestionSun, 07 Mar 2010 13:29:34 +1300/forum/read.php?20,5133,5587#msg-5587Re: Data
/forum/read.php?20,5133,5587#msg-5587
pipe42Ask A QuestionSun, 07 Mar 2010 12:31:31 +1300/forum/read.php?20,5133,5586#msg-5586Re: Data
/forum/read.php?20,5133,5586#msg-5586
I just added some new functionality (buttons for the order book etc) which involves having invisible table rows for each set of data that users might want (like prices, graph, etc). I didn't realise these rows would come through when you copy and paste; I'm looking at the problem now.]]>pipe42Ask A QuestionSun, 07 Mar 2010 12:17:36 +1300/forum/read.php?20,5133,5585#msg-5585Re: Data
/forum/read.php?20,5133,5585#msg-5585
I think something has gone wrong with your 'All Stocks 'API webpage this morning.
Up until yesterday, it was producing a nice clean data set.
Now it has loads of white space coming through when imported into Excel.
It isn't obvious from the webpage itself (at least not to me!), but definitely a problem when imported.
If I can help narrow it down, by all means post back with instructions or questions, and I'll do my best.
I know for sure I haven't changed anything in excel, so I am 99% certain is must be further 'up' the chain, but I won't rule any possibilities out....
Alan.]]>Alan3285Ask A QuestionSun, 07 Mar 2010 11:47:15 +1300/forum/read.php?20,5133,5561#msg-5561Re: Data
/forum/read.php?20,5133,5561#msg-5561
Do you have any insights on the difficulty with getting the data directly into Excel as was discussed above?
Pipe's site is great, but I am intrigued as to what is going wrong when we try to pull it in directly.
Thanks,
Alan.]]>Alan3285Ask A QuestionThu, 04 Mar 2010 21:57:54 +1300/forum/read.php?20,5133,5560#msg-5560Re: Data
/forum/read.php?20,5133,5560#msg-5560
The api data issue should be fixed now.
Please let us know if you still have issues there.
btw, we are going to be in a position to do more work on the API pretty soon. I'm going to revive the ipredict google group [groups.google.com] and will be keen to hear about the sorts of things you'd like to be able to get from the API.]]>iTeamAsk A QuestionThu, 04 Mar 2010 21:44:02 +1300/forum/read.php?20,5133,5534#msg-5534Re: Data
/forum/read.php?20,5133,5534#msg-5534
Sorry about the API issues, we're looking at it today.]]>adminAsk A QuestionThu, 04 Mar 2010 09:15:24 +1300/forum/read.php?20,5133,5485#msg-5485Re: Data
/forum/read.php?20,5133,5485#msg-5485
-------------------------------------------------------
> Ah, of course - thanks for pointing that out.
>
> The issue occurs because very small numbers like
> 0.0004 are reported like this:
>
> 1.0E-4
>
> I previously figured out how to handle this on the
> History page, I have coped the fix to the all
> stocks page now.
Yep - that fixed it (both on your web server and also when importing into Excel).
Thanks!
Alan.]]>Alan3285Ask A QuestionTue, 02 Mar 2010 10:46:14 +1300/forum/read.php?20,5133,5484#msg-5484Re: Data
/forum/read.php?20,5133,5484#msg-5484
The issue occurs because very small numbers like 0.0004 are reported like this:
1.0E-4
I previously figured out how to handle this on the History page, I have coped the fix to the all stocks page now.]]>pipe42Ask A QuestionTue, 02 Mar 2010 10:25:20 +1300/forum/read.php?20,5133,5483#msg-5483Re: Data
/forum/read.php?20,5133,5483#msg-5483
I have been checking your 'all contracts' report, and it appears that something is not quite working right yet.
I just pulled it, and it shows no sell price for 91.FEB10.VHIGH.
If I go to the IPredict web server and browse the 'all contracts' page it shows a lowest sell of 0.0005.
I wonder if it is a rounding issue below a certain threshold?
If I can narrow it down further, I'll post back, but I figured this might be enough for you to go on.
Thanks,
Alan.]]>Alan3285Ask A QuestionTue, 02 Mar 2010 09:47:39 +1300/forum/read.php?20,5133,5477#msg-5477Re: Data
/forum/read.php?20,5133,5477#msg-5477
-------------------------------------------------------
> Yeah, I think Excel probably can't read the
> security certificate or something like that.
>
> Anyway, thanks for the idea for the All Stock
> prices page - it looks great.
I'll see what I can find, but I'm pretty sure Excel can do TLS data imports - perhaps I just need to find more info.
Either way, thanks for the extra data feed.
If you do put the 'all prediction' full board info one together, please do post back here and I'll test it out.
Thanks,
Alan.]]>Alan3285Ask A QuestionMon, 01 Mar 2010 22:28:42 +1300/forum/read.php?20,5133,5476#msg-5476Re: Data
/forum/read.php?20,5133,5476#msg-5476
Anyway, thanks for the idea for the All Stock prices page - it looks great.]]>pipe42Ask A QuestionMon, 01 Mar 2010 22:24:49 +1300/forum/read.php?20,5133,5475#msg-5475Re: Data
/forum/read.php?20,5133,5475#msg-5475
-------------------------------------------------------
> I have made a simple API passthrough you can try.
> It takes exactly the same arguments as the
> ordinary API, check it out:
>
> iPredict API URL:
>
> [www.ipredict.co.nz]
> istory&stock=MORT.2010.700
>
> Passthrough URL:
>
> [api.howison.co.nz]
> i&action=history&stock=MORT.2010.700
>
> Let me know if this works.
The pass-through URL works perfectly.
Perhaps that means it is the TLS connection that is causing the issue?
Alan.]]>Alan3285Ask A QuestionMon, 01 Mar 2010 22:23:18 +1300/forum/read.php?20,5133,5473#msg-5473Re: Data
/forum/read.php?20,5133,5473#msg-5473
iPredict API URL:
Let me know if this works.]]>pipe42Ask A QuestionMon, 01 Mar 2010 22:17:36 +1300/forum/read.php?20,5133,5472#msg-5472Re: Data
/forum/read.php?20,5133,5472#msg-5472
-------------------------------------------------------
> Cheers Alan.
>
> Brand-spank'in new All Stock Prices page added
> just for you. (:P)
>
> [api.howison.co.nz]
>
> With Excel, it sounds like you are having the same
> error as Predictable was having above. I might be
> able to figure out a workaround for you, give me a
> moment.
>
> PS: I get the URLs to show properly by using the
> Insert Link button (the world with a paperclip
> icon) in the formatting bar:
>
>
> [*]Type/paste in the url
> [*]Select the url
> [*]Click the link button
> [*]Paste in your url
>
>
> ... now the URL links and shows correctly.
Pipe - I am honoured!
Thank you.
I just re-read above, and you are correct - I think it is the same issue as above.
Could it be due to the secure / insecure issue? There is no 'code' (VBA) involved, so there is nothing to 'trust / sign' as was suggested above.
Any ideas you have, I am happy to investigate. It is more just out of stubborn interest at this point, since you have solved it anyway, but I would like to know why Excel isn't getting it.
Thanks again,
Alan.]]>Alan3285Ask A QuestionMon, 01 Mar 2010 22:05:23 +1300/forum/read.php?20,5133,5470#msg-5470Re: Data
/forum/read.php?20,5133,5470#msg-5470
Brand-spank'in new All Stock Prices page added just for you. (:P)
With Excel, it sounds like you are having the same error as Predictable was having above. I might be able to figure out a workaround for you, give me a moment.
PS: I get the URLs to show properly by using the Insert Link button (the world with a paperclip icon) in the formatting bar:
Type/paste in the url
Select the url
Click the link button
Paste in your url
... now the URL links and shows correctly.]]>pipe42Ask A QuestionMon, 01 Mar 2010 21:59:41 +1300/forum/read.php?20,5133,5469#msg-5469Re: Data
/forum/read.php?20,5133,5469#msg-5469
>
> I think the API URLs have changed, although there
> seems to be some kind of redirect from the old
> URLs:
>
> [www.ipredict.co.nz];
> stock=FITCH.NZEX
>
> ... to the new URLs:
>
> [www.ipredict.co.nz]
> istory&stock=FITCH.NZEX
>
> Which functions have stopped working for you?
>
I can't get anything (I have tried) to work directly from the IPredict server. For example, I just tried this one:
Do you want to know the exact error message? It is the same in Excel 2000 and Excel 2007.
>
> I have noticed some of the minor API functions
> have stopped working or work differently, for
> example, action=tradeHist has stopped working
> (gah) and action=stock&results=extended is no
> longer giving out detailed information for closed
> stocks :(.
>
> Anyway Alan, do you want just the current price
> data for all contracts, or the order book data for
> all contracts? I can do all the current prices
> quite easily, but I think the second one will take
> too long to load.
The current price data (current highest buy and lowest sell) would be great (essentially what you get on the 'browse all' page).
The full order book for all contracts would be awesome - I agree it would be slow, but awesome nevertheless.
Alan.
PS: Just want to say 'Thanks!' for your efforts - fantastic work!
PPS: How do you get the URLs to show properly rather than as [www.ipredict.co.nz] ?]]>Alan3285Ask A QuestionMon, 01 Mar 2010 21:47:42 +1300/forum/read.php?20,5133,5467#msg-5467Re: Data
/forum/read.php?20,5133,5467#msg-5467
I think the API URLs have changed, although there seems to be some kind of redirect from the old URLs:
I have noticed some of the minor API functions have stopped working or work differently, for example, action=tradeHist has stopped working (gah) and action=stock&results=extended is no longer giving out detailed information for closed stocks :(.
Anyway Alan, do you want just the current price data for all contracts, or the order book data for all contracts? I can do all the current prices quite easily, but I think the second one will take too long to load.]]>pipe42Ask A QuestionMon, 01 Mar 2010 20:51:06 +1300/forum/read.php?20,5133,5466#msg-5466Re: Data
/forum/read.php?20,5133,5466#msg-5466
Any idea why it is that when we try to get the data direct from the IPredict API it fails, but it works fine from Pipe's website?
I am intrigued as to what is causing the problem.
Also, is there any way to get all the price data for all open contracts in one go from your site Pipe?
Thanks,
Alan.]]>Alan3285Ask A QuestionMon, 01 Mar 2010 20:07:22 +1300/forum/read.php?20,5133,5284#msg-5284Re: Data
/forum/read.php?20,5133,5284#msg-5284
adminAsk A QuestionMon, 22 Feb 2010 09:24:00 +1300/forum/read.php?20,5133,5278#msg-5278Re: Data
/forum/read.php?20,5133,5278#msg-5278
pipe42Ask A QuestionSat, 20 Feb 2010 13:11:04 +1300/forum/read.php?20,5133,5276#msg-5276Re: Data
/forum/read.php?20,5133,5276#msg-5276
3peterAsk A QuestionSat, 20 Feb 2010 12:58:22 +1300/forum/read.php?20,5133,5274#msg-5274Re: Data
/forum/read.php?20,5133,5274#msg-5274
Quote Microsoft
Our product won't do what you want, we know all about it, and no, we aren't going to help you fix it.