Author Topic: Excel notepad query  (Read 5827 times)

Tags:
  • All members
  • Posts: 829
Excel notepad query
« on: 10 Aug 2015, 07:58 »
Hi,

I have a question relating to Notepad when using Excel.
What is the correct protocol when entering a horse name into Notepad ?
Often I get a 'FALSE' log message when reading from the Notepad file.
The file destination is correct.
Thanks
R
My grandma taught me not to run downstairs and never back odds on.

  • Moderator
  • Posts: 3605
*
Re: Excel notepad query
« Reply #1 on: 10 Aug 2015, 12:57 »
Hi racepro
Selection name spelling should be exactly as on Betfair. It's a string so it has to be enclosed in quotes, and is case-sensitive.
http://community.welldonesoft.com/troubleshooting-8/'is-in-file'-problem/
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 829
Re: Excel notepad query
« Reply #2 on: 10 Aug 2015, 13:10 »
Thanks Mark, I wasn't using the "" marks. strangely though, it did work on some races
without them.
R
My grandma taught me not to run downstairs and never back odds on.

  • All members
  • Posts: 365
Re: Excel notepad query
« Reply #3 on: 10 Aug 2015, 13:39 »
strangely though, it did work on some races

Hi racepro, I think it works on selections name with only one name (without space).


  • All members
  • Posts: 829
Re: Excel notepad query
« Reply #4 on: 10 Aug 2015, 14:09 »
You maybe right Tupp as it did work for me using one word horse names, however probably best to follow Mark's advice as that is likely to be the correct protocol.
I'll report back today after placing bets.
R
My grandma taught me not to run downstairs and never back odds on.

  • All members
  • Posts: 829
Re: Excel notepad query
« Reply #5 on: 10 Aug 2015, 20:15 »
Hi,
The bets were placed correctly using the "" format as suggested by Mark.
However I am using    winner_name   in one of my conditions to post the div.
and it is not reading the name on the notepad.
Should I be using      "winner_name"  (The "" added)  ?
I can try it but winners are thin on the ground :) I'll probably get a reply first
Thanks again
R

My grandma taught me not to run downstairs and never back odds on.

  • Moderator
  • Posts: 3605
*
Re: Excel notepad query
« Reply #6 on: 11 Aug 2015, 18:40 »
Hi racepro
In case you did not test it, yes, enclose the variable in your expression in double quotes. From a soccer market:
s_1_sel_name returns Under5.5Goals
"s_1_sel_name" returns Under 5.5 Goals
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel notepad query
« Reply #7 on: 07 Mar 2017, 03:13 »
From what I read in this thread I am doing everything right but
Selections name is in this file - Doesn't work
My lookup file is a text file.
I use "" for all names as some have spaces while other don't
Punctuation marks are removed in accordance with Betfair.
The names have a leading Capital

Example in text file "Harnova"

However the Trigger log results in FALSE:
Selection: 1. Harnova, initial expr.: "harnova", intermediate: "harnova", final: "harnova".

Improvise Adapt Overcome

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel notepad query
« Reply #8 on: 07 Mar 2017, 23:45 »
Support - Would having the trigger already connected to a spreadsheet be an issue?
Improvise Adapt Overcome

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel notepad query
« Reply #9 on: 08 Mar 2017, 06:08 »
I haven't used this method for Horse's name before and it seems very simple but it doesn't work.
For a Horse with a Name Media Baron, in my text file I used
"Media Baron"
"media baron"

neither recognized by MFPro?
See image.
Any Suggestion Oxa, McBee, Mark V
Improvise Adapt Overcome

  • Desenvolvedores de trigger
  • Posts: 919
  • Gender: Male
*
Re: Excel notepad query
« Reply #10 on: 08 Mar 2017, 13:18 »
Desenvolvedor de triggers oficial Market Feeder pro

Também faço:
Cursos sobre Market Feeder pro (gratuitos)
Triggers (gratuitos para sempre)

Para saber informações contacte-me!

NOTA: TESTE SEMPRE OS SEUS TRIGGERS ANTES DE OS USAR COM FUNDOS REAIS!

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel notepad query
« Reply #11 on: 10 Mar 2017, 11:16 »
I've tried everything.
Only 1 trigger with 1 condition.
Still won't work.
Improvise Adapt Overcome

  • Moderator
  • Posts: 3605
*
Re: Excel notepad query
« Reply #12 on: 10 Mar 2017, 15:01 »
Hi londolozi
long shot, try:
selections trigger expression "sel_name" is in file...

this one also worked when I tested just now
Please read the following disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel notepad query
« Reply #13 on: 10 Mar 2017, 20:11 »
It appears to be a connection issue.
If I have or did have (same PC session, no hard reset) a profile (any profile) connected to an excel worksheet, 'in the file' does not work.
I will keep testing today to confirm 100%
Improvise Adapt Overcome

  • All members
  • Posts: 490
  • Gender: Male
Re: Excel notepad query
« Reply #14 on: 11 Mar 2017, 01:41 »
BUG CONFIRMED (on my system):

Selections Name 'is in the file' does not work if any operating profile is connected to an Excel session.

I was having problems when the profile was started after the excel profile was already running.

Today I started a profile that worked ( 'in the file') standing alone before the excel profile was started. However, I encountered the same problem with the 'in the file' profile. It reads the text file but the Condition results in FALSE even though Conditions are TRUE.

Could someone test this.
Two profiles, one connected to excel. Regardless of markets.
The second uses Selections Name 'is in file'
Improvise Adapt Overcome

 

Please note, BetFair is seems to be currently OFFLINE