Printer friendly version :: Excel Extractionand general ramblings - Newhavensoft forum

Нет доступа к файлу data/boardinfo.php или нарушена его структура, либо не верно задан путь к файлам форума! Проверьте права. Printer friendly version :: Excel Extractionand general ramblings - Newhavensoft forum

Newhavensoft forum »Newhavensoft.net forums » Odds Wizard » Excel Extractionand general ramblings

1. audio2 - 06 August, 2006 - 18:48:47

Hi
Been registered to Odds Wizard for the last couple of months, got to say it is very impresive.
In my studies before using Odds Wizard I found that the bookmakers odds where correct, about 50% of the time ie pick two home bankers you got one right maybe the other a draw or loss
I also find the same trend with odds wizard.
I am currently looking for a consistent trend, if it exists?
My main question is
I export the odds to an excel file and import to Lotus approach.
Believe me lotus approach is extremely powerfull, and is much more user friendly and configurable than MS access.
What I would like to ask if it is possible to have the league and date to appear in the first cell next to the fixture instead of above each league.
This would benefit sorting the fixtures showing the league and date in order as opposed to showing just the fixtures.
It would be good to see the league and date next to the fixture.
If this could be introduced in the future I would find it very useful

also one trend I have found that seems to be fairly consistent is
if you look at the correct score tab and the figure for OTHERS is LESS than 7.4 and then Back over 2.5 Goals

Thanks

Audio2

2. Alex - 08 August, 2006 - 04:56:33
Thank you for appreciation!
Quote:
What I would like to ask if it is possible to have the league and date to appear in the first cell next to the fixture instead of above each league

It is possible to implement such feature as an additional exporting option in the next version(s).
Quote:
if you look at the correct score tab and the figure for OTHERS is LESS than 7.4 and then Back over 2.5 Goals

It is fairly natural. The more goals are expected, the more possible scores are expected too. This means that total probability to have a score within a predefined set of scores (0:0...2:3) shown in 'Correct scores' tab, is decreased while the chances of all others (column 'Others') are increased.

3. DocSander - 11 August, 2006 - 08:18:41
These lay-out issues can very well be sorted out by creating an excell macro of simple copy-paste tasks...

Good luck

4. AmirD - 11 August, 2006 - 13:11:37
I agree with Docsander.
Using functions within Excel does the trick.

5. audio2 - 11 August, 2006 - 18:27:43
Thanks for the input fellas

I need to create 2 new columns to the left of all the data, copy the date and league name to the 2 new columns.
Then copy each date and league name to the end of each league.
Because the fixture list varies with each results update, I can not see how you could do this because the amount of fixtures varies with each extraction for each league.
I have set up macros to delete and update records without any copying and pasting and the whole process is completly automated.
But I can not see a way to automate shifting the dates and league names across to the left and down because of the variables in the fixture list.
Any help would be appreciated

Thanks

OW pointed me towards Zwolle, Dijon, and FC Lustenau tonight
3 out of 3 Get In!!!!! Home Lay, Home Win, and over 2.5

6. AmirD - 12 August, 2006 - 00:52:35
audio2
A sample file has been sent to you.

7. audio2 - 13 August, 2006 - 14:08:15
BRILLIANT..........

Thanks for your help AmirD I see what you have done in the sample you sent.
I have used your sample to input my extracted odds and it works great

THANKS FOR YOUR HELP....

I owe you one.

Audio2

8. xej - 27 August, 2006 - 04:14:05
Hi,
I have the same problem with the league and the date, could you please send me this sample ?
thanks

9. AmirD - 27 August, 2006 - 14:07:00
xej
Send me a mail, topic: sample.

10. xej - 27 August, 2006 - 15:09:19
I cannot see your email in your profile, so i sent you a pm with mine. Thanks for your help !

Powered by ExBB 1.9.1
Original design Created by subBlue
Localized by onScreen solutions

[ Script Execution time: 0.0144 ] [ Gzip Disabled ]